I think what Nanda meant was that the meta data is now secured along with access to the objects themselves, so you can't assume that any given user has access to...

VMWare can be great for training/development/testing environments, but I wouldn't want to run a busy production SQL Server instance on VMWare. 

Virtual machines are all about maximizing hardware resources, based...

Good point!  I neglected to mention the INSERT problem...

"Don't distract me with standards, they just slow me down!"  Of course almost everbody who has anything to do with development efforts...

The way most DBMSs (including SQL Server) allocate space by grabbing contiguous extents is intended to minimize the effects of file system fragmentation.

Also, since data access in OLTP envionments tends to be...

I'm pretty sure that he was referring to file system fragmentation rather than the logical fragmentation within the SQL Server data files which is what the DBCC commands address.

You can script out the backups, but yes each database is backed up separately.  You may not need to run a full backup if you have a recent full backup...

So I'm going to guess you are wanting to use transactional replication.

David's initial post indicated that there were unique indexes but not PKs.  If this is the case, and the...

As a rule I don't like GUIDs as primary keys, but like most rules, there are exceptions...

I won't claim to be a replication expert (I have only used Snapshot replication,...

Yes it can, but that depends on a number of factors such as the type of activity being performed, and the amount of freespace in the index.

I wasn't disagreeing with...

What David says is true, but it has nothing to do with primary keys versus unique indexes per se.  His is an argument to make sure your indexing strategy makes...

Tell the original developers that they are full of it!  A primary key is physically implemented by a unique index but with the addition that NULLs are not allowed.

If there...

This isn't the error usually associated with not rebooting but I just thought I'd check...

You forgot to spin in a counter-clockwise motion while throwing air and chanting Bill's name.

Have...

The problem is that you are basically "rolling your own" cursor by using the WHILE loop.  Yes, you should avoid cursors if possible, but that advice should be broadened to...

A bit more information would be helpful here...

Generally though, the default settings work pretty well.  The biggest possible exception is the data file size and placement.

Have you rebooted since the uninstall?