Viewing 15 posts - 15,016 through 15,030 (of 22,219 total)
I'm still not getting a total picture with details, but based on what else you've said, I'm going to stand by the original post. A table that stores relationships, user...
"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 6:09 am
GilaMonster (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice guy and...
"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 6:00 am
avanch-990710 (5/14/2010)
Now, does the sa account for SQL server 2000 and SQL server 2008 have the same password--I have them set up with different passwords?
That depends on what was set...
"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:49 am
I still don't understand what you're asking for? A query has no selectivity. There is not a measured set of uniquely identifying data about a query. The data stored in...
"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:48 am
The Dixie Flatline (5/14/2010)
Forums really shouldn't be a resource of last resort, especially in an emergency. ...
"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:41 am
TheSQLGuru (5/13/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 17, 2010 at 5:38 am
Ben Holcombe-270296 (5/13/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 17, 2010 at 5:35 am
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
Viewing 15 posts - 15,016 through 15,030 (of 22,219 total)