Are the databases identical? If not, it's down to the code & structure of the database in question. I'd try setting up a trace and capturing queries for a time...

Without seeing the structure, it's hard to say, but at a guess, it's the index reordering itself as the inserts come in.

Query the sys.dm_exec_query_stats and sys.dm_exec_query_plan to get the aggregated...

What does the execution plan look like? Where do you have indexes on the table? How selective is the data you're using for your filtering? Answering these questions will tell...

Without an index, you're seeing table scans. If you had an index, I'm fairly sure the '< 3' operation would work well (depending on the distribution of the data). It's...

Personally, I've put PowerShell to work on this problem. Generating scripts from within TSQL can be a bit problematic. Using SMO, which is how the Management Studio works, is much...

David Portas (3/2/2010)

RalphWilson (3/2/2010)

David,

You have got to be kindding. Not everyone has an...

No disagreement here.

I'm going to go with Gail & David, there's nothing all that wrong with using Identities as your PK as long as you've also defined the natural key through a...

It's available as a download from Microsoft. Try here.

Oh, I get it now.

It's asking, based on the data provided, which index is only taking part in seek operations. It means the index that doesn't have any scans. Look...

Another vote for Red Gate SQL Compare. The price on the Red Gate tools is entirely reasonable. If you're working for a company of any substantial size, you can justify...

I don't entirely understand the structure that you're presenting, so I'm not sure I'm going to answer your question here.

CTE's are just queries. They aren't fast or slow, just as...

I'm sorry, I just don't understand what you're asking.

You're listing the various indexes, by object id, and showing the aggregate access methods that have been used on these indexes. If...

I'd want to see the code because you're not exactly comparing Apples to Apples in this case. EXISTS and APPLY really are doing two completely different things within a query.

All you need is two or three people and a lot of time and you can put one together yourself. It isn't easy, but it's very doable. I've taken part...