Because you can also check that SSAS and SQL are not on the same node, or two instances of SSAS, etc...

A SQL SP or...

It's falls under MSDN, which allows us unlimited editions of ent/standard on non-production servers.

I use for a dev server Win7/SQL2012 Enterprise and Win7/SQL2008R2 with no problems

I have a script that I run based on the sysprocesses table that kill all SPID's in a given database.

This query will get you the information from the DMV (Dynamic Management View)

select db_name(database_id) as [Database Name], count(*) * 8/1024.0 as [Cached Size (MB)]

from sys.dm_os_buffer_descriptors

where database_id > 4 -- system...

Set MAXDOP to the total number of cores you have (don't count hyperthreading). If you have 24 cores (4 CPU/Sockets times 6 cores), then set MAXDOP to 24.

Kris-155042 (11/6/2013)

---

Hi,

I have a 2008 R2 64b server with 4 instances on it. One is using ALL the RAM and the other instances are using less than 100Mb and the...

Sreejith! (8/19/2013)

---

Thanks All

But the files(txt,mdf,doc,excel,zip) in the 'test' directory doesn't have proper time stamp, which help us to determine whether these files has been placed in the folder for more...

Alan.B (8/8/2013)

---

GregoryF (8/8/2013)

---

I use forfiles (google it for the reference on how to use) call from xp_cmdshell. It alows be to delete files older than n days, and you...

I use forfiles (google it for the reference on how to use) call from xp_cmdshell. It alows be to delete files older than n days, and you can pass...

Why not just script out all the jobs? It's easier than restoring msdb...

Are you planning on just restoring msdb (simple) or msdb and master (so complicated I have not done it in 10 years)?

Whilst I did not have any set datefirst statements in my SP, adding it got the SP to work.

Funny thing, the SP had been working for six weeks on 25+...

Nice new feature, too bad it does not work on 2008/R2 servers. But as we migrate more servers to 2012 I sure we'll use it more.