Viewing 15 posts - 17,311 through 17,325 (of 22,221 total)
Costs are an estimated value base on a baseline machine from back in the 90's. They're extremely arbitrary and subject to all sorts of vagaries around the statistics of the...
"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
June 3, 2009 at 12:19 pm
That's a little bit fast. It's based on a cleanup process that starts with the complexity of the plan. The simpler the plan, the lower the complexity number, therefor the...
"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
June 3, 2009 at 7:40 am
It still sounds like a permissions problem.
"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
June 3, 2009 at 7:33 am
INT will sort faster then DATETIME but not radically faster. Have you updated the statistics on the index recently, maybe with a full scan. Is there a good data distribution...
"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
June 3, 2009 at 7:09 am
The procedure cache can and does change. Procedures age out of cache as they are not accessed. It's a pretty normal part of the process.
"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
June 3, 2009 at 6:50 am
If I understand the code and the explanation, I think you can change this to use a single pass through one cursor. Instead of a set of SELECT statements and...
"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
June 3, 2009 at 6:47 am
Loading the output from a procedure into a temp table and then joining that temp table with your other tables is a good approach. As was noted, if you only...
"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
June 3, 2009 at 6:41 am
Does the account that SQL Server is running under have access to that drive and/or share? It sounds like a security issue.
"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
June 3, 2009 at 6:35 am
Steve Jones - Editor (6/2/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
June 2, 2009 at 1:13 pm
Roy Ernest (6/2/2009)
Grant, Bill says Hi back to you.. 🙂He wants to know if you still got your Fedora?? 😉
That thing made my head itch something fierce. It's gone.
"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
June 2, 2009 at 11:06 am
Roy Ernest (6/2/2009)
Just thought I would give you an update on the issues raised by Grant and Mohit on TDE, it will be fixed with the latest release of...
"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
June 2, 2009 at 7:44 am
That's a connection error. You either have the wrong name for the server, you don't have permissions to the server, or you don't have the right network settings on the...
"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
June 2, 2009 at 6:37 am
I don't know if you'll find a single article that contains information on all those key words specifically as they relate to performance. Mainly because they affect performance in such...
"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
June 2, 2009 at 6:29 am
There are gazillions. For example, I just started reading a book on SQL CLR (there's two right there, Structured Query Language and Common Language Runtime). On page 4 of the...
"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
June 2, 2009 at 6:15 am
I'd strongly recommend reading Craig Mullin's book "Database Administration." It's a few years old, but it does a fairly good job of describing what a DBA is and does.
"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
June 2, 2009 at 6:12 am
Viewing 15 posts - 17,311 through 17,325 (of 22,221 total)