The issue is, there's no way within code or structure to speed up moving 1/4 of a 25 million row table. You are completely dependent on hardware because that will...

You're attempting to query 8.25 million records out of 25 million. It's going to scan the table to do this. Indexes won't help. You can get faster or more disks...

You can set up a virtual network that allows you to treat the VMs as if they were part of your on-premises servers. Then, you have lots of choices. You...

chrisn-585491 (8/11/2014)

---

"There are a lot of people doing this kind of thing, over-stating their qualifications, plagiarizing blogs, posting garbage answers. Why is this one bothering you so much? "

Because it's...

Why are you worried about updating the statistics? They're going to get updated naturally by the internals process of SQL Server anyway. Some of those updates may be sampled, some...

It's vendor specific whether or not they actually support database restores as part of their snapshot mechanism. Some do, some don't. A test restore is the best mechanism to validate...

After you backup the system databases, get everything into source control. All the jobs can be scripted out, put that into source control. Your databases and their code & structures...

Multiple requests seems nuts. In fact, I prefer to let the developers just develop. You may think you need a table that looks like X, get part way into your...

SQLRNNR (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I...

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me...

Yes, you can use the SQL Agent Alerts. Here's an introduction to them in the Books Online.

Or, you'll need to uninstall and then reinstall SQL Server. Not my preferred approach, but one that will work.

Be sure you have good backups in place before you do any...

Thanks for the...

Interesting stuff. Thanks for posting the follow up. Clearing the cache as a mechanism for dealing with bad parameter sniffing is somewhat problematic. You might want to look to plan...

GilaMonster (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

sqldriver (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on...