You could add "WITH NO_WAIT"

It is best to size you files so that autogrowth does not occur and manually extend your files in response to data growth.

As you said this gets you away from...

The results you are getting have to do with rounding rules.

They may be related to accounting rounding rules.

The money data type is not an MS construct.

It came over with the original Sybase SQL Server code.

You could also put the tables in their own schema and grant the user select on the schema.

You should use CDC on the versions that have it.

On the older versions you could subscribe (pull) to their publications, modify the replication MS

insert and update procs in the...

Sorry, I have IP constraints.

What I have done is create a powershell script that goes to all of my instances,

scans the log from a given timestamp and sends me email reports for errors...

Best practice of shrinking the transaction log is to shrink it all the way down to smallest size possible (close to 0) and then alter the log to grow it...

If you are going to shrink the data file(s), you should leave enough space to rebuild the clustered indexes of your largest table.

After shrink you must rebuild all clustered indexes.

If the table is a HEAP only DELETE WITH (TABLOCK) or truncate are guaranteed to release space.

Best way to delete from a large table is to traverse the clustered...

And remember to include host, IP, process id, login, and SQL text of BOTH the blocker and the blocked.

make sure you store the wait time in ms so you can...

Another valid use case is of course as input parameter to a stored proc.

Again, if i have a substantial amount of data in the table variable input parameter,

I immediately move...

Be careful in using @ type temporary tables.

The optimizer has no statistics on @ tables and assumes it has ONE row.

Even if you put a primary key on it, the...

Full database backups represent the database at the time the backup finished.

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