To be more specific, the "improvements" to TempDB, especially the one that adds TF1117 functionality (grow all files equally) and cannot be disabled even temporarily for TempDB because a bunch...

Hopefully, that's true.  The last person that told me that was at a company the I worked at temporarily.  They told me that AFTER I had already seen that it...

For the love of all that is holy in SQL Server, please tell me that your SSNs are NOT in plain, 9 digit...

Ok... no interest from the OP.  Unsubscribing.

It's a funny thing how things sometimes work out.  I told myself that I'd spend a little time cruising the net after I was done with work today and then...

It's easy to find out when technology is "good enough"... just wait a bit for the next change.  The trouble is, it's frequently the prior change that was good enough...

Have you checked the SQL Server logs for deadlocks?  And I'm pretty sure that the MS documentation is correct about MicroSeconds.

Perhaps it wasn't a trailing space.  Perhaps it's a "hard space" (Char 160 in ASCII) or something else like a "Control Character" (ASCII characters <= CHAR(31), which includes things like...

Thank you for the feedback.  And no problem on additional questions.

Lordy.  I'd be interested in knowing the...

Doesn't it just mean that the second IF failed to return a non-null, non-blank, numeric and so qualified for the third IF?

Put a SELECT @Result after the end and before...

hello, I'm nee here and new to SQL DBA, so forgive how pedestrian I am about to sound. I am learning to create filegroups using GUI and TSQL, I...

i want to know how i can use the date dimension table. I am trying to sum all my sales for month, quarter and Year...

Just to be sure, when you say "VSS", are you good folks talking about "Visual Source Safe"?

Now you know why I frequently quote the original post.  He also deleted the post on his other...