Figure out why it got to be that big?

Is there a scheduled BACKUP LOG operation? Is it actually firing?

Are your backup operations not truncating the logs?

Are you...

Agree with Steve. Having written one of these kinds of programs, most FTP clients (even automated ones) I ran into were very patchy at reporting an error when the...

Not that I know of.

I have a CLR function which will do just that if you need.

Greg Snidow (10/24/2007)

---

Matt, I didn't mean to change requirements. Still the same, but I did say I liked Jeff's function because I had the option of counting start day...

For what it's worth Tomm - Greg's requirements seemed to be a little different (at least the ones at first), which is why several of the functions "fail" your...

Kenneth Fisher (10/24/2007)

---

I always thought the decision to agragate on NULLs made perfect sense. I can't think of the number of times I have needed a count of how...

Jamie Thomson (10/24/2007)

---

Good summary. I still want to know what happens if I request the number of nanoseconds between Year 0001 and 9999 using datediff. Cos as far as I...

...especially when you factor in that although Null is never equal to NULL, NULLs get aggregated as one data point (as that recent featured article pointed out). Kind of...

You do seem to be using UNION incorrectly (it's not going to do what you want it to) .

That being said - you're getting the error because you have a...

I must be in need of more caffeine...

My first reaction was "have a cattle prod installed at the door - when they scan in two entries or exits - ZAP...

I particularly like the "malicious attack" theory by unknown people using unknown methods that the Paciolan mgr floated by foxnews. oh - and no logs to back that up...

Jeff Moden (10/24/2007)

---

I gotta agree with the excellent testing, there. Nicely done.

Just to be sure my eyes haven't gotten too bad, though... test results say 10M... but I'm pretty...

Without a "useful" clustered index (i.e. using rowID as the clustered primary key), here are the results:

05 case method38563no index

08 pivot method41030no index

06 case method39186prodidcoid+amt

10 pivot...

Jeff Moden (10/23/2007)

---

Hmmm... I wonder how Pivot in 2k5 would do against these simple 3 value pivots on a million...

Generically - you cannot use EXECUTE or sp_executeSQL within a function. You can only call functions or extended stored procs from within a function, and those ain't it.

Good news...