GilaMonster (8/9/2016)

---

Yup, not a surprise there, You do need some index/stats maintenance....

GilaMonster (8/9/2016)

---

I wouldn't recommend running that during peak time. To be honest, I wouldn't recommend running that specific stored proc either, there are better ways to update stats (the explicit...

Thanks for the advice. Lord knows when exactly this is going to happen again but I'll definitely be checking out these options when it does.

All goes well we'll be...

Right, but if you had long running queries, it could cause blocking while other resources are waiting for access to the table. This in turn could have led to...

Unfortunately not. We were testing with a very basic query 'select * from table where date >= date1 and date <= date2' type query. Something we'll have to keep in...

I have to admit that this seems a little confusing. You need the 0 term rows counted but then the data must not be displayed to the end user?

It you...

How is your DSV defined? A table selection or a query?

Personally I'd use the query in the DSV to remove any records like those before it even reaches the dimension....

It wasn't so much monitoring as it was capture. I used WireShark on the server to capture packets during the time frame I expected the next failed logon to occur....

You were right. After doing a couple packet captures I managed to sort out where the attempt was coming from.

Management decided to outsource our exchange server administration and they...

Thanks for the idea. I hadn't thought about that vector.

I tried disabling the monitoring software (SQL SPY 6) and it did not have an effect the failures are still...

This is my personal opinion but what other people are being paid is really none of my business. What management decides people should be paid is between them and the...

IMHO accountability, ownership and foresight are the keys to an exceptional DBA than technical effectiveness.

It might just be my small corner of the world but I'm finding it less...