I've had lots of trouble with this half-baked 'feature'.

A couple of dozen monitored instances ended up in an mdw db over 700GB data and 300-odd GB log.

Looking at the code...

I've interviewed people with high scores in MCTS/MCITP exams and was unimpressed with their actual knowledge (I hope we understand what the real issue is) 😉

PASS videos you can probably...

Vedran Kesegic (12/10/2012)

---

I just started to learn for MCM certificate. Videos are really inspiring, packed with information and insights, really refreshing.

4 videos watched, 1000 to go 🙂

I hope to be...

I would start by identifying the statements these users run and taking it from there.

Old SQL code may be relying on statements that can only run by sysadmins (results of...

Michael Valentine Jones (11/13/2012)

---

This code gives the start time for the OS, SQL Server, and SQL Server Agent, and gives the uptime days for the OS, SQL Server, and SQL...

I've already passed the knowledge exam

...now £1300 lighter:satisfied:

Andy,

You are right - there are two entries for the MCM - I hadn't scrolled down for the other one.:-D

Yep, London it will be.

Andy,

Thanks for the quick reply.

So is the Prometric site the wrong place to go then? 'Schedule an Exam' leads to the Knowledge exams only

....or is it the Microsoft MCM site...

Very nice, keep it coming!:-)

If the db load is mainly OLTP, then you may see gains by adding memory until you have more RAM than the size of the dbs - then you'd probably...

Yes, I do this with most of the linked server accounts.

After adding it to the DDL role, DENY whatever rights need to be denied.

(In my case I have a script...

First of all I'd ensure all service packs and cumulative updates have been applied to your Mgt Studio.

I've come across weird bugs that were resolved in CUs

Thanks for sharing your observation.

Now we know that 'near-enough' may be a long way from 'identical' when it comes to datatypes:-)

Gail,

exactly, I was just wondering if anyone has come across a script that can query the DMVs for filtered index propositions.

Long shot, I know...:ermm:

Rudy,

The code below returns the names of SQLService and SQLAgent accounts.

Works on 2000, 2005 and 2008 as far as I can tell:

DECLARE @NamedInstance bit

IF CAST(SERVERPROPERTY('ServerName') AS varchar) LIKE '%\%' SET...