Viewing 15 posts - 15,781 through 15,795 (of 22,219 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 1, 2010 at 6:43 am
It's available as a download from Microsoft. Try here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2010 at 8:14 am
While the SELECT is running, and using an index, it will prevent another process from dropping that index. Same with any other object in the database. Is there a way...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2010 at 8:44 am
By master tables do you mean the system tables?
Or maybe what you're looking for are lookup tables, tables that contain relatively static data for use as referential integrity to provide...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2010 at 8:39 am
Indexes are very unlikely to cause read queries to slow. They may not help read queries run faster, but they won't slow them down. Indexes can negatively affect inserts/udpates/deletes because...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2010 at 8:35 am
GSquared (2/23/2010)
Elliott W (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
By derivation, a "geek" is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2010 at 6:14 am
RBarryYoung (2/22/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2010 at 6:58 pm
CirquedeSQLeil (2/21/2010)
Another option would be check out this puzzle roundup[/url] by Grant Fritchey.
Nuts. I was just going to point out that article I wrote several years ago. The comments in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2010 at 4:24 am
GilaMonster (2/21/2010)
Jack Corbett (2/21/2010)
Following MVP's on twitter last week during the MVP Summit made me wish I was there.Me too.
Add one more to the list of longing....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2010 at 4:21 am
Viewing 15 posts - 15,781 through 15,795 (of 22,219 total)