Forum Replies Created

Viewing 15 posts - 256 through 270 (of 340 total)

  • RE: Incompetent or Malicious

    jeff.mason (7/20/2010)

    Seems like there are a lot of communication and education issues between DBAs and the SAN guys. Here our problem with the SAN guys is that they hear...

    July 20, 2010 at 9:01 am

    #1195595

  • RE: Incompetent or Malicious

    The DBA, San admin and manager "share blame", but as a DBA, our first job, IMHO, is to protect the data. That means being involved in every aspect of the...

    July 20, 2010 at 7:53 am

    #1195534

  • RE: NULL

    Paul White NZ (4/13/2010)

    Hugo Kornelis (4/13/2010)

    "Assuming ANSI_NULLS are on in your SQL Server database, which they are by default..."

    Okay, I admit it - this snippet in the explanation is actually...

    April 13, 2010 at 6:35 pm

    #1151093

  • RE: NULL

    NULL means NULL is the best answer, but the discussion is the best part of the QOTD. Great explanations, especially Hugo. Good try at the question, submitter. Way to stimulate...

    April 13, 2010 at 11:15 am

    #1150927

  • RE: TRUNCATE

    vk-kirov (4/7/2010)

    Paul White NZ (4/6/2010)

    You posted that link and statement before!

    Oops... did I?.. :blush:

    I just want to say that your conclusion "if a command deletes rows, it's a DML" may...

    April 7, 2010 at 10:10 am

    #1147512

  • RE: TRUNCATE

    Paul White NZ (4/6/2010)

    Christian Buettner-167247 (4/6/2010)

    Well, this would not be the first time that there is incorrect documentation out there in MSDN. From what I undestand, the schema lock...

    April 6, 2010 at 1:47 pm

    #1146764

  • RE: Declarative Data Integrity

    Tom.Thomson (4/1/2010)

    Peter Trast (4/1/2010)

    You need to stop drinking those new Starbuck sized coffees http://www.starbucks.com/blog/10113/starbucks-listens-to-customer-request-for-more-sizes.aspx

    I mean, who really needs a 64oz. coffee??

    I made the mistake of following that url...

    April 1, 2010 at 1:15 pm

    #1144400

  • RE: Encryption

    Matt Miller (#4) (4/1/2010)

    Ric Sierra (3/24/2010)

    vk-kirov (3/23/2010)

    Ric Sierra (3/22/2010)

    this undocumented function is available since SQLServer 7

    PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot...

    April 1, 2010 at 12:02 pm

    #1144345

  • RE: Declarative Data Integrity

    Paul White NZ (4/1/2010)

    Tom.Thomson (3/31/2010)[hrOK, fair enough - but actually this time I was teasing Peter about his comment that you dislike T-SQL, not getting at Ron.

    Oh right, cool!

    You need...

    April 1, 2010 at 9:34 am

    #1144132

  • RE: TRUNCATE

    Paul White NZ (3/31/2010)

    Peter Trast (3/31/2010)

    Hey, people from middle earth can't boo! 😀

    Middle Earth, if you please 😛

    That was on purpose. I know how much the hobbits hate that... it's...

    March 31, 2010 at 9:00 am

    #1143156

  • RE: SSMS - feature

    Paul White NZ (3/31/2010)

    Peter Trast (3/31/2010)

    If you wait long enough, it should turn into a hand. I only saw it when I went back after being told about it. It...

    March 31, 2010 at 8:59 am

    #1143154

  • RE: TRUNCATE

    Paul White NZ (3/31/2010)

    Peter Trast (3/31/2010)

    Paul White NZ (3/31/2010)

    vk-kirov (3/31/2010)

    Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

    It is...

    March 31, 2010 at 8:44 am

    #1143143

  • RE: Declarative Data Integrity

    Hugo Kornelis (3/31/2010)

    Peter Trast (3/31/2010)

    Tom.Thomson (3/31/2010)

    Peter Trast (3/30/2010)

    Paul White NZ (3/30/2010)

    Thank you for making my head hurt!

    You don't like T-SQL much, do you? 🙂 Seems to have a bad effect...

    March 31, 2010 at 8:41 am

    #1143141

  • RE: Full backup Scenario

    Paul White NZ (3/31/2010)

    Thank you, Peter. Of course, there are some edge cases and subtleties, but unless Mr Randal appears and tells me I know nothing about nothing...I'm happy...

    March 31, 2010 at 8:38 am

    #1143140

  • RE: SSMS - feature

    Joe Stefanelli (3/31/2010)

    I also get nothing for the mouseover event. I can successfully ctrl-left click the URL, but no hint ever pops up.

    If you wait long enough, it should turn...

    March 31, 2010 at 8:14 am

    #1143112

Viewing 15 posts - 256 through 270 (of 340 total)