Viewing 15 posts - 15,031 through 15,045 (of 22,227 total)
sburcombe (5/13/2010)
I'm in the fortunate position where...
"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 17, 2010 at 5:31 am
lmu92 (5/13/2010)
The only question that remains open is: Where to draw the line?
But I guess it's almost impossible to answer...
Interview questions, test/homework, almost complete projects, several hundred lines...
"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 17, 2010 at 5:24 am
Thanks to all the comments. Steve posted this on a day I was going out into the woods, so I'm just now getting back to begin the process of responding....
"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 17, 2010 at 5:23 am
Well a view wouldn't make a good staging table since no data is actually stored. If you must stage the data, I'd use a temporary table unless there were only...
"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 12:25 pm
Just a follow-up on this. My favorite software to do this is also Red Gate SQL Compare.
However, you should know that there are others out there, Apex, Idera, Atlantis Interactive......
"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 9:10 am
Not knowing the precise structure, I can't supply you with precise SQL code, but you can do this a few different ways. Let's assume that you have three tables, 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 12, 2010 at 8:49 am
GilaMonster (5/12/2010)
Grant Fritchey (5/12/2010)
There is a way to get this information, but it's not from the missing indexes DMV's.
However getting it from the plan cache is not reliable, as 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 12, 2010 at 7:50 am
eric_russell 13013 (5/12/2010)
Grant Fritchey (5/11/2010)
Whether the DBA knows it or not, that data can get changed by circumstances. It's best that you know that fact in order to gauge best...
"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:43 am
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
Viewing 15 posts - 15,031 through 15,045 (of 22,227 total)