I've been using plan guides to force OPTION(recompile) on some long-running select statements and it works but your sql statement and the parameters have to match exactly.   Because development...

I"ll have to look at the hash you mentioned.   Since I've implemented filtered statistics on our largest clients and busiest tables, when I run this with a client specified...

Thanks!!

Here is the index.  I need a QA environment to test, but I would definitely like to test disabling the index and then verify that none of the data for...

Much of the data isn't static.... the following is from an email I sent out to our team this morning on a search that uses this partitioned index

This...

Thanks for the link.  I'll dig into it ( scanned it last week ).

I understood about every table having at least one partition -- but it is odd that management...

The partition scheme was put in place by development ( pre-DBA ) many years ago and only covers 3 of our original customers, one of which is no longer a...

Great ideas.  Thanks to all.  For the time being what I've done is asked our Security manager to email these folks, and their managers, expressing his wishes that things like...

They're looking at Ncache, but we needed something to stop the big money clients from complaining.  SSDs will be testing in a prod-like QA environment first.   These will be...

Hi Kevin. Yes I get around and have received several very helpful responses from you, Grant F and Aaron B.  🙂

Well they did just add option(recompile) to one...

Great article series. We're now looking into an upgrade to sql 2016 in order to take advantage of column store indexes and in-memory-oltp. Currently we have one main...

I do reorganize the full text index every night.

ALTER FULLTEXT CATALOG [SummaryTableSearchFullNames] REORGANIZE

I run these frequently

EXEC sp_whoisactive @find_block_leaders = 1, --@get_additional_info = 1,--@format_output = 2,

...

I'm the guy waiting for development to figure out how to add option(recompile) to some of the ORM-generated queries 🙂 I have been creating some...

Some of that I can answer. The sql server has been up since December 8th, 2016.

This morning the query showing the most buffer latch wait is pasted in...

As far as I can see the changing alias names are defeating the plan guide. Not to mention creating single-use plans.