Soon^TM

Offhand, no idea.

You should be able to dig up some info on plan shells from google.

The ad-hoc ones just shells, not actual plans. They're there so that SQL can link the original query and the parameterisd

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/68d06d07-e662-4359-b55f-1ba646e3e6b1/forced-parameterization-why-still-multiple-plans-in-cache

Koen Verbeeck (8/14/2014)

---

- add a column with only the value 1 in it

- create a running total on this column.

You can use the quirky update method laid out by Jeff...

You still haven't explained why the obvious solution, ROW_NUMBER, isn't allowed.

If I needed row numbers in any version of SQL above 2008, I'd use ROW_NUMBER(). If I needed row numbers...

CLR - Common Language Runtime. .net code in SQL Server. You can create procedures and functions which are written in .Net.

Koen's suggestion wasn't serious (I nope) and besides would violate...

You could create a temp table with an identity column, insert the data and then query it back.

Why the restriction against the obvious solution (row number)?

Nope, missing indexes DMV is too dumb to consider filtered indexes (and it's index recommendations need to be very carefully evaluated anyway, but then so do DTA's)

Filtered indexes are something...

Good thing I don't claim to be an expert then, isn't it.

In general, high level, when you have a fixed predicate that is frequently applied to a table along with other predicates. So if you frequently have <someColumn> IS NULL in...

No they don't, and they never have. The only thing that COPY_ONLY does...

TomThomson (8/13/2014)

---

I wish I could give you some of ours. I'm beginning...

Anyone up for giving Me "I require some help with indexes" some help?

Edit: http://www.sqlservercentral.com/Forums/Topic1602739-391-1.aspx

Don't suppose you're on SQL 2012? The TRY_PARSE added there is sooooo handy for this kind of thing.

"Required"?

The only people who can "require" me to do some work are my manager and...