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

A copy of the database just exports the scripts to define the tables. It's not going to export any other settings such as the current identity. You can use DBCC...

First, please, for clarity's sake, rename that index. Anytime I open a server and see _dta at the start of an index, I almost want to cry.

I would suggest you...

You've just defined what stored procedures are used for. You give access to insert data through a stored procedure, but not through the table directly. That way you can control,...

The thing is, I think the technology is amazing, but, it's really all about the ability to collect data and feed data out at high speed in an OLTP environment....

There's no real way to dynamically capture statement times within the execution unless you output to a variable before and after a statement starts & stops. Otherwise, to capture statement...