But of course it is.

I kind of glossed over the title, but thanks Brent for pointing it out...

I am NOT smarter than... oh, just about anyone. I've just been around long enough to have...

Backups. Tested backups (which means a restore to a test machine somewhere). Nothing is more important than ensuring the continuity of your organization. That means talking to the business to...

thomashohner (7/1/2014)

---

jcrawf02 (7/1/2014)

---

Grant Fritchey (6/30/2014)

---

If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning...

jcrawf02 (7/1/2014)

---

Grant Fritchey (6/30/2014)

---

If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book...

By the way, change that cost threshold value. The default value of 5 is way too low for most systems. I'd suggest bumping it to 50 for an OLTP system...

Cost threshold for parallelism on both boxes. ANSI connection settings on both boxes. Get an estimated execution plan from both boxes and compare them.

Check the execution plan for both. See what's being generated by the optimizer. That will help you understand if there is something mundane like statistics at fault, or if you're...

That's actually a tough problem. If this were a SQL Server 2012 instance I would ask if it was possible that those clients be Read Only. In this case you...

Yeah, if that equals NULL was in the WHERE clause I'd be laughing my bottom off.

Also, if you're backing up to a remote drive across the network, check the network connectivity. That can seriously impact backup performance.

Check the wait statistics while the backup is running...

I wouldn't worry about the indexes on 2014 more than I would on 2008. Whatever index rebuild you normally use should be fine. Traditionally many people will update their statistics...

You should plan on testing that they work in every case. Some will, but others will require upgrades to the client components. There are new versions for SQL Server 2014.

Nice write up.

And you didn't say hello? Please do next time.

New Born DBA (6/30/2014)

---

I ended up downloading the 2nd version of the book and I am sure by the time I am done reading this, I will be able to...