There are a bunch of common problems you have to avoid in SQL Server to aid in performance. Generally, check these first. They include, but aren't limited to:

functions on columns...

I agree with what everyone else is recommending.

I would like to note that if you're asking if you have to restore to 2008 or 2012 or something, the answer...

BLOB EATER (12/19/2016)

---

Grant Fritchey (12/19/2016)

---

I submitted sessions today....

I submitted sessions today. Fingers crossed I get...

ThomasRushton (12/16/2016)

---

Grant Fritchey (12/16/2016)

---

Oh no.

Don't let anyone do that. It's horrible. Quick, go and change...

Oh no.

Don't let anyone do that. It's horrible. Quick, go and change your password and...

Sue_H (12/14/2016)

---

tt-615680 (12/14/2016)

If you keep getting errors about running out of log space then it's likely that you aren't doing log backups often enough and/or you aren't sizing the log...

Oh here, let me help.

So 36% of people thought that either: You don't need to compare them since the graphical plans are the same, which is blatantly false, or that You can compare the...

Is your database in Full recovery? If it is in Full recovery, are you running regular log backups? If not, you need to run backups, or you need to run...

How do you mean? It's just comparing the underlying XML on...

The MDW itself puts too much load on a system. The overhead is not worth the benefits. That's the number one reason I'd recommend against it.

Jeff Moden (12/3/2016)

---

Grant Fritchey (12/2/2016)

---

Talib123 (12/2/2016)

---

I would try the default trace, if your qucik enough you may get some information of what caused the files to grow and at what...

Availability Groups only support read only secondaries. Is QA a read only process or do they do writes? If they do writes, you can't use AG to solve this at...

Ha!

It's not that bad. Erin Stellato has a bunch of blog posts on getting...