I need to do more research on the whole "parameter-sniffing" subject. For the most part our application generates sql using an object. I am able to view most of...

I need to do some testing on one of our dev boxes. But the question is, for a large, very frequently updated table, are you better off with statistics...

I agree about the need for an experienced tuning consultant. Now we're about to add another 64GB of memory bringing this system to 128.

So the takeaways from...

My systems team assures me that, via group policy, the sql service has the lock pages in memory permission. Yes it's only the procedure/plan cache that is an...

I see this morning that the plan cache went from being nearly empty for many hours and grew fairly rapidly up to a few GB starting at 12:45am. ...

Thanks Kevin. I believe we have the auto update to stats happening asynchronously ( that feature turned on ). When I say cache flush, I'm referring to those...

I'm convinced on the stats. I'm pretty sure the weekend maintenance is keeping the stats and indexes in reasonably good shape. Today I noticed that the plan...

I tried to get approval for...

So back to the question about whether stats are being updated on indexes that were just rebuilt. The stats proc in use runs the 2 statements below (slightly modified...

The update stats routine looks for stats needing updating, so I'm figuring if an index was rebuilt and the statistics related to it were updated, then the stats routine would...

We've found that without doing update stats with full scan the query optimizer "mis-estimates" the number of records in the index -- poor execution plans. I can't do...

Companies are always going to look for ways to save on salaries ( and any other cost ). In this economy the employee doesn't have a strong position unless...

Great, that makes our project to improve IO easier. Of course, foreign keys are one method of enforcing referential integrity, but are not indexes. ( I knew that...

We're upgrading but sticking with sql 2005. Server 2008 refers to the OS.

"We're planning an upgrade to our Sql 2005 Enterprise 32bit active / passive cluster to Server 2008...

Great info! We're planning an upgrade to our Sql 2005 Enterprise 32bit active / passive cluster to Server 2008 64bit with Sql 2005 Enterprise 64 bit. I don't...