Last SQLPass ( summit 2014 ) a twitter conversation popped up mentioning Paul White lost (part of) his voice

......

what connection library are you using?

What's the content of your content file ?

( does it contain the full connection string or just parts of it)

Can you mail the connection string...

Indeed.

If your connection...

the 20 characters limit rings a bell, but only for Reporting Server service accounts !

With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.

http://www.connectionstrings.com/sqlconnection/database-mirroring/

Simple test !

UPDATE A SET rowbefore = rowafter, rowafter = -1 ;

Select * from a order by TableName ;

UPDATE A

SET rowafter = (SELECT max(sysindexes.rows) FROM sysobjects

INNER JOIN sysindexes ON sysobjects.id...

Hurray on the upgrade to SQL2014 !

on the other hand, on top of the suggestions of the other repliers:

Did you ever check any variant of snapshot isolation level to avoid...

did you double check the "slow" instances service account is authorized to use Instant File Initialization ?

Since the date is in your result set, which date to you want it to have ?

Select EmpName, min( PayDate) as PayDate, WageType, PayRate

from Whatever

group by EmpName,...

can you share what you have tested and why distinct cannot be used ?

a simple group by on the 4 columns will also work and may even use available indexes

Spot on for the weak spot detection !

Enjoy your holiday !

how about this:

/* still using the recursive CTE */

Create table MyTable ( Id int not null, Name varchar(128) not null, IdParent int NULL );

go

Create...

I guess your interesting read would be Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and the sequels 😉

just solving your simple example using a cte can...

please refer to http://stackoverflow.com/questions/7843733/confused-about-updlock-holdlock

apparently just being member of 'public' on a database is enough to be able to script the create database statement. :crazy: