Viewing 15 posts - 61 through 75 (of 212 total)
Koen Verbeeck (9/11/2013)
Maybe your post should focus more on the fact that this bug is already resolved.The fix can be downloaded here:
Yes,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 11, 2013 at 2:26 pm
The title of the question has nothing to do with the trick question with the IsNULL() function and the variable length. The question only proves that IsNull is using the...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 11, 2013 at 1:56 pm
+1 Thank you for this easy one. I've been educating people about the news in SQL server 2012 and I really like this function. Not becase the possibility to concat...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 22, 2013 at 2:31 pm
L' Eomot Inversé (8/20/2013)
hakan.winther (8/20/2013)
+1 Learned something new today. The leaderbord has a bug, is that the reason why I am not at the top? 😀
I doubt it; probably the...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 20, 2013 at 10:10 am
+1 Learned something new today. The leaderbord has a bug, is that the reason why I am not at the top? 😀
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 20, 2013 at 5:52 am
Nice "tricky" question! Thank you!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 8, 2013 at 12:14 am
kapil_kk (7/22/2013)
PRR.DB (7/22/2013)
Is...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 22, 2013 at 2:49 am
Easy question, as long as I ignore the fact that some instances may require case sensitivity because of the applications using the db (well... not written by me, but probably...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 17, 2013 at 5:48 am
Nice question!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 26, 2013 at 2:08 am
Nice question, but the right option is missing. Row locks are never escalated to page locks according to BOL.
"The Database Engine does not escalate row or key-range locks to page...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 26, 2013 at 1:46 am
Well, this was an easy one!
You can use table variables in some type of functions, but not in all. You can't use(declare) a table variable in an inline table...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
December 18, 2012 at 6:53 am
Nice question, I was only focusing on the string concatenation and not the declaration.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 7, 2012 at 12:38 am
Nice question!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 3, 2012 at 6:58 am
I knew it couldn't be a simple answer, but I answered based on what it should have been if it wouldn't have been the CASE difference. I don't like questions...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 1, 2012 at 3:33 am
Viewing 15 posts - 61 through 75 (of 212 total)