mzak (7/21/2010)

---

Kevin Rathgeber (7/21/2010)

---

mzak (7/21/2010)

---

Kevin Rathgeber (7/21/2010)

---

I have a comment regarding your T-SQL

In trying to keep all things equal, Shouldn't you declare a variable at the beginning of your function...

looks like intraquery parallelism blocking. Usually caused by either bad plans from parameter sniffing or suboptimal indexing (or both). You should do an indexing analysis session. Also...

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