Viewing 15 posts - 13,291 through 13,305 (of 22,224 total)
It kind of depends on how you learn, but sure, taking a course will absolutely help you increase your knowledge and your skill set. Now, there are courses and there...
"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
February 13, 2011 at 8:18 am
A backup that large directly to tape is going to take forever. Do you have multiple file groups you can backup from? That would probably work better.
At your size 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
February 13, 2011 at 8:15 am
I'd like to repeat exactly what George said...
Well, OK, I'll ad a little. If you can, seperate the OS from the mdf from the ldf. After that, it gets into...
"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
February 13, 2011 at 8:13 am
There are a lot of products out there that will do this. I've used four with varying degrees of success: SCOM, Idera Diagnostic Manager, Confio Ignite, and Red Gate SQL...
"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
February 13, 2011 at 8:05 am
Yeah, I've done it from a Blackberry in the past.
Now I use my iPad and my Droid. There are different ways you can do it with 3rd party tools. My...
"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
February 13, 2011 at 7:57 am
There are just tons of things to check. It's extremely rare for it to be the network. Most of the time, it's a badly written piece of code, or there's...
"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
February 12, 2011 at 8:22 am
It's a troll or it's an idiot. Either way, I think the conversation has gone way past the point where anything useful is going to come out of it. If...
"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
February 12, 2011 at 8:18 am
Raghavender (2/12/2011)
Thanks All for your valuable suggestions, it was nice discussion.If possible can you please provide the SQL Server interview questions ?
Nope. That's not how most of us work around...
"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
February 12, 2011 at 8:10 am
Better still, since you can't use point in time recovery while truncating transaction logs, just set your database to simple recovery and leave it there. Better that than having 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
February 11, 2011 at 4:24 pm
Henry Treftz (2/11/2011)
SQL Server 2008 Query Performance Tuning Distilled -- Fritchey
SQL Server 2008 Internals -- Delaney...
"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
February 11, 2011 at 9:02 am
I'd absolutely go with the Internals book by Kalen Delaney.
After that, it really depends on what your primary problems are. Make sure you make use of this place. there are...
"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
February 11, 2011 at 9:01 am
I'm not entirely sure I understand your question.
It sounds like you're saying that during inserts the area that you want to query is locked while the inserts are occurring 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
February 11, 2011 at 8:56 am
Right. Allocated space is not the same as used space. Allocated space has nothing to do with backup size. Used space does.
"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
February 11, 2011 at 8:46 am
Grant Fritchey (2/11/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
February 11, 2011 at 7:43 am
Tom.Thomson (2/11/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
February 11, 2011 at 7:41 am
Viewing 15 posts - 13,291 through 13,305 (of 22,224 total)