Viewing 15 posts - 15,031 through 15,045 (of 22,219 total)
Running data definition language (DDL) statements are generally not a performance tuning consideration, but then, they normally aren't run from within procedures like that. As a matter of fact, it's...
"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 12, 2010 at 7:15 am
Ah, OK.
"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 12, 2010 at 6:43 am
I have to ask, why do you want to create a view from within a stored procedure? What's the point?
"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 12, 2010 at 6:30 am
You can backup & restore msdb between servers. Assuming the drives are the same, your Agent jobs should be ok. If the drives & whatnot are different, you'll need 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
May 12, 2010 at 5:47 am
Satya,
I'd strongly recommend you pick up a couple of books and read, a lot. If you've never done this before, it's very simple to make lots of big mistakes. 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 12, 2010 at 5:30 am
eric_russell 13013 (5/11/2010)
GilaMonster (5/11/2010)
As for the index usage, it's flushed when the DB is closed. Shutdown, restore, detach, offline. There's no way I know of to manually flush it. Eric,...
"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 11, 2010 at 9:48 pm
lkean66 (5/11/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 11, 2010 at 12:59 pm
I guess the answer depends on what they're monitoring with. For example, I'd hate to see two or more copies of Quest Spotlight connected to my production server. But two...
"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 11, 2010 at 12:25 pm
You would need to look at the execution plan to be sure what was happening in the query with the fuction, but yes, using functions like that in that situation...
"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 11, 2010 at 12:12 pm
I am really not a fan of the Database Tuning Advisor, but if you're going to use it, don't use it blindly. Consider it's suggestions very carefully and be sure...
"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 11, 2010 at 12:10 pm
frankG-689606 (5/11/2010)
You are not going to guess what the solution was...
Do I feel dumb!!:crazy:
Someone brought it to my attention. They asked me, "You do know that the connection timeout is...
"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 11, 2010 at 12:08 pm
frankG-689606 (5/11/2010)
Thanks for the comeback!
I took some your advice...
Finally, it could be that since you're manipulating all this data all at once, the log file is growing and that's...
"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 11, 2010 at 11:13 am
paul.goldstraw (5/11/2010)
Grant Fritchey (5/11/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 11, 2010 at 10:19 am
paul.goldstraw (5/11/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 11, 2010 at 8:16 am
paul.goldstraw (5/11/2010)
Gianluca Sartori (5/11/2010)
You could use...
"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 11, 2010 at 8:08 am
Viewing 15 posts - 15,031 through 15,045 (of 22,219 total)