I believe that this does close to what you are looking for.  It can probably be massaged to do exactly what you want.  The big problem is that the...

I agree with Scott that such a query is going to return all the hotel rooms except "some" and will likely do a scan anyway.  So, just keep it simple,...

If you do build an index (non-clustered or clustered, doesn't matter) on the Unique Identifier column, build the index with a 71% Fill Factor and setup a job to...

• This reply was modified 3 years, 6 months ago by Jeff Moden. Reason: Forgot to specify the column

Your answer is here...

https://www.google.com/search?q=reverse+engineer+a+database+using+visio

I believe it needs to be the "professional" version, though.

How strange it is that this wonderful article resurface today.  It's provided some much needed motivation.  Thank you again for writing it, Phil.

Agreed on both.

Yes.  That would work but how often would you actually have a need that couldn't be solve easily, like Phil did?

Ah, sorry.  This article is strictly about 2022.  My mistake.

I guess I'd have to disagree,...

What I'd really like to see are companies that stop punishing people for not taking time off.  I've had more vacation just vanish because I had more...

You appear to be missing a few thinks under the production builds section. 😀  It shows up totally empty for me.

I totally...

The Performance Dashboard has an area for the most expensive queries.  Have a look at those.  Unfortunately, it doesn't tell you which part of some really long queries might be...

Wow, that's a very good article Jeff, comparing Pivot to Cross Tabs. I was noticing all your Pivots always have aggregate functions. What I am doing seems to involve...

So with my Joe Celko hat on 🙂

Is Room Number a numeric value or not?  Most people would say yes, but in fact I would say no.  The reason...