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.

>>Think "compound interest".

Think "read my post"! 😀

The default data file growth is ONE MEGABYTE, not TEN PERCENT (at least on all the servers I recall installing). ...

Blake, you should consider disabling hyperthreading (you mentioned 8 physical, 16 logical cores). HT often leads to worse performance not better in SQL Server environments. Test with your...