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.

Thanks for the feedback, Grant.  I am concerned.  While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some" thrash and having...

Have any of you good folks used the "Automatic Tuning" feature of SQL Server 2016 for on-prem?  If so, how'd it work out for you?

I ask because I have...

Grant,

Thank you for your input. It is as valuable for me as all your comments and guidance always are, both here at SSC and in your books (I can...