Viewing 15 posts - 12,556 through 12,570 (of 22,227 total)
buferis12 (5/17/2011)
ahh thats bad 🙁 SO reverse engineering wouldn't help too? Btw, yeah there is things called stored procedures in that db.
There you go. You can't possibly know what's going...
"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, 2011 at 5:24 am
Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within DTS, why...
"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, 2011 at 5:12 am
Not a problem. Nice to have met 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
May 16, 2011 at 5:03 pm
GilaMonster (5/16/2011)
Grant Fritchey (5/16/2011)
"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 16, 2011 at 2:13 pm
I don't know, we'll have to renogiate the rate now...
Here's a little query to just get you started:
SELECT bf.logical_name,bs.backup_finish_date
FROM dbo.backupfile AS bf
...
"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 16, 2011 at 2:10 pm
Jack Corbett (5/16/2011)
"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 16, 2011 at 1:47 pm
Yeah. That way you don't have to guess what the backup name 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 16, 2011 at 1:44 pm
You could use SSIS and schedule it from SQL Agent. You could use a PowerShell script and run that from SQL Agent. You could probably use a linked server 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 16, 2011 at 1:15 pm
Problem is, that includes the time too. No way to calculate that, you have to know it.
Do you have access to the server where the backups are being taken? 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
May 16, 2011 at 1:13 pm
You'll be able to make guesses on the table structures if, and only if, you have all dynamic TSQL. If they're calling stored procedures you will have absolutely no mechanism...
"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 16, 2011 at 12:05 pm
Ninja's_RGR'us (5/16/2011)
Ninja's_RGR'us (5/16/2011)
What's the advantage of setting the db or files to read_only?.. and which ones do you set ro?
Ya, but if the db only has selects running on it,...
"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 16, 2011 at 8:42 am
GSquared (5/16/2011)
I went. There were a number of good presentations. Definitely worth the time spent and all that. Learned more than a little bit.
And I got 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 16, 2011 at 8:39 am
Gail said it. Read only not only means it doesn't take out locks, but it stops trying to. Changes the dynamic on queries considerably. Huge advantage for read only systems....
"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 16, 2011 at 8:38 am
One option to consider, SQL Server Central Management System[/url] from CodePlex. But better still, read through this section in Books Online. It should get you where you need to go.
"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 16, 2011 at 8:33 am
First off, if it is a reporting only system that gets a refresh at night or something, make it read only. That will radically improve your performance for the queries.
As...
"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 16, 2011 at 8:24 am
Viewing 15 posts - 12,556 through 12,570 (of 22,227 total)