Viewing 15 posts - 316 through 330 (of 370 total)
Which IE version? One should be very careful to post an answer referring to a specific application without an explicit version. Sorry but not all machines will have the same...
September 3, 2011 at 3:52 pm
tommyh (8/22/2011)
It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for a...
September 3, 2011 at 12:57 pm
Excellent article and great discussion about it here! Thank you.
Best regards,
September 1, 2011 at 9:13 pm
Hahahahahahaha.
The "distributed" part was hilarious. 😀
Best regards,
August 30, 2011 at 9:09 pm
christian.stahl (8/30/2011)
When I ran your test against a table with 18,399 rows I got these results:
if exists (select count(*) from A )
print...
August 30, 2011 at 9:00 pm
Sometimes when something is very obvious I think to myself that there must be a catch or an SQL Server limitation of some sort. The only other possible answer was...
August 26, 2011 at 2:44 pm
Great article. Thank you.
Best regards,
August 25, 2011 at 11:21 am
I though to myself if this was a tricky question when I read it... I'm glad it wasn't.
@data_god: I guess what the script is doing is reconfiguring your...
August 25, 2011 at 5:37 am
Although I have read a book or two to study for the exams I must say that BOL has become a wonderful reference specially with the many examples illustrating every...
August 8, 2011 at 2:43 pm
That's a great question but it doesn't seem too consistent. I would expect the query to return no errors only if both ARITHABORT and ANSI_WARNINGS were set to OFF.
Best regards,
August 7, 2011 at 6:32 pm
mike.mcquillan (8/7/2011)Forget the exam for a moment - to make yourself more marketable and to help you win those bigger salaries, you need to keep improving your skill set. Learning...
August 7, 2011 at 5:42 pm
Easy question. You get it right by analyzing the innermost queries first and then understanding how the NOT IN operator works in the outermost query.
I love this kind of questions....
August 7, 2011 at 5:26 pm
Since T-SQL is mentioned on that tab I was diving a bit deeper in that. The training and learning towards the exam is as important as passing the exam.
Indeed. But...
August 6, 2011 at 7:24 pm
CiroM (8/5/2011)Before I head for the MCTS exams I will improve my T-SQL Skills first as I am not a (full-time) DBA.
T-SQL is not a priority for DBAs, IMHO.
I know...
August 5, 2011 at 6:58 pm
I wonder when the new Denali exams will be ready and if they will make those exams "legacy". Maybe the 70-432 and 70-450 will still be valid for another 4-5...
August 5, 2011 at 6:45 am
Viewing 15 posts - 316 through 330 (of 370 total)