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...

I think what you want is a way of paging, but it's confusing because sometimes you're saying values and sometimes rows.

You also need to decide if there is some order,...

I haven't been able to figure this one out. What's worse is that SPs seem to want to unpack to the c: drive as well.

The MS Press book I got (blue) was pre-release, and had lots of errors.

Honestly I think most of these books cover 80-90% the same material, and they'll work for you....

How is Agent configured, and how is the owner configured? PS has it right in that this is a permissions issue.

Like Lynn, I'd question that requirement. I'm not sure I can think of a good reason someone would want this done.

Get some reasoning and perhaps we have other advice or...