Viewing 15 posts - 13,306 through 13,320 (of 22,232 total)
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
SKYBVI (2/11/2011)
thts difffernet from wat i said...I said hte approx backup size and u told abt hte total size of the db.
Regards,
Sushant
No, if you look, that's the total space used...
"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:21 am
SKYBVI (2/11/2011)
You mean a trigger??But, wats wrong in seeign hte default trace for data changes, i cant get tht.
Regards,
Sushant
What's wrong with using the default trace to look at data changes...
"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 6:38 am
SKYBVI (2/11/2011)
GO to database-->right click -->tasks--> shrink--> files-->
see the avalaible free space( %)
100 -( %) = % of 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
February 11, 2011 at 6:34 am
I don't mind pointing out that Red Gate has a tool that can help with this. It's called SQL Storage Compress.
And before you guys start throwing heavy blunt objects at...
"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 6:32 am
Is this the name of your server: PERMISSIONSTEST? Does it have an instance name?
"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 6:09 am
SKYBVI (2/11/2011)
@ gail..Then wats the alternative?
Regards,
Sushant
There is no alternative out of the box. If you need to track data changes you must create mechanisms for doing 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
February 11, 2011 at 6:06 am
But, the default trace doesn't track data changes. If you don't already have something auditing your database, a third party tool, or a server-side trace, there's no way to find...
"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 5:22 am
Viewing 15 posts - 13,306 through 13,320 (of 22,232 total)