I'm a little late to the discussion, so sorry if this is not useful.

It sounds little like you're trying to get something decent, but at no cost. Within...

This part of the query pattern is going to kill performance dead:
AND (ISNULL(A.ACCOUNT_NBR,''))

If nothing else, I'd find a way to restructure your data...

Still here I see.

On further review, I was right and wrong at the same time. Extended Events does support capturing this information, but, it's through events that are not user configurable. You have...

Everything that Gail says, plus, you have to track it over time to see how your server behaves. For example, we had a nightly load process that would dump the...

What you'd be looking at is the system_health Extended Events session. You can read up on what it does here. It doesn't monitor security changes. You can pretty...

I'm actually not a fan of the Microsoft Certifications, however, the skills they test actually provides a pretty good set of standards by which you could measure someone on their...

Look at the execution plans from the two different approaches. That should tell you what's going on with SQL Server.

Without seeing the queries and the plans, I can...

Fellow Threadizens!

Today is my last day of work before Red Gate makes me take a six week sabbatical. I'll try answering a few questions today and then I'm off until...

One thing you can do (assuming you have disk space) is restore the database to another location and then run DBCC on that. There are a few types of errors...

The inner procedure is running under the ownership of the outer procedure. It's similar to how you can give someone permission to a procedure but not to the underlying tables....