Viewing 15 posts - 10,861 through 10,875 (of 22,224 total)
rkumar590 (5/24/2012)
I am facing a weird issue ,during the processing of the certain tasks from Application,some part of time we are observing blocks in our database.
Processing ,load are quite...
"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 24, 2012 at 3:50 am
There's a task scheduler built right into the OS. I'd just use that utility if all you needed was the ability to schedule tasks. You would have to pay for...
"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 24, 2012 at 3:47 am
Based on the fact that it's literally twice the size of the others, I would wonder if you have two backups there instead of one? Check to see if 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
May 23, 2012 at 12:58 pm
PradeepVallabh (5/23/2012)
Thanks for the info...While analysing execution plan i noticed something called Estimated Number of Execution...what does it mean??
Parts of the execution plan are iterative. This means parts can be...
"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 23, 2012 at 12:46 pm
TheSQLGuru (5/23/2012)
Grant Fritchey (5/22/2012)
"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 23, 2012 at 6:47 am
Developer Edition for 2008 was not free. It cost money. Maybe you're thinking of Express 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
May 23, 2012 at 5:43 am
Can you post the execution plan for the query? It's hard to suggest improvements not knowing the structure of your system, tables, indexes, constraints, etc.
"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 23, 2012 at 5:41 am
If your database was created using the defaults, then it's in Full Recovery. This means you need to backup the log on a regular basis, at least once an hour...
"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 23, 2012 at 5:40 am
Piling on at this point, but that's one ugly naming convention so...
No, I've never seen one like that and wouldn't recommend it. In fact, I'd fight against it, kicking, biting...
"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 23, 2012 at 5:35 am
Also remember, those costs are estimates. They're the only numbers you have, so you must use them, but they're estimates, not actual measures.
"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 23, 2012 at 5:11 am
After reading Gail's articles, read my book. Links are in the signature.
"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 23, 2012 at 5:09 am
That's very abnormal. Were you able to capture the execution plans for the queries so we can try to compare them to each other? This is not something I'm 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
May 23, 2012 at 5:00 am
The necessary permissions are documented right here on the Red Gate web site.
"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 22, 2012 at 6:20 am
Ditto. Or, it might be accessed by looking at the default ANSI settings for the server.
"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 22, 2012 at 6:17 am
MadTester (5/22/2012)
Currently I'm thinking of changing the job to do a reorganise daily based on fragmentation and an...
"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 22, 2012 at 6:16 am
Viewing 15 posts - 10,861 through 10,875 (of 22,224 total)