In general tlogs should not be with data due to a) the importance of tlog throughput and b) different nature of data access between data and log files

But all this...

1) average disk queue length is useless measure with almost all modern IO subsystems, especially SANS. avg disk sec/read and /write are the best measures to use.

2) Your us...

Suggestion 1: stop using LINQ 😀

Failing that, make a stored procedure that executes a properly written (and performing) query to do the call that is causing problems and call...

Paul White NZ (3/30/2010)

---

TheSQLGuru (3/30/2010)

---

In the past 3 years I have made more money consulting helping clients with performance problems due to UDFs than any single other issue - that...

In the past 3 years I have made more money consulting helping clients with performance...

There are some good things here, including some stuff on dynamic crosstabs: http://www.sommarskog.se/dynamic_sql.html

That question is like asking how big a human should be. Do you want to be a fullback for a professional US footbal team or a ballerina?? 😛

That, and the 2 follow-on blog posts, are the Bible...

1) stop using maintenance plans for doing maintenance. 🙂

2) Ola Hallengren has some WONDERFUL scripts for doing all the standard maintenance stuff (ola.hallengren.com)

3) as someone else mentioned you can...

44GB on a 48GB box is too high as well. Christian Bolton, in his book SQL Server 2008 Internals and Troubleshooting recommends this formula, which I agree with:

2GB for...

I find it hard to believe that your proposed solution - using an existing index to retrieve some subset of a table into a temporary table and then indexing that...

Oy vey - there goes Grant's ego!! 😀

In 95+% of the cases I have seen clients put indexes on temp tables said operation has been counter-productive to efficient operation of the query involved.

Do a proper indexing strategy...

Thanks Paul.

>>2. SQL Server will only update statistics if they are potentially useful to the optimizer, and found to be out of date. Statistics that are never useful will never be...