Ramu... you there? I'd still like to see the...

S (3/20/2009)

---

Hi,

Thanks for the reply.

I should have expressed it clearly or more correctly.

Is it possible to achieve it with out using multiple statements (exclude subqueries as they are part...

There are three problems with recursive CTE's being used to supposedly resolve hierarchies...

1. Recursive CTE's are slower than cursors and a fair bit slower than a good "Fire Hose"...

Ummm.... just a couple of things to clear up here, folks. First, DBCC ShrinkFile does not now nor has it ever nor will it ever cause fragmentation. It's...

No... the cache I'm talking about is in the memory of the SQL Server.

And, no... indexes don't take care of themselves. Now that you've identified that you're not running...

Sounds like a plan... like you, I'm a bit busy this weekend but I'll get things going on this soon. We should also explore some of the other...

Sorry... I believe that one of two things has happened here... either that the two of you guys on the interview left something out of the code you posted, or...

Yeppp... couple/three things... first, it sounds like you may have a little "parameter sniffing" going on. Google'ing that will produce a pot wad of information on what it is...

Shoot... you don't need a whole bloody sentence... you can sum it all up in one word...

[font="Arial...

Sure... well, maybe except for the article thing. I was thinking that the idea of using a sequence table correctly would make a good article right after I wrote...

You've managed to hit the other area that I drop the sword and shield on for CLR deployment... file management. 😉

As you know, hierarchical data in SQL Server is a...

ab5sr (3/21/2009)

---

Tell him "it depends". Ask him if DBCC FREEPROCCACHE or DBCC DROPCLEANBUFFERS has been executed first, and then follow up with the parse, optimize, etc. steps answer. You can...

You get no argument by me... I'd much rather use the highly scalable high performance method of using IDENTITY than going through all of the headaches of using the likes...

... and, I apologize for not being able to help you with your original question.

Giovanni (3/21/2009)

---

Well,

I know about the ever going discussion on pros/cons, dos/donts between CLR UDTs/UDs and T-SQL ones.

I must admit I am not a fan of religion wars, so I generally...