Viewing 15 posts - 8,431 through 8,445 (of 22,219 total)
Don't run DBCC checks hourly. That's a very serious load on the system.
Since you've never run the consistency checks, I'm with Gail, let them run no matter how long it...
"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 9, 2014 at 5:52 am
The entire idea behind backups is to have a complete copy of the database. A restore operation also is a complete copy of the database. This is not an import/export...
"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 9, 2014 at 5:48 am
But if the permissions were different, you'd get an error, not just disappearing comments. Are the schema's different or missing? Are you putting the comments within the procedure definition or...
"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 9, 2014 at 5:46 am
I've put SQL Server compressed backups with non-compressed backups, script files, all sorts of things. It's just a file. I can't tell you that I have specifically put it on...
"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 9, 2014 at 4:19 am
And no one has even mentioned DISTINCT yet.
"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 8, 2014 at 4:30 pm
Everything Luis says plus...
You have functions all over the place in your JOIN and WHERE criteria. These are going to absolutely prevent the use of statistics causing the execution plans...
"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 8, 2014 at 3:27 pm
It sounds like you're getting a parallelism deadlock. Hard to say for certain without seeing the deadlock graph.
Just because you see indexes in the execution plan doesn't mean they're...
"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 8, 2014 at 3:24 pm
I'm with Sean. It sounds like you're not running the ALTER PROCEDURE script but instead you're executing the procedure itself. Those are two distinct steps.
"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 8, 2014 at 3:21 pm
Troubelshooting SQL Server [/url]is a great book.
For just general administration, I wrote part of a book.
"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 8, 2014 at 3:19 pm
ramana3327 (4/8/2014)
Hi,Thanks for the response.
I am sorry, I didn't understand the point. Please let me know, which default value and how to change that?
Thanks,
Ramana
Cost Threshold for Parallelism
"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 8, 2014 at 12:44 pm
Tobar (4/8/2014)
Another issue I had is that you can not just "compile" (execute) a CTE definition by itself without some...
"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 8, 2014 at 12:18 pm
yuvipoy (4/8/2014)
What about DTA statistics ?
are they not statistics?
How DTA able to do get those details(Statistics), which means that it was missed by Auto...
"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 8, 2014 at 12:12 pm
For scripting the logins, follow the suggestions here. You should be able to just right click on the linked servers and generate a script.
"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 8, 2014 at 11:25 am
AUTO_CREATE means that when a query is run against the database and there are no statistics for a column in a WHERE clause, a JOIN, or other areas where statistics...
"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 8, 2014 at 11:23 am
Thank you!
Good luck on setting up the virtual network. It can be a little tricky at times, but the documentation I sent does work. I've used it a couple 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
April 8, 2014 at 11:04 am
Viewing 15 posts - 8,431 through 8,445 (of 22,219 total)