Weirdest thing, my subscription to The Thread got turned off. I just figured after a couple of weeks you guys had finally given up on this thing.

Yep. Tell them to stop. Unless of course they're also responsible for running the restores. In which case, check to see if they're running differentials and log backups and have...

That's an indication of disk load. Not necessarily an indication of problems in...

That does sound like either permissions issues, serious blocking issues, or maybe a combination of the two. I have seen the first error message before. It was on a system...

It depends on how you're getting it. If you have a deadlock graph that you've captured through extended events, or somewhere else, right click on it as you would an...

And you can pull that plan from the cache, even while the query is running. It will be in sys.dm_exec_query_plan(). You'll need to pass it a plan handle. If the...

Small company or not, I strongly recommend putting process for getting stuff out to production into place and following it religiously. The last thing you want are for changes to...

Yeah, I'd get the Upgrade Advisor from Microsoft and run that against your systems. That will give you the most important information, anything you have in your 2008 systems that...

DSNOSPAM (12/9/2014)

---

I guess it also goes against all my reflexes for other programming languages, which is to break a problem down into logical components.

SS seems to throw other constrictions in...

Everything is a balance. Just make sure you're breaking down the procs appropriately, not just to arrive at arbitrary small queries. But some degree of nesting, depending on how and...

I don't currently have an availability group set up in order to validate your script.

Probably, but not definitely. Or, more accurately, maybe not as much as you want. It's best to measure your performance to understand what's going wrong and why. Then make changes.

Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than that, yes!

Sean Lange (12/9/2014)

---

Here is where I am going to disagree with Gail and Grant. I have worked on a system that had many procs nested like this and it was...

OK, so, the last two make sense, it's waiting on the disk and on the log. The first one suggests CPU use. So, we're kind of back to where we...