What is your MAXDOP setting on the server?

Index creation time is improved greatly by parallelism. Most of my OLTP servers have maxdop=1, but when I create indexes, I use maxdop=0...

I wouldn't necessarily consider this a bad practice, since it's not creating any extra work. If you weren't using the view, you would have to use the source tables, and...

You can run the snapshot agent to get the initial snapshot, and have it save to disk locally (make sure you don't select compression, since there is more than 2gb...

Quick way to check if it's enabled is try enabling AWE on the server.

Run it via t-sql with sp_configure:

sp_configure 'awe enabled',1

reconfigure

If it lets you, then the policy is set...

I don't think my Quorums have ever grown over 4mb, for what it's worth 🙂

At least not while I was looking..I always allocate a 1GB lun for them, since...

Make sure you have Lock Pages in Memory set, and I typically try to leave 4gb free on systems up to 32gb, and 8gb free in the 48-128gb range, especially...

Command line works best when possible.

SSMS Express is missing certain features (replication monitor and some other enterprise-level stuff) but works for 99.9% of the things most devs need it for,...

Do it in a cursor. Set up a 1 column table with a list of schemas you want it copied to, script out the table definition, set the schema name...

Just a note...you should never have SQL running under a user's domain account (such as yours). If your account is locked out, or your password changes, or someone messes up...

I have renamed plenty of boxes running SQL 2008. The biggest thing is make sure select @@servername returns the correct name. For linked servers, just script them out and recreate...

This happens with read_uncommitted sometimes, due to how data is moved in and out of indexes as it is written and updated. You could try to force it to use...

It sounds like you want to search all columns in all tables in the entire database for occurrences of this value? Is that correct?

So you have one source table and one destination table, and you just want to make sure the destination matches the source?

If that's all you need, then there are a...

Just a quick additional note: is the physical_io still changing while it's in this state? Do you have disk queues for the data files it's accessing? If it's a frequently...

I pretty much always use standby because of the aforementioned ability to read it in between log restores. norecovery is 100% unusable (until you need to restore it with recovery).