Viewing 15 posts - 16,396 through 16,410 (of 22,226 total)
First, you want to gather information about the backups that exist. The best way to do this is to get the header information:
RESTORE HEADERONLY
FROM DISK = 'c:\data\restoretest.bak';
That will give you...
"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
October 5, 2009 at 9:36 am
Steve Jones - Editor (10/5/2009)
The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than...
"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
October 5, 2009 at 8:03 am
You don't need to install Operations Manager. You can download the sql server management pack and then review what it does.
"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
October 5, 2009 at 7:13 am
Access only queries move all the data for the tables they're referencing locally to Access and then apply filters & joins to the data. That's why the performance is horrific....
"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
October 5, 2009 at 7:07 am
Yes.
"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
October 5, 2009 at 7:04 am
ZeeAtl (10/5/2009)
Can I stipulate, later, that I want to restore any one of those days as a 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
October 5, 2009 at 6:28 am
I agree with Barry and Paul on this one. The exceptions that I've seen are usually where, usually due to badly written code or poorly designed structures, the only possible...
"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
October 5, 2009 at 6:05 am
ItalianOlgi (10/3/2009)
Jeff Moden (10/3/2009)
ItalianOlgi (10/3/2009)
Also, I am looking for information like "if they ask about...
"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
October 4, 2009 at 10:39 am
Yet more agreement with Jeff. It's what I've done in the past and it's what third party vendors like Documentum do.
"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
October 4, 2009 at 10:35 am
Operations Manager needs it's own server. Then you register your server with it and it starts monitoring. It provides a client interface to retrive the data collected.
"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
October 4, 2009 at 10:20 am
ready2drum (10/2/2009)
"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
October 2, 2009 at 1:29 pm
ready2drum (10/2/2009)
Error:
Msg 208, Level 16, State 1, Line 1
Invalid object...
"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
October 2, 2009 at 12:25 pm
No, Operations Manager is a completely seperate product from Microsoft. But it does work off of the performance monitor counters like most other monitoring products.
"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
October 2, 2009 at 9:02 am
Hmmm... Have you looked at the execution plans for the quick & the slow execution? Check the connection properties from the ORM tools to see if they're setting something differently...
"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
October 2, 2009 at 8:49 am
You can move the CSV files into a database. There, you've got all the tools you need for interpreting the data.
"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
October 2, 2009 at 8:41 am
Viewing 15 posts - 16,396 through 16,410 (of 22,226 total)