Forum Replies Created

Viewing 15 posts - 46 through 60 (of 105 total)

  • RE: Temporary Tables and Statistics in Stored Procedures

    Tony Bater (4/11/2014)

    I am happy to say I got this right, but not so sure about the reason!

    I didn't know the answer (so learned something here, and that's good), but...

    April 11, 2014 at 3:29 am

    #1705162

  • RE: Default schema

    Louis Hillebrand (3/31/2014)

    +1 to the above

    points back please..

    +1...

    Crystal balls are not working Monday morning...

    March 31, 2014 at 1:42 am

    #1701490

  • RE: Valentines Day

    BWFC (2/14/2014)

    The cynics amongst us might say there are two appropriate answers though!

    +1

    :-D:-D

    February 14, 2014 at 1:26 am

    #1688992

  • RE: Compression

    Thanks for the question!

    It's pretty much the same as if you try to zip (or rar or whatever) an already compressed file... there's no much room for compression there! 😀

    January 30, 2014 at 2:20 am

    #1684557

  • RE: Mastering Dimensions of Time

    Jeff Moden (1/21/2014)See the example code that Luis posted above for one possibility.

    I did and I read the article you published, and I really enjoyed reading it, thank you...

    January 22, 2014 at 2:03 am

    #1682294

  • RE: Mastering Dimensions of Time

    davoscollective (1/21/2014)

    Ah yes you are correct, my mistake, the maxrecursion 0 removes the limit. I agree, go for the better performing code. It is one statement, but internally it is...

    January 21, 2014 at 7:33 am

    #1681902

  • RE: Mastering Dimensions of Time

    davoscollective (1/21/2014)

    This is equally valid, but it's still row by row. Recursive CTE's are just as much a loop as a while loop. You are also limited to ~32000 iterations...

    January 21, 2014 at 6:58 am

    #1681875

  • RE: Mastering Dimensions of Time

    PHYData DBA (1/20/2014)There might be several other ways of doing this without using a Row By Row script. We could not find one that was as easy to read and...

    January 21, 2014 at 6:09 am

    #1681851

  • RE: Tempdb

    Thanks for the question,

    Since you cannot backup tempdb, it doesn't make much sense to be able to change the recovery model 😀

    January 20, 2014 at 3:26 am

    #1681472

  • RE: Database Collation Is Null

    What happens when you run this? select DATABASEPROPERTYEX('@#$@#$@##$DB', 'Collation')

    That returns NULL...

    I see the same results. This underscores one of the main assumptions of QOTD. If not stated, we need to...

    January 20, 2014 at 1:54 am

    #1681449

  • RE: Database Collation Is Null

    PHYData DBA (1/17/2014)

    raulggonzalez (1/17/2014)

    Connection settings are the default, I tried from my 2012 SSMS and using 2008R2 SSMS in a remote desktop, (default connection settings) and both return values for...

    January 17, 2014 at 9:16 am

    #1681125

  • RE: Database Collation Is Null

    PHYData DBA (1/17/2014)

    raulggonzalez (1/17/2014)

    Thomas Abraham (1/17/2014)

    raulggonzalez (1/17/2014)

    Thanks for the question, but I have to disagree with one of the answers.

    I have a number of offline databases in one of my...

    January 17, 2014 at 8:51 am

    #1681104

  • RE: Database Collation Is Null

    Thomas Abraham (1/17/2014)

    raulggonzalez (1/17/2014)

    Thanks for the question, but I have to disagree with one of the answers.

    I have a number of offline databases in one of my servers and the...

    January 17, 2014 at 7:11 am

    #1681058

  • RE: Database Collation Is Null

    Stuart Davies (1/17/2014)

    raulggonzalez (1/17/2014)

    Thanks for the question, but I have to disagree with one of the answers.

    I have a number of offline databases in one of my servers and the...

    January 17, 2014 at 3:37 am

    #1681008

  • RE: Database Collation Is Null

    Thanks for the question, but I have to disagree with one of the answers.

    I have a number of offline databases in one of my servers and the following query returns...

    January 17, 2014 at 2:20 am

    #1680988

Viewing 15 posts - 46 through 60 (of 105 total)