Here is somewhere you could start

http://msdn.microsoft.com/en-us/library/ms179855(SQL.90).aspx

If I am catching this correctly,

You have a 270GB Data file that Had 7GB free prior to a truncate

Currently you have a 270GB Data file that still only has 7GB...

What have you done to try and troubleshoot?

Check jobs

sp_who2

blocking

long running queries

something outside of sql server consuming the processor

Two methods

dbcc checkident

and

Truncate Table

If you do a search on the checkident command you should be able to find the parameters and usage

krypto69 (10/15/2009)

---

This is customer sensitive data, SSN#, etc....

I was told my predecessor had configured encryption, but all the data I have seen in all the databases..none of that is encrypted..

Wouldn't...

Charip,

First Logging would have to be enabled. Do you know if you have logging enabled?

Here is a whitepaper on the subject provided by our friends at Microsoft.

http://msdn.microsoft.com/en-us/library/ms138020.aspx

You could also...

I am curious why you need to use sql server to stop this service. I am also curious what service is being stopped and what is being restored.

These are...

Grant Fritchey (10/14/2009)

---

Bob Hovious 24601 (10/14/2009)

---

What next?

"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put...

jcrawf02 (10/14/2009)

---

This made me laugh, as I have a sneaking suspicion that some of...

I would assume this is for audit purposes. You might be able to satisfy him by demonstrating that the data is encrypted in the database (via certificate or otherwise)....

Since this was side by side, are those the current file stats for the 2000 instance?

Did you by chance perform a Reindex operation on the 2000 Instance while the file...

GSquared (10/14/2009)

---

s ss (10/14/2009)

---

GilaMonster (10/14/2009)

---

s ss (10/14/2009)

---

I was just wondering (in case I may have some questions in the future) what's so different about this post: Delete Duplicates then...

db_bunny (10/14/2009)

---

Hello folks

Is there any equivalent DMV for monitoring object access of other types, such as how often certain stored proc's are executed? And if not, what is a good...

This is as I figured. I could think of no sound reason for this type of setup. When I checked the original creation script for this table, both of...

Been there, done that with kids (i have 4). I don't know which part is more exhausting - the driving or the kids who never get tired and are...