One of my databases is 25GB, the compressed backup is 2,9GB. Another one, database 105GB, compressed backup is aprox. 20GB.

And still on truncate, an interesting view you can read about...

alex.sqldba (12/8/2016)

---

So he removed his data, but to his surprise the database did not "shrink". Of course it does't!!!!!! SQL-server does not know what you want to do with it...

I was just reading this and I have a few questions for you about it that really confuse me:

1 - Why shouldn't you do regular statistics updates and index rebuilds...

Ah, sorry , ignore....

I keep having these conversations with people who don't know how the SQL server engine works that SQL is looking after itself. I recently asked one of my analyst to...

I totally agree with SSCertifiable.

People were constantly complaining about one of the servers I have in my place being utterly slow. When I studied it thoroughly and implemented some...

Ha, I decided to put the sp_who into an SQL script and run this in CMD:

sqlcmd -i who.sql | find /v "sa" | find /V "SQLSERVERAGENT" | find /v "Administrator"...

Thank you all for such a quick response. That looks like MS making life easier for us. I'll mark all answers as "answers", although the CREATE MY OWN TABLE seems...

Lynn Pettis (10/28/2016)

---

Jeff Moden (10/26/2016)

---

Kazmerelda (10/25/2016)

---

My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in...

MMartin1 (10/26/2016)

---

Depending on who you ask, if you go around the company eventually you might find most all of...

I would consider myself an old command prompt style guy, I started my IT work when there was no such thing as Windows and all we had was code. To...

A DBA is a person people come to first to fix a problem with a slow system.

As that DBA is usually redirect them to the Network or Desktop Team....

So many acronyms and so much jargon is used in blogs, even the ones presented here they put me off. As soon as I run into 1 or 2 at...

Add "Productionize", sounds posh though 😛

I basically haven't got a choice, although I am being named "the database expert" I do what I am being asked to do. Some of us haven't got the luxury...