are you creating the temp table(s) itself within an open transaction ? (avoid if possibible)

ricardo_chicas (9/13/2010)

---

Actually my concern is that we have several dbs and ost of users, so I really need to be careful with the use of temp db, I like the...

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