Why not just use f5 or alt-x?

In the comments section of

http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx

There is an explanation of how to resolve this. The cause is due to a stored proc and the date calculation.

nom de plum

This is a nice concept. It could be useful to help save money or help a DBA get an idea to create a health check of his/her own.

Thanks for...

Ok. Makes sense. Good luck.

Congrats

One gotcha with the script as is, one will not be able to export packages specified with the "server storage". Use the encrypt action to change the protection level....

ditto and done.

I would suggest getting to know how to read execution plans. Knowing how to read your execution plan can help you to understand index usage and indexes that may...

You're welcome

GilaMonster (1/28/2010)

---

Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm, it'll be...

TheSQLGuru (1/28/2010)

---

>>Do you have a suggestion on migrating to something else? Such as a sequential integer or something like that? What is more popular?

Deciding on an indexing strategy is...

Gail Shaw actually covered this very topic in a blog post. In my first reply in this thread I included the link to that Post. It is a...

mark.ross (1/28/2010)

---

Because the 'IN' clause, when run against a large number of rows could, potentially, return a large number of values to check against, whereas the 'EXISTS' clause should still...

sgambale (1/28/2010)

---

I considered auditing successful logins, then reading the error log, but I prefer the other options which I think are easier in accomplishing what I want.

Only failed logins are...