Forum Replies Created

Viewing 15 posts - 151 through 165 (of 232 total)

  • RE: Getting index columns

    Yay! I got it right!

    April 17, 2016 at 11:00 pm

    #1872643

  • RE: Log Shipping Information

    Stewart "Arturius" Campbell (4/15/2016)

    Rune Bivrin (4/15/2016)

    Ah, well. Got to read a bit about log shipping. That's worth something.

    Is it only me who thinks Steve's error quota for QotD has risen...

    April 15, 2016 at 2:51 am

    #1872250

  • RE: Log Shipping Information

    Ah, well. Got to read a bit about log shipping. That's worth something.

    Is it only me who thinks Steve's error quota for QotD has risen considerably as of late?:hehe:

    April 15, 2016 at 2:42 am

    #1872244

  • RE: Temporary Table Limitations

    patricklambin (4/7/2016)

    But I was really interested by the others posts which learnt much about the differences between Great Britain and USA in language even if with the same name. So...

    April 8, 2016 at 12:14 am

    #1870708

  • RE: Temporary Table Limitations

    GAH! I hate double negatives.

    April 6, 2016 at 2:31 am

    #1870066

  • RE: Select vs Set Local Variable

    Stewart "Arturius" Campbell (3/31/2016)

    The MAXDOP setting will let the enginre use parallel processing where the optimiser considers it neccessary, alternatively, use the MAXDOP query hint (but definitely not on a...

    March 31, 2016 at 5:35 am

    #1868800

  • RE: Equality on Nullable Columns

    Toreador (2/17/2016)

    Incredible that at the time of writing, only 75% got this right!

    Yeah, well I read it a bit too quickly, and couldn't quite accept the idea of a nullable...

    February 18, 2016 at 7:25 am

    #1859566

  • RE: EXECUTE AS procedures

    It's somewhat interesting that the topic cited for reference disagrees a great deal with this:

    MSDN EXECUTE (Transact-SQL)

    Aah! Now I see it. Not specified when executing the SP, but when creating...

    February 1, 2016 at 6:38 am

    #1855661

  • RE: The Lonely Count

    Hugo Kornelis (1/7/2016)

    Hugo Kornelis (1/7/2016)

    Rune Bivrin (1/7/2016)

    Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up...

    January 7, 2016 at 1:58 pm

    #1850347

  • RE: The Lonely Count

    Hugo Kornelis (1/7/2016)

    Also note that the syntax diagram suggests that not only the ORDER BY clause, but also the OVER clause itself is mandatory (though the text of the article...

    January 7, 2016 at 5:02 am

    #1850141

  • RE: The Lonely Count

    Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up to SQL 2012....

    January 7, 2016 at 1:05 am

    #1850116

  • RE: Filestream filegroups

    Where can I buy SQL Server 2015?:hehe:

    November 25, 2015 at 2:27 am

    #1842256

  • RE: Job Schedules

    webrunner (11/10/2015)

    Iwas Bornready (11/10/2015)

    I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed int.

    I knew that...

    November 10, 2015 at 8:23 am

    #1838868

  • RE: How long do they last?

    Thanks for this one! Got it wrong and learned something quite useful.

    April 23, 2015 at 12:15 am

    #1792925

  • RE: BULK INSERT first row

    I was very torn between "3" and "Not supported". Based on the following in the cited documentation, I kind of felt both were correct:

    The FIRSTROW attribute is not intended to...

    April 7, 2015 at 1:32 am

    #1789111

Viewing 15 posts - 151 through 165 (of 232 total)