I guess you mean you want no2 and no3 ! (both startin with john)

btw what's the distribution of your value '???'. In what kind of percentage does it occur ?

If...

You may also want to have a look at the xml plan for your query.

( SET SHOWPLAN_XML ON)

Search for implicit conversions as they may cause an index not to be...

just my 2ct:

Bit is context driven !

If your column name doesn't declare it by nature, you should document it well !

e.g. a column named "AreLightsOn" would by nature have a...

GilaMonster (9/11/2010)

Looks like he...

you have been playing with maxdop, setting the max parallelism for a query, not restricting the max proc for the instance.

What happens if you restrict the numbers of proc for...

Indeed, setting max server memory is a must on 64-bit systems !

If only I would have noted the source ref in my script :blush:

--/* These settings are for x64, on...

There has be a similar Q last week.

They pointed to a bug in W2008R2 and proposed the following hotfix a the solution: Win2008R2_Win7_HotFix_KB2265716 http://support.microsoft.com/kb/2265716

Does this apply to your...

- Can you try out the trick Gail proposed ?

The trick is to execute the query whilest being connected to master db.

(off course you shouldn't use that in a...

I'll have to hand this over to the other SSC members because I have no experience with partitioned views.

I thought it was...

Shall I demistify the magic ?

No ... we'll talk it...

Or maybe even contact Allen White via LinkedIn.

Send him my regards 😀 and buy him a good beer :w00t:

Did you try SQLserver BooksOnline ?

another must is the white paper at http://technet.microsoft.com/en-us/library/dd578580%28SQL.100%29.aspx

If you design it well, it may.

That's why you should especially take care of your indexes to be alligned.

This is one of the reasons why you must first read about...

classic answer : It depends.

In some cases partitioning may be a great solution (ent edtn only)

The problem will always be : how does sqlserver detect "date range" to filter its...