Forum Replies Created

Viewing 15 posts - 256 through 270 (of 341 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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 to see...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • 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...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

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