kramaswamy (1/11/2016)

---

Perhaps I should have given a bit more insight - the input for the stored procedure is a TVP because the caller is a .NET application. Rather than sending...

Automation is your bestest buddy.

You're not going to test every backup every night. Start with the vital ones. Figure out how often you can test them, more is better. Automate...

That's a job for SQL Server Integration Services, SSIS. You can do a search for SSIS & Interbase to find lots of information on how to integrate between the two....

You can only do that if you have the tail log backup of that time. Based on what you said, you don't. So you can only restore to the last...

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did it better.

Eirikur Eiriksson (1/10/2016)

---

Grant, the link to your article doesn't...

Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.

Steve Jones - SSC Editor (1/8/2016)

---

BTW, apparently the quality of my writing has also gone down. Got this lovely note today

Your article today compels me to seek your “Unsubscribe”...

I'm with Kevin, this is probably a very involved situation.

However, to at least get you started, I'd look at sys.dm_os_wait_stats to understand what is causing the system to run slow....

Yeah, I too thought the keys were stored at the leaf level. I'm positive Gail knows that. It must be a misstatement or misinterpretation of what she said.

That's not something I've seen, so I don't have an explanation for it. Have you patched your SSMS installation? Assuming SSMS is running locally, even if you've regularly patched the...

I'm with Hugo and Lowell. I'll just offer an alternative to using Ola's scripts (nothing wrong with them, I just like choices). You could check out MinionWare[/url]. They have a...

You can absolutely do it on your own. Performance Monitor, perfmon.exe, is the first thing to start with. You can capture system and SQL Server specific metrics from that. Next...

I can also strongly support using Minion Reindex. It's free from MinionWare[/url]. It does an excellent job of managing indexes & statistics.

Roughly the same execution plans really translates as, different execution plans. As Gail says, look to the row estimates to understand where the differences are coming from.