Did you play a bit with the PARAMETERIZATION option ?

Alter databaset yourdb

set PARAMETERIZATION FORCED

http://msdn2.microsoft.com/en-us/library/ms175037.aspx

Maybe it's this kind of queries the tried to tackle using this option :hehe:

ps

If the recompile...

- While you're at it, you might as well split the source file to match your

table's structure if you can:unsure: Then you'll be able to bulkinsert 😉

- Sort the files...

please don't xpost, many of us watch more than one forum group.

Might get somewhat confusing 😉

- Did you install SQLexpress mgmt studio ?

- did you apply the servicepacks ? (on...

is there a folder c:\program files\microsoft sqlserver\ ?

can you find something in the path you specified to contain the data ?

Is there a log-folder your datapath in the same folder as your data-folder resides ?

they certainly should change because there are usage restrictions with developer editions (licence).

I haven't performed a dev to EE edition myself.

Maybe it's worth the effort to reinstall if you have...

I just knew this article would come in handy.

And you see, it only took 52 days before I got to it. :w00t:

I used the stuff example, because there was a...

I don't think so.

btw I wouldn't advise it at a production box because profiler can generate

a huge overhead !

Actually I consider traces one way of getting in contact with...

If you want dates, use datetime columns because then you can use all date-related functions, order by, ...

Like Steve mentioned. replace Q1 with an actual date.

In datawarehouses it is common...

hopping in a bit late 🙂

In stead of the if exists ...

you might as well check the update's @@rowcount and if that is not what you expected it to be,...

Well, it turns out that the tsql-storedprocedure-version of that clr function actualy ....

Here are the results from the simple test jury 😉

TheVersion ExecCount AvgElapsMs MinElapsMs MaxElapsMs

clrfn ...

If I'm correct that info is stored in a sqlagent registry key.

Maybe you can find it if you analyze msdb.dbo.sp_get_sqlagent_properties.

I don't know if changing that key value even would actualy...

Jeff Moden (2/19/2008)

---

I'd be real interested in knowing...

Christopher Ford (2/19/2008)

---

BTW, on a production test.

I had to run Jeff's running total update because I had 80 million rows to group by 1,928,672 different accounts over a 7 year...

Thanks 🙂

OT bis

Is there an "common CLR pittfals" link somewhere ?