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

They may or may not respond. Gail provided you...

Chowdary's (4/28/2014)

---

Is this good to set the database recovery model to Simple,

Because if we want to recover the Data Point_In_Time ,its not possible in that Simple Recovery Model.

If suppose Daily...

TomThomson (4/25/2014)

---

Steve Jones - SSC Editor (4/24/2014)

---

On the shed-dyule for Bits, and planning on it....

Lynn Pettis (4/27/2014)

---

Well, I put in for another 6 months out here in Afghanistan. Looks like I'll miss another PASS Conference. I did put in for 2 weeks...

You have other issues going on. Make sure that you have, at minimum, automatic creation and maintenance of statistics enabled. You'll probably need to manually update them as well, but...