Actually neither version works 🙁   I've ran both and here is what they return and here is what I would expect (excuse the date format I copied via excel)

thank you Phil much appreciated

thank you all for the suggestions going to work through them now

many thanks Simon

I did try this but the results were garbage 🙁

WITH
percentiles AS
(
SELECT
NTILE(100) OVER (ORDER BY duration) AS percentile,
*
FROM
trace_table
)
SELECT a.textdata2 , a.duration as '95th' ,min(b.duration) as 'min',max(b.duration) as max
FROM...

Hi Steve 

Yes of course , hth

CREATE DATABASE My_DB1_snapshot ON ( NAME = N'My_DB1', FILENAME = N'c:\shared\My_DB1_snapshot.snap' ) AS SNAPSHOT OF My_DB1;
RESTORE DATABASE My_DB1 from...

no its a 64 bit VPC

thanks Simon

yes I had tried both the above with no success (-:

thank you Hugo I will give that a go 🙂

Is there a an extra dmv I can add to sys.dm_server_services so I can use a query to highlight when an account is not a common domain account ? and...

Hi Jeff

could you elaborate please ? what sort of thing am I looking for ?

thanks simon

thank you all for the wealth of information ... first day back in the office today so I'm just playing with the solutions ... one thing I have noticed so...

Thanks Jeff for the handy hint on the sort of data required and how to post it .. heres a very small subset of data, one chain with a single...

many thanks for all the help , appreciate that 🙂

spaghettidba (5/12/2015)

WITH examples AS

(

SELECT *

FROM (

VALUES

('ABG1226807'),

('@BC1224706'),

('AB!C1224706'),

('ABCZ122470'),

('AABC 122470')

) t(ex)

)

SELECT...