Just to clarify, the business rules that define what the data is should be in the database.  The business rules that define how the data is used for a specific purpose...

When you get right down to it, SANs are not much different than any other I/O system.  Performance is a relatively simple matter of the speed of the disks and...

There is no one answer to this question.  Any properly designed database incorporates a great deal of business rules in it.  However, there will always be some business logic that...

I used dbcc freeproccache and dropcleanbuffers between tests.  However, subsequent testing shows that they are actually much closer in speed than that initial test.  The while loop is still about...

I guess proof is what you need...

create

table curstest (col1 int...

That's what I would do if you can afford the down time.

We use Embarcadero Change Manager with good success.  I was pretty impressed with dbghost too.

The tables have to be dropped in the right order.  Without rewriting your script for you, I did notice that you have to drop the Dependents table before you can...

I have seen this approach many times and I must say that I hate it.  Avoiding cursors is a good thing, but this approach should be called "roll your own cursor."  It...

David: I would hope that I haven't built quite that bad of a reputation for apoplexia! 

I admit that I do tend to respond to certain topics rather forcefully, but...

With the introduction of 2005 Standard Edition is no longer limited in the amount of RAM it can use

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

The page I referenced above seems to be removed, but if...

They have actually done a really good job with Books Online from my experience, and there are certainly a bunch of specific recommendations there, but it's not in an easily...

It's not exactly a "best practices" guide but here is the link to the msdn operations guide (as it currently exists) for SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx

A good modeling tool such as ER Studio can help.  It can reverse engineer the existing tables and infer relationships where the column names and data types are the same. ...

Yes, hardware virtualization has proven itself for many years in the mainframe environment and more recently in the *nix world, but the hardware was specifically built for it.  CPU manufacturers...