Pam Brisjar (10/16/2008)

---

This is a hack, plain and simple. If you really want to move the table, the best way is to create a "temp: table on the new...

I think several things were missing from the article:

1) You should cover the need to handle foreign keys to the PK

2) You should cover a best practice of dropping the...

ApexSQL, after some fits and starts, should have a public beta of their debugger product out within a month. I have been advising them on the product and have...

I have interacted with all of the products over the years, and I too am starting to lean towards the new SQL Sentry Performance Advisor. Those guys and gals...

Jeff Moden (10/14/2008)

---

TheSQLGuru (10/14/2008)

---

That site has a lot of really great stuff. Aaron Bertrand, IIRC.

And I too think this is a presentation layer item. Or perhaps a CLR...

That site has a lot of really great stuff. Aaron Bertrand, IIRC.

And I too think this is a presentation layer item. Or perhaps a CLR function??

It has been my experience that IN causes more problems with optimization than EXISTS does, so I recommend that mechanism.

Instead of trigger would be my choice as well.

Don't forget that the 'definition' of 'pretty big' varies depending on the current memory...

I have seen a number of my client's servers where the wmiprvse.exe process routinely exhibits excessive paging. If anyone can tell me why this may be occurring (or...

Thanks for the clarification!

1) Can anyone give me some justifications for the apparent agreement that table variables should be used for 100 rows??

2) A minor point on the OP: You...

1) yes, you can get parameter-sniffing type problems from sp_executesql.

2) I wonder if the use of GUIDs is enabling a problem here? Gosh I hate those things...

Eric Inman (10/5/2008)

---

If this is a money making site for your company, the decision makers saying that real time access to reporting on session data(???) outweighs users accessing the site...

Certainly from a storage perspective, although a GOOD SAN can be a tad pricey.