Are the DatabaseID columns enforced as foreign key constraints, or are they just indexes? Since they are being used as foreign keys, you want to ensure that they are enforced....

That's a gigantically open-ended question. To answer it faithfully you have to know if we're changing the data as well as moving it. Are there transformations to the structure or...

There isn't a perfect way to get this done. I'd suggest looking at SQLCop[/url]. It does a decent, but not great, job at this. I don't know of a tool...

Assuming we're talking about an inline table function, that's the approach I would use. If you're looking at the multi-statement table valued function, I would caution against it.

Be careful. You're...

I don't know if you're on 2008 or 2008R2, but if the latter, you should explore using traceflag 2371. It makes a huge difference for lots of people when dealing...

I agree 100% with Gail. To do this accurately, you need to have monitoring in place.

However, you could look to the Dynamic Management View, sys.dm_exec_query_stats. That does have the last...

And since you have NOLOCK everywhere, it's worth pointing out that the use of NOLOCK can lead to missing or extra rows in your query. Be very cautious in how...

There are a bunch of people around here with that kind of experience. What's the question?

Hugo Kornelis (11/3/2016)

Grant Fritchey (11/3/2016)

Steve Jones - SSC Editor (11/3/2016)

Ah, laptops can be...

Steve Jones - SSC Editor (11/3/2016)

Ah, laptops can be just as fast as...

It's either someone reseeding or it's someone doing an identity_insert to your data. Neither is good, but both should be under your control.

Yes, you should upgrade to SSMS 2014. Backwards compatibility is largely ensured within SSMS, so 2012 will work with 2008R2, 2008, 2005 and 2000. However, forward compatibility is absolutely not...

If by out of sync you mean that the numbers look like:

1,2,3,17,18,19

That can be from two causes. Either deletes, or, more likely, rollbacks. If an insert fails, the identity value...

If the database is passing a consistency check, then it's something in your apps that's doing that. It could be a trigger though. I'd check that too.

The question for me is, if that index really is superior, what was keeping the optimizer for choosing it. It does happen on occasion that the optimizer won't choose a...