Viewing 15 posts - 12,571 through 12,585 (of 22,219 total)
ejavier.r.dk (5/9/2011)
Now, I want to use the info from the trace in SCOM, and I know SCOM...
"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 9, 2011 at 10:40 am
Not sure what article you're talking about, but I'd check the connection settings between the two. Probabably one has different ANSI settings than the other which leads to a different...
"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 9, 2011 at 8:24 am
If you really do want to learn the internals, Gail is right (something you can just say about most things, most of the time), Benjamin's book is a great place...
"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 9, 2011 at 7:23 am
Pretty much use Michelle's scripts. They're solid as can be. We had reasonably wide maintenance windows and the databases weren't terribly large (100gb each) so we did full maintenance 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
May 9, 2011 at 6:31 am
I'll be there.
"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 9, 2011 at 6:29 am
To add one thing to what Gail said:
... and you've tested them extensively on the query that you're planning to use them on.
Test, test, test and then test some more....
"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 9, 2011 at 6:14 am
rootfixxxer (5/6/2011)
But one thing i don't understand, why there's such difference between 2000 and 2005,...
"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 9, 2011 at 6:04 am
The one thing you can do, that Gail was leaning towards, would be to have a table on a filegroup. You can restore a filegroup individually.but, the issue here 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 9, 2011 at 5:36 am
Steve Jones - SSC Editor (5/6/2011)
I used to go to a networking conference with my boss. A bit of a boondoggle, but...
"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 7, 2011 at 4:51 am
vijayakumarn (5/6/2011)
Using the left join i can achieve only one record... but i want two more record respect to the values 'B' and 'C' in the table-2
Sounds like you're not...
"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 6, 2011 at 7:17 am
There is no criterial for a join between those tables. It looks like you want a LEFT JOIN, but without joining criteria (a foreign key), you can't make that happen.
"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 6, 2011 at 7:05 am
Brandie Tarvin (5/6/2011)
Editor's Note:
"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 6, 2011 at 6:52 am
Yes.
There is no "in general." It really depends on the situation and you should test your situation because different ones will work better under certain circumstances.
"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 6, 2011 at 5:10 am
Without using a 3rd party tool, nope. You have to restore the database somewhere and then retrieve the tables that way.
If you want to talk about possible 3rd party solutions,...
"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 6, 2011 at 5:09 am
It could be blocking, other processes running on the server causing the restore to slow down. Or, it could be that open transactions on your backup are being rolled forward...
"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 6, 2011 at 5:07 am
Viewing 15 posts - 12,571 through 12,585 (of 22,219 total)