Koen Verbeeck (5/15/2014)

What do you mean with this?

The table becomes read-only, so you can access it only...

I'm a little confused. Let's verify that backups work. Can you run something like this from your T-SQL window in SQL Server Management Studio:

BACKUP DATABASE yourdbname

TO DISK = 'x:\yourdriveandlocation.bak'

WITH INIT,...

Ha! Well that is one way to do it I suppose.

You're still dealing with the fact that some of the time you're seeing is just because...

Oh, and welcome to SQL Server Central. We try to provide a nice, helpful place around here. If you ever get attitude from anyone, let me know.

This web site [/url]does a nice job of summarizing the differences between the two. The big difference is that mirroring actually provides an automated stand by situation where the mirror...

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...