I'd strongly urge you to avoid a tinyint.  Mainly because the room number is "904", not just 4 (and not 94).  If you think about it, "room 4" is...

@Eirikur...

I guess that I'd hunt down the people that designed that "edge case" and introduce them to pork chop dinners in a major way.

Heh... reminds me of the...

p,s, Also, are you using sp_SpaceUsed with the "updateusage" option enabled?  If not, you need to start.

I'm the DBA. We...

Two way street here... what was that "minor adjustment"?

Ok, so now find the code that's doing the blocking.  One way to do that is to look sp_WhoIsActive by Adam Machanic or Brent Ozar's sp_BlitzCache, read the instructions, download...

It's almost humorous as to the amount of irony in...

@Eirikur...

I guess that I'd hunt down the people that designed that "edge case" and introduce them to pork chop dinners in a major way.

Heh... reminds me of the battles I...

1. I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done?

2) I have few cols...

I wonder if instead of using literal number 8000, you could limit the number of rows in the first CTE

to count the number of delimiters in the string, but...

Why not reach out to the author of that article?

I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file

so the default cell format is text and not General. If not,...

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.

Or...

Knowing when the last index maintenance is nice to know... In conjunction with the two types of fragmentation, it helps alert you to which indexes might need some help in...

BTW, Steve... Congratulations on MVP #15!  WHOO_HOOO!