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...

Additionally, if those users are accessing an application on another computer that is not their workstation (client-server/multi-tier/etc), then the server that is accessing SQL Server requires a Machine CAL in...

An extra monitoring query every 5-10 minutes shouldn't be of much concern, depending on the size of the returned dataset. If it is, you have bigger problems than monitoring. Just...