Before you partition, you need to know, that if you get partition scans, performance will be worse than before you partitioned. So, when partitioning, we should only do it, if...

There is a HUGE difference between Managed Instance and Azure SQL Database. So, as everyone has pointed out, if you're in Azure SQL Database, the standard three-part multi-database queries will...

The Service Packs and the Cumulative Updates are, as the name says, Cumulative. They include all previous stuff. While there can be exceptions if you need a particular security patch...

There is actually quite a bit of overlap between those two books. However, the Fundamentals book goes much slower in explaining SQL concepts as well as T-SQL specifically. Where as...

To my knowledge, discipline is your only friend here. Keep the files in a defined place. Use naming standards that help you clarify what a thing is for, then clean...

There are functions like ISNUMERIC() and others that can determine if a given value is of that type. However, they're very dependent on exact formats. Most data imports...

It's probably just evidence of a given query exiting cache for whatever reason it exited cache. All the execution DMVs are cache dependent. Any given query that leaves cache, for...

Or, look at a tool like Redgate SQL Compare. That lived open, and in active use, all day, every day, on my machine until I was hired by the...

Yep, what @johan says.

Think internal and external to the database. External to the database, server and OS level stuff, no. It's not there to worry about. Internal to the database,...

Use Extended Events to capture the metrics. That's how I'd do it.

Wait, a deadlock is an error that will clear immediately. It won't lock the server and prevent access. I think you're saying that you're getting blocking that is preventing access....

But, from what I can see, the Payment_ID column matches to a value 67280309 for Reissued_from_payment_id. How do you related it to 33333 when the payment_id for that is 22222?...

Have you identified what query specifically it's trying to run and the structure of that query? Use Extended Events to track that down.

I'm one of those to push myself to learn. I'm often disappointed with myself for not learning more, faster. I think I'm concerned that if I don't push myself,...

My personal challenge workwise is to learn WhereScape and Snowflake to build a warehouse from our two major Health Care systems plus the myriad of one-off systems we have...