Viewing 15 posts - 11,581 through 11,595 (of 22,219 total)
Full backups don't affect log backups in that way. They only affect differential backups. If that's not part of your restore strategy, then you're fine.
"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
December 2, 2011 at 4:49 am
Second vote for PowerShell. I'm pretty sure Allen White has a script over here somewhere.
"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
December 2, 2011 at 4:47 am
Although, you can see an aggregate history of the executions in cache. If you look at sys.dm_exec_query_stats you can find an aggregation of performance metrics for any query still 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
December 2, 2011 at 4:45 am
Kiara (12/1/2011)
Brandie Tarvin (12/1/2011)
GSquared (12/1/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
December 1, 2011 at 1:23 pm
GSquared (12/1/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
December 1, 2011 at 9:32 am
Just a side note, if you don't have backups of this database, are you running backups of your other databases? If not, in addition to worrying about getting this one...
"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
December 1, 2011 at 7:51 am
I'm sorry to say, there's no easy way to explain this. I've written two different books, one on query tuning and one on reading execution plans. There's that much material...
"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
December 1, 2011 at 5:11 am
Lexa (11/30/2011)
1. UPDLOCK [what happens when used in "insert table1 select * from...
"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
December 1, 2011 at 5:07 am
If you're using Transparent Data Encryption, and the key is properly installed on the server, you should just be able to query the data. If not, I think this 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
December 1, 2011 at 5:02 am
Most of the software out there allows you to download it and try it out. Each one offers different sets of details and has some different monitoring mechanisms. I'd suggest...
"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
December 1, 2011 at 4:52 am
matt.newman (11/30/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
November 30, 2011 at 12:16 pm
Having done the method of trying to maintain "clean" database copies that are then moved around for restore purposes and having had four (4) times the amount of disk storage...
"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
November 30, 2011 at 11:04 am
Same goes with plugging in the Cumulative Updates after you get to the latest service pack. If you don't know what's causing your slow down, you might see a fix...
"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
November 30, 2011 at 10:55 am
Any increase in performance from one SP to the next is most likely to be extremely marginal. If you're hitting performance issues, you need to do the hard work 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
November 30, 2011 at 7:27 am
I also recommend starting with Gail Shaw's articles linked above. It's an excellent place to get started. I'd also suggest you pick up a copy of my book on exactly...
"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
November 30, 2011 at 7:25 am
Viewing 15 posts - 11,581 through 11,595 (of 22,219 total)