No, no... that's not it... I put them in my mouth to get them all lubricated up before I put them in the cannon. 😀

Heh... no, no... not...

BWAA-HAA!! 😛 Dude! 😀 No hold out... it's in the article, too!...

hemin.shah85 (1/24/2009)

---

Jeff you are right. With(index(0)) works really fast...as I have a dataset of 6 million records..Thanks for your help..But I was thinking, can we do this without updating that...

Gail has complained about the really ignorant answers that some folks place on the forum. I've got a perfect example of such ingnorance and it really burns me up...

Sankar Reddy (1/24/2009)

---

Set based solutions tend to be faster than the RBAR operations while taking less system resources. Doing a task 100 times is much likely to take more time...

By the way... the following article on "Alternatives to SQL Server Cursors"...

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AlternativesToSQLCursors&referringTitle=Home

... sucks. In one case, they use a WHILE LOOP instead of a cursor and in other...

I agree with Seth and would like to point out a couple of other forms of RBAR to avoid...

CTE's are a wonderful tool... until you write a recursive CTE which...

Sankar Reddy (1/24/2009)

---

There are no built-in SQL server functions that handle this. You have to write this yourself although this problem has been solved in many ways as Chris pointed...

You want experience and something you can point to on a "beginners" resume? Spend the 50 to 60 bucks to buy a copy of the SQL Server Developer's Edition....

I agree with Jacob... well, except for combining everything into a single table and using views. Instead, look into the advantages of using a "partitioned table" and views. ...

jacob sebastian (1/24/2009)

---

Swirl80 (1/24/2009)

---

thanks for the reply. If that is the case then why is there the "Sparse" column feature in 2008? If NULL takes up not space at all...

ALZDBA (1/24/2009)

---

also keep in mind temp tables (@ / # / ## ) are hosted in tempdb. tempdb is used at (sqlserver) instance level, for more than only storing temp...

Heh... It's easy... be good to good people and then ask. 🙂

To make a longer...

gisles (1/24/2009)

---

I was thinking about option 2 - create another database - but have never done that and do not know how to setup the views to be seen in...