with 17 parameters, no doubt most of them are optional....and might have default values? sounds like parameter sniffing...fast in SSMS with static values, compiled is slow.

search for "parameter sniffing" here...

yep i think muthukkumaran Kaliyamoorthy nailed it; someones in the database...maybe even you in the same or another SSMS window.

ALTER DATABASE MyDB

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

I have no idea, and neither did the original poster;that's what i thought was so funny; i know it's a tool, but I cannot even...

asm1212 (6/27/2011)

---

Thank you so much Lowell...

That did it for me! Just for giggles: Can you explain that Row Number function and OVER PARTITION BY clause as it relates to these...

jbhauser (6/27/2011)

---

I am trying to utilize Gianluca's procedure (nice work by the way) against the corrupt databases found in the conference link above. I cannot get around the error "converting...

the WITh clause is a newer, fancy way of creating a temporary table...it's valid only for the next statement after the closing parentesis of the WITH;

so it's like saying CREATE...

oh yeah, that inner join:

inner join [MWLWEB].[dbo].[MWL_XY_Coordinates] Coord

if that join has more than one record for any thing it's joining to, you could get mulitple rows....so if there are...

you've got two SELECTS witha UNION, but only one of the selects have a WHERE clause...could that be it?

SELECT

[ToID] AS [ID],

[Origin City] AS [City],...

still easy to do via TSQL;

you can use the row_number() function to partition the data by those 8 columns.

wrap teh results of that with an outer select where rowNumberAlais =...

could your test server be low on disk space? maybe it's taking a long time trying to allocate disk space to the backup before it can ctually do the restore....

why not just use a set base operation regardless,and exclude anything that might duplicate? by joining the source to the original table, you can automatically exclude them, or find...

hodhod26 (6/27/2011)

---

this data is related to antivirus servers which running from 3 yeares or more we need to delet old data because this size of data make the server so...

yeah, when i look at powershell at first, i have no idea what it does or what it can do.

pure syntax issue...the OUTPUT...INTO goes BEFORE the FROM:

Delete t

Output Deleted.TableTID,

Deleted.Value1,

Deleted.Value2

Into...

oh lookie: you can do it in powershell as well:

i searched powershell read application log...looks a little easier to do:

# query an event (Filter Equal)

# you could change the...