The big one for me would be that you can just add a nonclustered columnstore index to the table, but still have the table stored as a regular SQL Server...

First thing I'd suggest is not trying to do this with stats. It's fine when collecting information for one query. As soon as you start collecting two, three, etc., it...

Why are you using common table expressions here? You define this:

WITH results

AS (SELECT id,

...

How are you measuring the time? From the SSMS client? That includes the time to transmit across the wires and isn't a good measure of server performance. If you really...

I'm assuming you're getting the fragmentation information from sys.dm_db_index_physical_stats. If so, are you using the DETAILED mode to gather your metrics? I've never seen SAMPLED or LIMITED take very much...

The only way to get a really accurate count would be to use extended events or trace. Since you're 2008 trace will be easier since there is no GUI for...

That's a client testing issue. You're not going to see any problems from it during your upgrade in SQL Server, side-by-side or in-place. But you could see issues on the...

It's absolutely using sys.dm_os_waits_stats. But if you want to know which query, just run extended events/trace to capture it.

SQLRNNR (5/14/2014)

---

Grant Fritchey (5/14/2014)

---

Ed Wagner (5/14/2014)

---

Koen Verbeeck (5/14/2014)

---

I pretty much laughed...

Again, if you do a search on the internet, there are tons of articles on this. Not just one. Here's a blog entry from MS on troubleshooting the issue. This...

Greg Edwards-268690 (5/14/2014)

---

Grant Fritchey (5/14/2014)

---

Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the...

I'd say show them that error message and let them look it up through Bingle. It's absolutely a hardware related problem and it's very well documented as such out on...

Check the documentation on the BACKUP command. There is no facility for just getting the READ_ONLY file groups. You'll have to go after each one individually. Partial backup documentation says...

Blocking caused by another process doing an INSERT/UPDATE/DELETE which will stop the scan.

It's absolutely an I/O issue. I'd say your disks are being overwhelmed because the issue isn't that a given process is waiting for disk access while another process uses, but...