...

There's a series of five articles about SQLFacts right here on SQLServerCentral (1, 2, 3, 4, 5)! The toolkit has grown a lot...

Ha, hardly, lots of complaints about this, but with regulation all...

One of the folders on my machine is called "DevTools" with the following contents. Some that I've highlighted in bold are ones that I use often and/or I think...

Perhaps something in the restore statement, but glad it's working and thanks for the followup.

If this is a one off, then instead of the studentid in the SELECT, then put the scalar value instead.

As Drew noted, however, make your question easier for people to...

Not sure, but with data, often it's something small I've missed.

Rather than this join, what I'd pick is a row or two that I  am struggling with and limit my...

Lol, I book flights constantly, so a different perspective. Often I want a 4 day or 7 day trip, so moving one date should move the other. That's a handy...

I don't think IQP is the end-all, and in many cases, poorly written procedures that are "catch-all" still can perform really poorly. The IQP stuff tries to reduce the edge...

If you plug into SSMS, then you're not learning. You're gaining points, but the idea is to test yourself and see if you can answer.

Our office started using Slack a couple of years ago.  There was little instruction, no best practices.  People added me to channels and I had no idea why.  I...

lol, I like that. I have tended to be...

So far I'm eeking things out. Somehow despite a nice comeback from Mr. Allen, Mr Mahomes exceeded expectations again.

I'm worried about bye weeks now.

I guess you might need to check the table exists. Sorry, I saw this on mobile and missed the "table" note in your comment.

Hadn't thought about checking for a table...

That's what alter table drop column if exists does.

SQL in a Nutshell from O'Reilly from Kevin Kline is also good