Viewing 15 posts - 15,796 through 15,810 (of 22,226 total)
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
If I'm getting the question right, you're asking if you should have seperate tables for phones & emails from your contact table. Well, let me ask you a question. Do...
"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 20, 2010 at 6:41 am
Without an execution plan, this is just idle speculation, but it does sound like you've already hit the nail on the head. Increasing I/O and decreasing CPU is a good...
"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 20, 2010 at 6:32 am
GilaMonster (2/19/2010)
Grant Fritchey (2/19/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 20, 2010 at 4:07 am
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
Thanks for both the affirmation of fears on the topic...
"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 19, 2010 at 1:21 pm
Steve Jones - Editor (2/19/2010)
Grant Fritchey (2/19/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 19, 2010 at 1:15 pm
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
Thanks for both the affirmation of fears on the topic as well 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 19, 2010 at 1:14 pm
tstaker (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
@Grant
Awesome blog post. There was a time that I would of been...
"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 19, 2010 at 1:09 pm
Thanks for the great idea for a blog post:
So you want to write a book?[/url]
"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 19, 2010 at 12:52 pm
Viewing 15 posts - 15,796 through 15,810 (of 22,226 total)