Forum Replies Created

Viewing 15 posts - 16 through 30 (of 90 total)

  • RE: STUFF - 2

    David in .AU (12/11/2012)

    L' Eomot Inversé (12/11/2012)

    The general idea of null is that it means "it is not known what this value is"; if I replace some characters in a...

    December 11, 2012 at 2:58 pm

    #1567631

  • RE: STR

    I answered the QotD based on how I received it (STR(123.45, 2, 2)) via email. The Webpage currently lists a different statement (iirc, STR(987.65, 2, 3)) -- please correct...

    October 18, 2012 at 11:18 am

    #1550622

  • RE: ISNULL

    Like many of you, I found this QotD [too] easy to answer. Perhaps it would have been a bit more challenging if an answer choice was "Error" :hehe:.

    August 8, 2012 at 12:36 pm

    #1523339

  • RE: Rename column

    Thanks, PravS, for a good QotD. I didn't think we would be allowed to rename a computed column, but the MSDN page on sp_rename (e.g. http://msdn.microsoft.com/en-us/library/ms188351.aspx) didn't...

    July 25, 2012 at 1:31 pm

    #1517606

  • RE: Union and Union All

    Toreador (7/9/2012)

    I thought it looked familiar!

    http://www.sqlservercentral.com/Questions/Tags/UNION/UNION/

    Except that the earlier QotD was more challenging for me (and I got it wrong because I thought UNION took precedence over UNION...

    July 9, 2012 at 12:35 pm

    #1510512

  • RE: Execs and temporary tables

    Thanks for the question! but the set of possible answers was "too easy": once I saw that B#2 was going to error out while B#3 was not, I didn't look...

    July 6, 2012 at 11:50 am

    #1509830

  • RE: NULLIF 1

    Thomas Abraham (6/26/2012)

    Thanks for the question. Never used NULLIF, so forced me to investigate.

    I got my point, but am inclined to agree with those that feel that the question could...

    June 26, 2012 at 8:43 am

    #1505617

  • RE: SQL Server Logs

    jeff.mason (6/1/2012)

    Not so much a guess for me as process of elimination -- I have had to make use of the other three constantly as a DBA, so that was...

    June 1, 2012 at 9:55 am

    #1495955

  • RE: SP

    Hugo Kornelis (4/26/2012)

    I love the "don't know" option, and I agree with the poster above that those who rightfully tick that box should get a point. 😉

    Only if they can...

    April 26, 2012 at 10:42 am

    #1479906

  • RE: VIEWS 4

    cengland0 (3/27/2012)

    You got me on this one. I didn't know this would produce an error and according to the current stats on who answered it incorrectly, I'm not the...

    March 27, 2012 at 10:45 am

    #1465147

  • RE: Concurrent Administration

    ...I immediately answered Yes to this question because I thought of two different databases and filegroups. So it is possible to do a full backup and a shrink at...

    January 25, 2012 at 8:03 am

    #1438242

  • RE: Network Protocals

    KWymore (11/7/2011)

    Nice Monday question. Never looked into VIA before so I figured that was the answer.

    Answering this QotD was also a "process of elimination" for me -- I knew that...

    November 7, 2011 at 1:12 pm

    #1404155

  • RE: Constraints

    Britt Cluff (10/17/2011)

    Thanks for the question. I was pretty sure the check constraint would allow the NULL value.

    Ditto x 2. Just wanted to add that some Neanderthals (e.g. my...

    October 18, 2011 at 2:35 pm

    #1396339

  • RE: exceptional logic

    Rob Schripsema (10/11/2011)

    Outstanding question -- not only on Except/Intersect, but also on operator precedence....

    Agreed! Like some of you, I didn't know INTERSECT had higher precedence than UNION and EXCEPT.

    October 11, 2011 at 11:45 am

    #1393025

  • RE: SQL Server Agent job information

    stewartc-708166 (7/27/2011)

    Quick and easy for a Wednesday morning.

    and I haven't even had my morning coffee yet...

    Judging from some of the sarcastic back&forth in the, so far, four pages of "discussion,"...

    July 27, 2011 at 8:30 am

    #1359304

Viewing 15 posts - 16 through 30 (of 90 total)