Viewing 15 posts - 15,211 through 15,225 (of 22,227 total)
The general approach is to identify what's running slow and then look at the execution plan to understand what it's doing. It's a rather large topic. Entire books have 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
May 3, 2010 at 7:06 am
One other option, since there's no sample code and no execution plan, this is speculation. You showed the values passed as being strings '9-1-2009', etc. It's possible that the implicit...
"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
May 3, 2010 at 7:04 am
Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of your ability...
"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
May 3, 2010 at 6:59 am
Just remember that you have to have FULL backups in place first in order to support log backups.
"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
May 3, 2010 at 6:52 am
Sqlfrenzy (5/3/2010)
Paul White NZ (5/3/2010)
Sqlfrenzy (4/29/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
May 3, 2010 at 5:41 am
Paul White NZ (5/3/2010)
Bhuvnesh (4/30/2010)
HI i need better approach for the below one.i know this is very straight forward query but if somebody can help me here . greatly appreciated.
1....
"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
May 3, 2010 at 5:36 am
Gianluca Sartori (5/3/2010)
I would have put some more BREAK / CONTINUE in it and maybe nested another cursor,...
"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
May 3, 2010 at 5:30 am
Steve Jones - Editor (5/2/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
May 3, 2010 at 5:28 am
Trey Staker (4/30/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
May 3, 2010 at 5:25 am
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things...
"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
May 3, 2010 at 5:21 am
Lynn Pettis (4/30/2010)
Grant Fritchey (4/30/2010)
Lynn Pettis (4/30/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
April 30, 2010 at 12:46 pm
Best tool I've found for doing this is Quest's Benchmark Factory. I'm not even sure they still offer it. At one time Idera had a tool for doing this 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
April 30, 2010 at 12:41 pm
Lynn Pettis (4/30/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
April 30, 2010 at 12:39 pm
Threads are managed by SQL Server and the operating system.
What is it that you're trying to 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
April 30, 2010 at 11:24 am
jcrawf02 (4/30/2010)
Right, obviously not SQL Compare. We should use Access.
You are so behind the times... Haven't you heard, Powerpivot in Excel is the new mechanism for database storage & retrieval....
"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
April 30, 2010 at 11:18 am
Viewing 15 posts - 15,211 through 15,225 (of 22,227 total)