According to the statistics you're moving 197 million rows with no where clause. Don't bother with an index. It won't do any good. As currently built out, there's almost nothing...

Yeah, but that's index fragmentation. Shrinking and growing a database file fragments at the OS level. There's a decent little article about how to look at this over here at...

TheSQLGuru (4/29/2014)

---

I think you can support multiple VMs without having a "killer laptop", especially if you have an SSD attached (or even a fast USB3 flash drive, like my Patriot...

Try using the WAITFOR command in T-SQL. That'll pause the execution of the query and you should see a timeout.

You can get the plan_handle by querying sys.dm_exec_query_stats or sys.dm_exec_proc_stats if it's a stored procedure. If you need to use sys.dm_exec_query_stats, you can combine it with sys.dm_exec_sql_text in order to...

I'm not saying this...

The query times aren't terribly long at 200-800 milliseconds or so. But the fact that you're using sp_trace_getdata to collect information means you gathered this using the GUI. Don't do...

I only go to the clouds for my demos if I'm actually demoing cloud stuff. Too much can go wrong in demos anyway. Adding in connectivity on top of it...

scott_lotus (4/29/2014)

---

I use Quest Spotlight to monitor blocking and locking performance.

The "WAIT STATISICS" tab is currently showing 75% MISC WAITS.

I will check it again during the index creation and publish...

Just in terms of management, loads and loads of databases is a bit of a nightmare. But, from the standpoint of separation of customers, it's not a bad idea. Also,...

If you go to options when setting up a compare, by default, it's supposed to check the identity seed, but you can turn it off.

Wasn't trying to be critical of it, but that is the root of the problem. You have empty tables that are driving data without a correlation between the two that's...

Not really. It sounds like either data growth, or space used through fragmentation. Do you have a defrag running occasionally to ensure optimal use of the space? It sounds like...

The documentation of the copy database is unclear as to exactly what it does. It says it moves meta-data about the objects, but I don't see details.

Basically, it creates...

First off, there's a max of 32,767 databases per instance, so you're not getting to 50,000 any time soon.

In general, if you cluster a SQL Server instance, you move all...