Viewing 15 posts - 9,181 through 9,195 (of 22,232 total)
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
I'd see if you can recover that file and get your database back online.
Then, let this be a lesson, get good backups in place. Especially before you start modifying structures.
"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 22, 2013 at 8:25 am
Not with a missing data file. You have to have that.
"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 22, 2013 at 4:47 am
You'll need to restore this database from a backup. Or, if you have detached the files, you'll need to go through an attach process. Without all the data files, 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
December 22, 2013 at 4:28 am
Sorry. Not a comvault person. Do they have a forum? You might post there to see what people say.
"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 20, 2013 at 4:21 pm
Based on what you're saying, I'm pretty sure it's 8 for each machine, not shared. Unless you're running active/active and the instances are both on one server. Then, it's shared...
"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 20, 2013 at 4:19 pm
I'm with Kevin. It sounds like OS and possibly 32bit.
"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 20, 2013 at 4:15 pm
You can create a primary key and use the word NONCLUSTERED to force it to not be a clustered index.
But, other than that, you've got the answer. Unique constraints create...
"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 20, 2013 at 11:21 am
Viewing 15 posts - 9,181 through 9,195 (of 22,232 total)