If you absolutely have to shrink it you'd be better off using Shrink Files and selecting the specific ones you want to work on--Shrink Database would attempt to shrink the...

Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max...

Maybe I'm misunderstanding here, but you seem to be complaining because your database has got SMALLER after adding the clustered index (57Gb to 56Gb). Not sure why this is an...

Why is there a full stop (or period, if you're American) at the beginning of the...

I agree. If you're only doing one transaction log backup a day you might as well put the database in Simple recovery mode and skip the log backups entirely.

Question is, why would doing this help in any way? Whether you're sending 200Mb of data every 15 minutes, or sending 90Mb every 7 minutes when the log file gets...

And stopping it will also tell you real quick if somebody actually IS using it, because you'll get a complaint! (Or something you have installed will stop working). 🙂

Thanks for...

What edition of SQL Server? Pretty sure the "lock pages in memory" thing only works on Enterprise Edition (or Developer Edition, which is essentially the same thing with more restrictive...

I carefully left that third option unchecked because I thought it was the author attempting a bit of a trick by having just that one worded differently from BOL, too!

If you *are* relying on autogrow, the default setting (increase data file size by 1Mb every time) is ludicrously small for pretty much any non-trivial database...increasing that (once you've got...

This thread is more than two years old...I'm sure the people who posted in it have probably figured out by now that SP3 is available, especially since that's been the...

One of our developers stored a TCP port number (which is, by definition, an unsigned 16-bit integer)...

Guessing that's a feature of the beta version of 7-zip--can't find any evidence that 4.65 supports it.

The only way I can see to get those copied files much smaller is to use a more efficient compression technique. Zip offers several levels of compression (higher ones requiring...

I'm sure there's been a very similar one in the past two or three months--I forget exactly when...