msdb is basically the database for SQLAgent. It has history, information about SSIS package and jobs. It may or may not contain SSIS packages (they can run from the filesystem),...

Not sure about moving the diagrams. You should be able to see them as sa without issue. Maybe check the rights inside the db to see if something is weird.

You...

SSMS also shows this.

You should not need to do this after a full backup. You either have a misconception about what is happening or are not administering the system properly.

The log does not...

Is the maintenance plan set up in SSMS? Is the logging checked? It should write a text file. not sure about spotlight.

What else is checked in the maintenance plan?...

No one wants their boss to do something?

Peter, no first class travel? Extra night on the road?

Will, no dedicated time to experiment with mouse speeds/sensitivity?

Matt, no "road breaks" to...

Here's the thing. Grant has good advice, but I'd calculate the row sizes, guess at how many rows will get inserted in a year, then double that, add 50%...

temp tables aren't necessarily better. Even local (to the connection) ones. The reason is tempdb can be a source of contention and you are guaranteeing disk access. If you send...

Include adds data to the index so that a bookmark lookup is not needed (now a clustered index seek) to go back to the table for the data. Good for...

Never had much of a preference on mice, but let us know how it goes, Will.

Matt, what's an oodle? Is that a measure for 10TB 🙂

There should be no problems, although tinyint can store more values (2, 3, 4), so you possibly could have other data in there that your application doesn't deal with. So...

I pinged some people to see if there are any other solutions. I know I didn't renew our Lumigent maintenance at JD Edwards because we never used it. This is...

It does work, mostly for longer words. Like I type "SQLServerCentral" on the phone once and then it appears early in the list when I type "SQL"

The downside is that...

Yep, I think it is only 2000. That's what's on the site. It's also 32bit only.

Apparently there isn't much $$ in these products because people only want them when they...

Good article Jeff and it's nice to raise awareness about the issues here.