Brandie Tarvin (7/30/2015)

---

As I dig into this issue (Execution Plans HO!), I come across a thread in which one respondent posts a link to Gail's blog and then Grant shows...

Brandie Tarvin (7/30/2015)

---

Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?

Work...

Yeah, you should check out Minion Reindex[/url]. It's part of the MinionWare suite[/url]. It's a free piece of software and is quite excellent. I wrote up a review of it...

Do a LIKE search where you have wild cards on the starting side of the predicate

LIKE '%a1'

Is going to cause scans and prevent index use. I would strongly advise attacking...

I'm seeing two different MERGE commands, no CTEs in sight.

Here's an article[/url] I wrote on how to deal with versioned data. One of these solutions should work well for you.

You can create the view using WITH SCHEMABINDING. That will prevent the table from being modified. Here's the CREATE VIEW syntax.

Try it with explicit transactions, separating the ALTER command from the others.

Just use Powershell. Here's an example script that will do what you need.

You might be facing a bit of an issue here. I'm assuming you're planning to do log shipping after a restore to get the 2000 database to 2014? The problem...

There's a service that gets installed with SQL Server called SQL Agent. You can use that to schedule your backups. Here's the documentation on the service. It's very straight forward...

Situationally,...

Table variables also don't have statistics. Sometimes, this is a great thing. Sometimes it's a horrible thing. But it's one of the biggest differences between table variables and temporary tables.

And remember, the order of the keys on the indexes matters quite a bit, especially for the first column since that determines what is in the histogram of the statistics....

If the disk has gone bad, that should have shown up in the wait statistics. You didn't see any changes tehre at all?