Viewing 15 posts - 9,166 through 9,180 (of 22,224 total)
If you want the redundant storage that a SAN gives you, yes. If you want faster performance for the system databases, you might consider local storage. Everything is a tradeoff.
"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
January 2, 2014 at 5:25 am
In the free arena you might want to check out Kendal Van Dyke's Powershell scripts.
"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
January 2, 2014 at 5:24 am
Unless there's a specific reason for it, 4 logins/sec isn't freaking me out. It's just an indication of load, not a problem.
"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
January 2, 2014 at 5:19 am
Jeff Moden (12/30/2013)
Grant Fritchey (12/30/2013)
Jeff Moden (12/29/2013)
Grant Fritchey (12/18/2013)
"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 30, 2013 at 12:38 pm
Jeff Moden (12/29/2013)
Grant Fritchey (12/18/2013)
"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 30, 2013 at 6:12 am
Marek Grzymala (12/30/2013)
If you need a literal breakdown of the schedule, try looking at sysschedules.
Except that in SQL 2000 there is no sysschedules table. What worked for me was this:...
"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 30, 2013 at 6:10 am
You either already have that foreign key in place, or the data there is different between the two tables and is preventing you from putting it into 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
December 29, 2013 at 5:50 am
masoudk1990 (12/24/2013)
"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 24, 2013 at 3:52 am
MadAdmin (12/23/2013)
The log only grows from failure of the log backups. It won't grow due to failed differentials
So Diff's don't worry me too much.
A failed backup is of course top...
"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 23, 2013 at 3:29 pm
In addition to the Books Online, I'd recommend getting a copy of SQL Server Internals by Kalen Delaney. It might be over your head now, but the more you study...
"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 23, 2013 at 8:20 am
Also know that the optimizer, with one exception, treats a parameter (before the AS) and a variable (after the AS) differently. A parameter value is known to the optimizer when...
"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 23, 2013 at 8:18 am
I would not take a single suggestion from the Database Tuning Advisor as safe. I would assume that each and every suggestion is suspect until I tested it. I 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
December 23, 2013 at 8:05 am
Not seeing where someone said not to use differential backups or am I misunderstanding?
"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 23, 2013 at 8:03 am
Yeah, that makes more sense, and yes, it should just roll back to where things were.
"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 23, 2013 at 8:01 am
Jeff Moden (12/22/2013)
Grant Fritchey (12/20/2013)
"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 23, 2013 at 7:57 am
Viewing 15 posts - 9,166 through 9,180 (of 22,224 total)