Good to see I'm not alone 😀

Thank you for the interesting...

Good luck with it then 😉

The article should give you some ideas for improvements.

Gilles Willard (3/15/2010)

---

It seems to me that what Timothy is proposing is simply adding a few FKs to his database design to cut down on the JOINs required to get...

You can't. Either import the data as a string...

University flashback: Zener diode

Cyberspy (3/15/2010)

---

Now, I presume that the authors expect an error could occur in the SQL , which is why they wrapped it in a transaction so it could all work/fail...

...and I did learn something. The keyset cursor I ended up creating is initialized using a plan that features a Sequence Project operator using a special internal-only version of...

There are other methods of course: xp_cmdshell, sp_OACreate, and so on. All pretty horrible.

CLR is the correct tool for this type of job. It is a good article,...

Actually, I had to think quite hard to get that cursor right. I am not proud of it though...

Arjun Sivadasan

---

I meant to say that Steven can use temp table instead of CTE (which i had used in the query). CTEs crawl when there are heavy where clauses and...

That is not one of the many date/time formats supported...

SSC Article: http://www.sqlservercentral.com/articles/SQLCLR/65656/

Arjun Sivadasan (3/15/2010)

---

Ya I have tried that (the temp table approach on queries that return ~40k rows with performance improvement from 10 to 2 secs. Of course, with the addition...

Normalize 'til it hurts...de-normalize* 'til it works!

* appropriately