This is a tough process. First up, testing is your buddy. Plan to test your queries, a lot, before you just disable indexes willy nilly. Next, small changes. Only take...

This is a tough process. First up, testing is your buddy. Plan to test your queries, a lot, before you just disable indexes willy nilly. Next, small changes. Only take...

Are you getting more and more data? If so, that's the challenge (note, not a problem or an issue, just something you have to deal with). And yeah, it may...

Oooh, that's a good idea.

I truly hate hearing the term applied to me. I simply don't believe it. Can't. It's just not true. However, it does happen. And oh boy, you can see the...

The new kids prefer the term data engineer over DBA. Work & responsibilities are the same, but they really don't like the DBA moniker for some reason.

Well, I'll be there. Causing trouble. Saying stupid stuff. You know, the usual.

I see a day coming, and soon, where the work that today is done by a junior, or even a mid-level, DBA, will be readily replaced by AI. My concern...

Following on to what Steve said, when I'm doing sales & support work at Redgate, talking to clients, they'll say something like "You should do this with Product X". My...

Nope.

"The name of the secondary database must be the same as the name of the primary database."

That's from here.

Partitioning, first and foremost, is a data management tool, not a performance tool. We must be up front and clear with this. If you partition any tables, let alone every...

Hey All,

Steve's on the road in Australia, so I'll let him respond here when he gets around to it. I just wanted to let you know why you might not...

Thank you Grant for bringing up the important subject of self care. There are numerous youtube videos that you can find on the subject. But they all seem to...

And, it looks like the code is hitting this table, [CoreV2].[HCM].[Employee_Info_Master].[EmployeeInfoMaster_List_Name_Top] [emp_CA], over and over again. You shouldn't have to reference the same table repeatedly unless you're getting different data...

Woof!

You have a bunch of plan affecting conversion warnings. I'd look to those as a first step. Nesting views, having a view that calls other views which joins to views,...