Every single query is using some CPU. Depending on what the queries are doing, sorts, etc., more CPU is necessary to figure things out. Parallelism causes CPU because a given...

You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It's all...

Redgate has grown to be a very successful company with a declared profit of 9.7M GBP in 2019 Fin Year....so it's not like they couldn't afford to sort...

Without seeing what you're talking about specifically, the session you have defined, I can't say what you're seeing or why.

Yes, Extended Events captures this information. In fact, unknown to most,...

@Grant, I am having same issue. Execution plan "Output List' says 3 columns, col1, 2 and 3 above that Object" is 'PK_id'.

I understand if you add those columns to...

So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host of...

How big are those indexes? Small ones simply can't be defragmented.

BTW, common practice now is to kind of ignore fragmentation. It's just not that big a deal. In fact, constantly...

Total agreement that the system_health Extended Event session is the way to go. Here's a sample query that shows how to pull deadlock information out. You can also use...

Sounds odd. It's working on my machine, both SQL Server & PostgreSQL.

Connection issue?

So my interview question of the day would be - "tell me about logging in SSIS" or "how do you write to the log table in SSIS?" And if...

Filestream just isn't supported on Azure SQL Database or Managed Instance. You just can't use it at all. I haven't tested this particular scenario with the Migration...

Since you're in 2008, you can take advantage of the system_health Extended Events session. system_health contains deadlock information that you can query as outlined here (yeah, yeah, RDS, but...

I generally advocate against using the ring buffer. It affects the memory of the server in a negative way, worse than simply negative depending on what you're capturing. Instead, I...

Is the query scanning the existing index or seeking against it? If it's a seek, and it's the cluster, I'm not entirely sure you'll see much of an improvement with...

Keep an eye on CPU and waits, before and after.