Because DepartmentID is the second column in the index (unique indexes are created automatically to enforce unique constraints), the only option available to the query processer is to scan the...

I'd go with a disk problem, and ignore the NOLOCK part of the error message. That specific error can be thrown if there is a corrupt page encountered while running...

RESTORE DATABASE TestDB

FROM DISK = 'D:\Backup\backup.bak'

WITH NORECOVERY,

MOVE 'DateFile' TO 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TestDB.mdf',

MOVE 'LogFile_Log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TestDB.ldf';

GO

In the...

SELECT Root_Cause_Analysis.value('(/RCA/PREVENTION/text())[1]', 'varchar(64)')

FROM T1.Submission;

A while back, I posted a breakdown of SAN snapshot options with SQL Server in response to a different question:

http://www.sqlservercentral.com/Forums/Topic795819-357-2.aspx#bm797256

-Eddie

Never researched External Activation, but we do have a number of queues with activated CLR procs whose purpose is to communicate with systems (such as Redis) outside of the SQL...

When multiple files exist in a filegroup, space is allocated from each file proportionally by the amount of free space in each file. Your new second file is only 1MB....

Full details at http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

The guy who said 'rip out a processor' was on the right path. If the Windows OS can see a processor core, even if you use SQL...

If you're making your own version of the proc with custom mods, try marking it as a system procedure:

EXEC sp_ms_marksystemobject 'your proc name'

-Eddie

Take the output of your first .nodes() method and use to both get the group name, and feed another .nodes() call to turn its children into a resultset:

SELECT R.N.value('@GroupName', 'varchar(32)')...

You'll need endpoints on both, because Broker conversations are two-way (send-ack). You also need the following routes:

1. On Initiator database: Route to target Service and instance IP, with Broker_GUID of...

if the two instances are on the same domain, then just set up the endpoints with Windows Authentication:

CREATE ENDPOINT BrokerEndpoint

STATE = STARTED

AS TCP(LISTENER_PORT = <port_number_goes_here>, LISTENER_IP...

There's a pretty simple fix to your script: add a table alias to the derived table.

A "derived table" is any time you use a subquery as a table in the...

PIVOT can help here...

SELECT DealerID, [A] AS Approved, AS Conditioned, [D] AS Declined

FROM (SELECT DealerID, AppDetails.AppID, [Status]

FROM...

Generally, when you have many sessions waiting on RESOURCE_SEMAPHORE, then you are starved for working-space memory. One or more big queries are consuming lots of memory and preventing others from...