I most often see bad drivers reported as the issues on this site. HBAs are complicated and their drivers (out of date, mismatched firmware, something like that) seem to be...

There are some process tools at sysinternals as well that can help you dig down into more detail on which processes if you want to go that far.

I'd tend to...

One more thing, don't delete an old backup (or overwrite it) without having a new backup. I've seen people do this:

- delete old backup

- run new backup

Which one day will...

I'm older school, but I'd go with

create proc

insert b (colA, colb, colc)

select otherColA, otherColb, otherColC

from a

return

Note that your restore scenarios should look at how often data changes. If you change data often, and can't afford to recreate those changes, you need to back up often...

Normalization has a lot of value, and is used daily by (I hope) most people working with databases. To what extent you normalize might be debatable, but you ought to...

I had to look around and check as well. They keep changing these things!

In 2005, online rebuilds are enterprise only;

http://msdn.microsoft.com/en-us/library/cc966402.aspx

I agree with Jeff. You haven't provided a reason why to use functions and not stored procedures. From the calling program they look the same.

The number of columns returned has...

I'm not sure there is a way. My guess, or at least my hope, is that the installer uses %systemroot% for things, so if you've installed on d:, then it...

It's a good list, though like others, I think deletion is hard one.

I'm for renaming the objects for 13 months, give time for an end of year process to...

Ralf,

I'm curious, what's the alternative? If people don't know how to configure backups, if they haven't had experience, is not the MPW a good place to start? Don't they have...

I'm not sure that's true, Blandry. There are plenty of day-in-and-day-out systems that need building, plenty of grinding job. Which things we produce in the world don't need that? That...

It is on our list of things, but I'm not sure where. We have a big list and limited resources for development, so I'm not sure when this will be...

I was speaking of SQL Server patches, but Windows ones would count as well. Typically there is someone else that handles patching Windows in most companies I've seen, even small...