Viewing 15 posts - 316 through 330 (of 700 total)
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)')...
January 24, 2012 at 3:05 pm
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...
December 14, 2011 at 2:10 pm
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...
December 14, 2011 at 1:09 pm
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...
December 14, 2011 at 12:44 pm
PIVOT can help here...
SELECT DealerID, [A] AS Approved, AS Conditioned, [D] AS Declined
FROM (SELECT DealerID, AppDetails.AppID, [Status]
FROM...
December 7, 2011 at 4:41 pm
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...
December 7, 2011 at 4:21 pm
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...
November 7, 2011 at 12:29 pm
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...
November 3, 2011 at 2:57 pm
Anything running on a computer consumes memory and CPU, and often I/O. This includes SSMS.
November 3, 2011 at 2:10 pm
There's a couple different ways to do this, here's a quick and simple approach:
select ServerName, InstanceValues.value('(./@CLASSNAME)[1]', 'varchar(64)') AS ClassName,
InstanceValues.value('(PROPERTY[@NAME="Caption"]/VALUE)[1]', 'varchar(64)') AS Caption,...
November 1, 2011 at 4:22 pm
The short answer: add ', type' to the Submenu XML statement:
for xml raw ('Submenu'), type
October 26, 2011 at 10:36 am
IF NOT EXISTS(SELECT * FROM Customer WHERE col1 = @x AND col2 = @y AND @col3 = @z)
BEGIN
-- do stuff
END
October 6, 2011 at 1:30 pm
Backups occasionally fail or get corrupted by storage. Full backups do not break or clear the log chain. If last night's backup is not recoverable, you can use the prior...
August 17, 2011 at 1:35 pm
In the bulk-logging recovery model, transaction log backups contain all data pages that were modified as a result of the transactions in the transaction log backup. (Yes, the full modified...
August 11, 2011 at 4:37 pm
Ninja's_RGR'us (8/10/2011)
Eddie Wuerch (8/10/2011)
If you're seeing loads of CMEMTHREAD waits in SQL Server...
August 10, 2011 at 2:41 pm
Viewing 15 posts - 316 through 330 (of 700 total)