Consider these Index Best practices:

http://bestpractices-sql.blogspot.com/

Consider these best practices:

http://bestpractices-sql.blogspot.com/

Best Practices covers most of the stuff:

http://bestpractices-sql.blogspot.com/

One of the best practices blog I like is:

http://bestpractices-sql.blogspot.com/

Yes, you are right. It could lead to page jumps, but that is an obvious thing. When data page is full it has to allocate new data page for the...

Yes, you do have option to select what you want to install. Go for custom install and not typical. After that screen, installer will ask you to select components to...

Usually I save on File System where u can specify the Path, but again if u saved it in SQL Server, try opening it up from BIDS. Open new ssis...

Pat_B Certainly, u can go for SQL Export Wizard, but just make sure to save SSIS package created by Export Wizard. Export Wizard in one of its steps will ask...

Thank you so much Jeff and Young. I guess as a newbie its worth it for me to go for a TempTable, it works for me. And by the way...

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 is...

Jeff tons of thanks for this solution. It works perfect for my data. I would definately like to know logic behind this if you can throw some light on this...