You'd have to get more details from someone. There might be whitespace in fields if you have char instead of varchar fields.

If they mean you have more space in your...

We want to see you do some work, so make an attempt.

As a hint, group by the clients, count the currencies.

And you'll need a HAVING clause.

You can use sp_spaceused to see the space inside a database.

alternatively, track the backup file size and compare that to what size of the data file and you'll have a...

If you don't have a degree, you don't know what you're missing. The fact that poorly built databases are developed by those with degrees doesn't mean a degree didn't help...

closing

http://www.mssqlcity.com/FAQ/Devel/xp_regwrite.htm

No real reason that this is better than scripting this in VBScript. I guess it might be easier if you have connectivity to each SQL Server instance.

I have had MSX/TSX...

Why did you write it this way? I'm curious because you might have a good reason, or you might be thinking about this wrong.

If you reversed the statements, and looked...

Nothing wrong with emailing to Hotmail if it isn't sensitive information.

We used to zip up each day, copy to a remote disk, separate folder for each day. Gave us easy...

Just as a short note, backup and restore should be your first DR thought. You might supplement that with mirroring, replication, etc., but be sure you can restore a db...

you need to stop shrinking it.

Obviously you need more log space, so make the log bigger (or leave it big) and the tickets will stop.

If you have the db at 65GB, what percentage is used, and what is the growth rate?

For the re-indexing, you need space, but that depends on your clustered indexes, which...

Well here's a nice April Sat morning in Denver:

http://lh3.ggpht.com/_8hTidvPiTuU/SgCqmUxlXLI/AAAAAAAAAiI/pxf8WYs9zH0/s512/Apr_snow_a.jpg

And here's lunchtime:

http://lh5.ggpht.com/_8hTidvPiTuU/SgCqmB_QA8I/AAAAAAAAAiA/VMCiDCZDEa0/apr_snow3.jpg

And here's late afternoon:

http://lh3.ggpht.com/_8hTidvPiTuU/SgCqlzeT1vI/AAAAAAAAAh4/XmnjzlFDV0w/apr_snow2.jpg

It was gone by Monday.

Yep, it's usually me too!

😀

I think someone assumed all data on the same drive, which is likely for many installations.

You could do that, but what if something else happened there? I'll admit it's not a bad solution, an it's not likely something will happen, but I prefer things like...