Viewing 15 posts - 13,291 through 13,305 (of 22,213 total)
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...
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.
February 11, 2011 at 8:46 am
Grant Fritchey (2/11/2011)
February 11, 2011 at 7:43 am
Tom.Thomson (2/11/2011)
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...
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...
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...
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...
February 11, 2011 at 6:32 am
Is this the name of your server: PERMISSIONSTEST? Does it have an instance name?
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.
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...
February 11, 2011 at 5:22 am
If you restore the file group, it restores everything in that file group. That means that all objects, all data, are reset back to what they were at the...
February 11, 2011 at 4:17 am
If you have another drive with space available you can try to add a file there in order to get enough space to attempt to resolve the issue, whatever it...
February 11, 2011 at 4:05 am
sturner (2/10/2011)
1. requirements document
2. design specification (here is where you define database objects)
3. test plan document
4. development
5. test
6. beta release
7. final release
Everything follows step 1. some...
February 10, 2011 at 6:51 pm
ramksharma91 (2/10/2011)
February 10, 2011 at 6:49 pm
Viewing 15 posts - 13,291 through 13,305 (of 22,213 total)