Viewing 15 posts - 18,166 through 18,180 (of 22,226 total)
In addition to what the others have posted, you should take a look at updating your statistics and maybe defragging your indexes. You have estimated 4 rows, but actual 86000....
"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 3, 2009 at 5:50 am
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
"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 3, 2009 at 5:29 am
That's probably the right way to think about it. By the way, I wasn't talking about 1 player to 1 manager. I was attempting to describe the two directions that...
"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 2, 2009 at 6:02 pm
I think asking why is probably not asked often enough. So many of the questions that come by are just a little off. You know the kind that makes you...
"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 2, 2009 at 5:53 pm
Nice work.
"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 2, 2009 at 7:50 am
Did it generate an error or did the update not occur? If you're checking for an update working, you'd want to look at the @@ROWCount instead of @@Error. Also, since...
"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 2, 2009 at 7:44 am
With well indexed tables, a three table join is pretty painless. A ten table join is pretty painless too depending on the indexes. I sure wouldn't compromise the data integrity...
"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 2, 2009 at 7:09 am
Reading that BOL entry, I'll bet it's a holdover from 2005. It did work in 2005, but it doesn't seem to in 2008.
"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 2, 2009 at 6:26 am
I've never been able to do it either. When I'm working 2000 instances I just go back to sp_who2 and other TSQL methods for seeing what's going on. Not 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
March 2, 2009 at 6:25 am
Free? No. But Red Gate's SQL Prompt is extremely inexpensive.
It won't help while writing the code, but ApexSQL has a free clean-up utility that will help you with formatting.
"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 2, 2009 at 6:23 am
You can store tableA data in TableC without a relation, but without a relation you have no way of knowing that the data is valid. If TableA data gets deleted,...
"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 2, 2009 at 6:21 am
You can manage 2000 databases from the 2008 Management Studio. Out of the box you can't edit DTS packages and I'm not sure how you would go about doing that....
"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 2, 2009 at 4:55 am
info (3/1/2009)
"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 2, 2009 at 4:52 am
That's way more information than can be easily answered in a post on a board. Performance tuning has three major areas of concern, the OS & Server, which you usually...
"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 2, 2009 at 4:45 am
I'd suggest a couple of different things. First, have you checked the execution plans on your select statements to be sure that the indexes on your tables are being used....
"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 28, 2009 at 6:11 am
Viewing 15 posts - 18,166 through 18,180 (of 22,226 total)