I seem to recall reading on this forum that automatic cleanup of old backups is not part of standard 2005 maintenance plans and requires separate jobs. If so, then 3...

If the point of the question, from a SQL interview perspective, is how do you think, then why not ask for a wiring diagram?

After all, you would not begin...

This is going to be a REALLY long interview if you wait for one of the bulbs to burn out, given that it could have 1200 or so hours of...

Thanks, Steve.

Do you know if that would require per-seat licensing for each of the remote units?

There are a couple of Clustered Index Scans mentioned but I don't see a table scan. You can turn the Clustered Index Scans into Seeks with some judicious references to...

Since you are performing searches on fields that are not indexed (like title or author), I'd venture that you are getting table scans on a number of the queries. And...

Given the observation that the first solution relies on the ordering of the data, the second solution is the better one as it is more complete.

But lets suppose that you...

Boy is THIS familiar. When Jet tries to get to the Access database it needs to know where the system database reference should be. That is typically a registry entry...

The VB code is rather involved so you'll want someone with some experience there to make the modifications. What the code actually does is use the DTS API to create...

You can export your package as VB code. Perhaps you can then add a 'wrapper' function to that code to create all the packages needed, possibly working from a table...

Regarding the article referenced in the editorial, there is an admonition to never accept a gift of more than 'nominal' value. I've never seen a definition of 'nominal' relative to...

Sorry all, but I can't stop myself from observing that part of this thread has been reduced to the level of MUCK-raking.

Now that I have that out of my system,...

If the GUID is the primary key and you are doing OLTP, it could have a large impact. Since GUIDs are random, rather than ordered in creation like an identity,...

This one is pretty minor, but since the thread is managing SQL2K with SQL2005 tools...

When you look at legacy maintenance plan history, SQL2005 cannot sort the history records by date....

Seems to me that 3 would be the right answer. Was there not a QOD earlier this week speaking about cleaning up old backup files and how that required a...