Are there multiple SQL instances on that box?

What port is the DAC running on?

xp_readerrorlog 0,1,'Dedicated Admin Connection'

Also, what happens if you disable remote access to the DAC and retry the...

Just curious, where did you end up hosting the fileshare?

Be sure to test all possible failure scenarios and make sure everyone in your team understands the implications of...

In my opinion, yes, I would set affinity to the available NUMA nodes to avoid overlap between the instances if they are all high workload at the same time.

However that...

Run a Profiler trace before you start SMSS and see what it's doing

Yes, works perfectly, we do this every time.

The DNS entry for the old server is deleted and becomes a DNS alias (A record becomes a CNAME pointing to a new...

nolock seems to work fine, can you give an example?

----------- Read Committed Snapshot Isolation -----------------

CREATE DATABASE [test]

GO

USE [test]

CREATE TABLE dbo.aaa (id int)

GO

INSERT INTO dbo.aaa

VALUES (1)

GO

ALTER DATABASE test SET read_committed_snapshot ON

GO

SELECT...

Dont use SQL_Latin1_General_CP1_CI_AS / AI with a varchar variable datatype if you have unicode data. You will experience problems like the one you have due to an implicit conversion....

If you forced quorum in Virginia and the 4 Texas nodes were to become available without access over the WAN, then they will form quorum and you will have a...

http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx

When you create a foreign key constraint, you can specify ON DELETE CASCADE (or UPDATE). This means that if any row is deleted in the parent (referenced) table, the delete...

If you chose to use a file share witness, total votes is 7 with 4 being the minimum votes required for quorum.

If you hosted the file share in Texas and...

You can create a static row filter on the published article so that only column > getdate() -7 is published.

http://technet.microsoft.com/en-us/library/a6ebb026-026f-4c39-b6a9-b9998c3babab

The other option is to create an indexed view, basically subset...

In the screenshot you have attached, it says the edition you are trying to install is "Express with Advanced Services".

Express editions only include the "Basic" management tools.

Are you...

Add the port number to the IP address. To find the correct port number: http://support.microsoft.com/kb/2466860

Yes but the instances need to be hosted on different nodes of the cluster.

http://msdn.microsoft.com/en-us/library/ff877884.aspx#AGsARsADBs