Viewing 15 posts - 11,866 through 11,880 (of 22,224 total)
Of the year? I think I'd put it down to of the decade, but that's not what the contest was. Regardless, congratulations Jeff. You earned it! Can't wait for the...
"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
September 14, 2011 at 3:40 am
A single file also means if the file gets corrupted, you lose one backup, not all of them.
"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
September 13, 2011 at 8:26 am
Jpotucek (9/13/2011)
I AM doing regular Databases backups Full nightly Database backups and Transaction Log backups where appropriate and depending on the SLA with the...
"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
September 13, 2011 at 8:21 am
Piling on a bit, because it's a point worth making.
Most backup products are not aware of the fact that SQL Server has this pesky little function called a transaction. So,...
"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
September 13, 2011 at 6:54 am
Bob Fazio (9/12/2011)
The reason why we are leaning towards the patch, is because I think everyone agrees, one bad...
"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
September 12, 2011 at 3:41 pm
Chad Crawford (9/12/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
September 12, 2011 at 1:57 pm
The performance counters would be primarily waits and queues, but you need to combine perfmon with query behavior. You can't just measure one or just the other. What's the page...
"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
September 12, 2011 at 9:35 am
Since this is a reporting system, you might not want to go as high with the cost threshold, 25-30, which means your average cost of 35 might still get parallelism.
CXPacket...
"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
September 12, 2011 at 8:26 am
Ninja's_RGR'us (9/12/2011)
Imagine losing 1 out of 100 dbs. It's annoying to very problematic, but if ALL of them 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
September 12, 2011 at 5:59 am
nikk_Stone (9/10/2011)
thnx...but the book which you have told me...it is not free of cost...
i have to buy it online...
i want a frre book
There are some free books out there. But,...
"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
September 12, 2011 at 5:47 am
Yes and yes. If the system databases go offline, you're just as in trouble as if the user database went offline.
"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
September 12, 2011 at 5:35 am
I know, I know, I know what you're going to say, but I can't help thinking that this could be a handy graphic to keep around:
Besides, I like cats. I...
"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
September 9, 2011 at 3:42 pm
syen (9/9/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
September 9, 2011 at 9:04 am
syen (9/9/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
September 9, 2011 at 7:58 am
Ben Moorhouse (9/9/2011)
Grant Fritchey (9/9/2011)
I consider military service a plus, but degree's... nope.I hadn't even considered that!
Is there a specific skill/discipline you like to glean from military service?
Not really. Just...
"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
September 9, 2011 at 6:17 am
Viewing 15 posts - 11,866 through 11,880 (of 22,224 total)