CirquedeSQLeil (7/19/2010)

---

There is a 3rd party appliance that helps to simulate load balancing. It in essence creates a replication type of setup and keeps multiple databases in sync on...

1) what version of SQL 2005 are you on? did you fully patch it up before go-live?

2) did you update ALL statistics with FULL SCAN after the upgrade?

3) did...

1) Having done this type of work for over a decade now, I can tell you that it has been my experience that SAN admins RARELY listen to in-house DBAs,...

Roger L Reid (7/16/2010)

---

I'm going to respectfully offer different advice - what you are trying to do is logically and theoretically correct. It wasn't real practical in the past,...

I LOVE ORMs!! They create SOOO many business opportunities for me due to the bad stuff they (and the developers who use them) do with databases! 😎

I might have missed it, but did anyone mention that when upgrading from SQL 2000 to SQL 2008 you MUST update ALL statistics with a FULL SCAN?

Also did we get...

Thanks for the props Gail.

Yes, this is the type of work I do for a living (and have for...

I agree Gail - sure wish people would look at thread dates. More importantly I wish they would just post their question as a new post when it really...

1) you are updating a table without a where clause, meaning you are scanning/updating the ENTIRE table at once. clearly parallelism COULD be good for this. But you...

Grant Fritchey (7/12/2010)

---

If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in parameter...

on sqlblog.com Adam Machanic has an INCREDIBLE replacement for sp_who2 called sp_whoisactive. Get it, learn it, use it!!!

Cursors are appropriate for some classes of problems - and metadata operations can be one of them. Use the correct tool for the job.

I am with Jeff that you...

Brandie Tarvin (7/6/2010)

---

First of all, "she", not he. @=)

Secondly, I need random numbers that do not repeat. I'm not limited to a range, but I need to make sure they...

Jeff Moden (7/2/2010)

---

TheSQLGuru (7/2/2010)

---

Once again we are moving into the world where a professional would be worth his/her weight in gold - or at least silver (metals are SOOOO inflated...

Back to the original question, it could be fastest to build your clustered index with SORT_IN_TEMPDB option, assuming you have a sizeable tempdb on a fast IO system.