Viewing 15 posts - 15,766 through 15,780 (of 22,211 total)
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...
March 3, 2010 at 5:43 am
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...
March 3, 2010 at 5:39 am
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...
March 3, 2010 at 5:22 am
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...
March 3, 2010 at 5:20 am
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...
March 3, 2010 at 5:16 am
David Portas (3/2/2010)
RalphWilson (3/2/2010)
David,
You have got to be kindding. Not everyone has an...
March 2, 2010 at 11:21 am
CirquedeSQLeil (3/1/2010)
Feet were created to kick balls.
No disagreement here.

March 2, 2010 at 5:47 am
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...
March 1, 2010 at 6:43 am
It's available as a download from Microsoft. Try here.
February 26, 2010 at 11:43 am
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...
February 25, 2010 at 1:34 pm
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...
February 25, 2010 at 11:12 am
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...
February 25, 2010 at 11:10 am
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...
February 25, 2010 at 11:07 am
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.
February 25, 2010 at 8:18 am
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...
February 25, 2010 at 8:14 am
Viewing 15 posts - 15,766 through 15,780 (of 22,211 total)