Just to let you know the execution time of the stored procedure that was using this part of code reduced from over 13 minutes to 3 seconds

Great J! that made it even faster! Never used that in Over clause

ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

Learned something new today. Do you have some nice reading about...

Thanks! I know how OVER works, used it loads of times before, but i don't know why I didn't think of it in this case. It must be Friday :hehe:

Yes they are unique.

Anyways, THANKS ! Worked like a charm in 2 seconds.

I owe you a beer.

Welcome!

Where about in UK are you based if i can ask? 12/09 there is a SQL Saturday event int Cambridge.

http://www.sqlsaturday.com/411/eventhome.aspx

how many records is actually being deleted?

Good idea would be to do it in chunks.

Ok, looks like problem is solved.

We are using asynchronous mirroring and the secondary was falling behind. There was some other process on the secondary that was taking IO for some...

Also for the xml to have the correct format it can't have multimple root level elements as it has now.

Thats the closest i could get

SELECT Campaign [@name],

(

SELECT Price [@value]

...

What if you put CALL at the beginning?

like:

CALL C:\Windows\System32\WindowsPowershell\Powershell.exe -File "E:\Schedule\Test.ps1"

No, not yet. Anyway we provide secure access to our databases and some of the customers like to develop own solutions but some want us to do it for them.

Thank you Lynn, appreciate the effort.

Jeff,

I did try to avoid it but for this particular product i couldn't find better way. For another one I've used merge replication with dynamic...

heh true Luis! will remove them.

When the software is being upgraded it automatuically backs up a database, It's just a full backup, so i thought at least knowing how to do a backup would be...

Thank you Jeff,

I’ve actually read many threads on this forum and know that you do have some experience in recruiting sql "professionals" so any input would be highly appreciated.

I've...