This works, but only if you don't get too deep with levels

jim

DECLARE @STR varchar(100)

SET @STR = '/folder/folder1/folder2/12345-ABCD.txt'

SELECT '/' + parsename(replace(replace(substring(@str,2,100),'.','|'),'/','.'),2) +'/'

You may need to play with the joins a bit to make sure I got all the neccsary ones

DELETE FROM a

FROM #asset a

INNER JOIN

(

select *,[rank] = rank() OVER(Partition...

I believe this might help you

declare @date datetime

set @date = '01/08/2010'

SELECT DATEPART(day,@date),DATEPART(weekday,@date)

SELECT CASE

WHEN DATEPART(weekday,@date) = 2

...

Well, here's my stab at it. I am sure there is better way to do this using the APPLY operator

Jim

DECLARE @Table1 TABLE (id int,Date datetime)

DECLARE @Table2 TABLE (id int,...

Mike (2/18/2009)

---

I would be curious if you looked at the statistics io if they are the same on both machines. They should be but my thinking is that perhaps...

Yes, I did.

Unfortunately, still at 30 secs

Jim

I changed the threshold to 20, but no change. Here's what my sysadmin had to say about the hardware

"The hardware is better 71 & 245, 69 is...

The max DOP is set at 0 for both, and the cost threshold is set at 5 for both. Should I change the threshold to 20?

Jim

Grant,

The new database was copied from the old, but I'm not sure of the technique. I am the only one in this database now and will be until we...

I have checked the settings and the only diff I see is that the new db is set at

nameminimummaximumconfig_valuerun_value

max text repl size (B)0214748364721474836472147483647

and the old is set at 65536. ...

It's a new server. The old one returned the results in about 12 secs. I'm not sure yet about hardware or configuration differences yet, that question is in...