Viewing 15 posts - 10,021 through 10,035 (of 22,219 total)
devaji123 (2/12/2013)
"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 12, 2013 at 6:08 am
First question, after the upgrade, did you manually update all the statistics. Further, did you update them with a full scan? Statistcs are stored differently from one version to 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
February 12, 2013 at 4:47 am
I've been using backup compression for years across a wide range of systems, both native and third party. Compression has been extremely reliable and overall a net positive. I say...
"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 12, 2013 at 4:35 am
An 8gb database? Unless you're running it on a VERY tiny little drive, there's no need to do a differential. Just do a FULL on a daily basis. In fact,...
"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 12, 2013 at 4:32 am
Second vote for Gail's article.
That second query will only, ever, use a scan to retrieve data. Functions against columns in the WHERE or JOIN conditions always lead to scans.
"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 12, 2013 at 4:08 am
Stored procedure tuning is the same as query tuning. You measure the performance of the procedure, in terms of time to execute, logical reads and CPU. You make modifications to...
"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 12, 2013 at 4:04 am
Not sure. Is it possible it's still running? Blocked maybe? I have seen that happen, on more than one unfortunate occasion.
"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 12, 2013 at 4:01 am
Chrissy321 (2/11/2013)
Lately I put everything in a schema. Is this a reasonable statement as far as a best practice?...
"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 12, 2013 at 3:43 am
Not sure. Reading the KB, it could be interpreted to only apply to CU & hot fixes, but I don't have a definitive answer there.
"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 11, 2013 at 9:09 am
I'd monitor the server for a couple of days (to a couple of weeks if I could) to see if the database is being accessed. Then back it up. Then...
"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 11, 2013 at 8:50 am
They all can be. Makes things sloppy in my opinion. However, if you are dealing very large numbers of objects, for example, I saw this with stored procedures when we...
"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 11, 2013 at 5:08 am
You can have a single NULL value there. That's it. More than one, and it's not unique. You could try a filtered index instead.
"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 11, 2013 at 5:01 am
You should be aware that most changes to the optimizer, especially the ones that lead to plan instability, are not actually turned on when you install a service pack. Read...
"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 11, 2013 at 5:00 am
If you are trying to learn T-SQL, you can't go very far wrong picking up Itzik Ben-Gan's book. He has a fundamentals book and the Inside book.
I don't know 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
February 11, 2013 at 4:49 am
Jeff Moden (2/10/2013)
Steve Jones - SSC Editor (12/3/2010)
No hurry on any of these.
I guess that's a good thing. Grant, did you ever get yours done? I know I'm...
"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 11, 2013 at 4:36 am
Viewing 15 posts - 10,021 through 10,035 (of 22,219 total)