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...

Welcome to the club :hehe:

Is this a level 90 database ?

- We create the backup file on the production server.

- Copy that file to safezone. (next step of the backup job)

This is scheduled at 19:30

On some of our dev...