Take a look at http://research.microsoft.com/apps/pubs/default.aspx?id=64525 (To Blob or not to Blob) from Microsoft research.

On the machines used for this study, the paper shows that images under 256K are always processed...

Different people learn in different ways. Some need to see the thing happening before they understand. Some need to read the details before they understand. This means...

Mingware

From the Scottish: To Ming - to be unsavory in any and all ways imaginable

Example: Corporate mingware - the stuff loaded on our machines by corporate IT that interferes with...

The default collation has changed from SQL Server 2000 to SQL Server 2005.

In SQL Server 2000, the default collation was a SQL Server specific collation. For SQL Server 2005...

Why are you planning to use IA64 instead of X64?

I think cloud services are here to stay, at least until the next big thing. The financial argument for cloud is so good there will be a lot of...

The data from your parameter can end up in an IN list in your stored proc.

I do not have an example I can show you today, but may be able...

eric, there is a big difference between having a database in two files and having it in two file groups. Please see BOL if you do not understand...

If you are calling a stored proc in a dataset, it is easy to pass a parameter list from a multivalue parameter by using a JOIN expression.

Lets assume you have...

This can be done easily by using the JOIN built in function in SSRS.

SSRS of any version can pull data from SQL Server DB of any version. 32-bit and 64-bit makes no difference.

You may have problems if you want to use data...

Mirroring can be a useful way to quickly get access to your operational data, but there is a gotcha if you are using replication.

The mirrored instance uses the same physical...

You will probably have to use SQL Server Authentication, and not Windows Authentication. This is because there is not a common Windows domain that both SQL Server and your...

Back in the old days of punch card data entry, it was standard practice for each set of data to be processed by two different people, and the data only...

Take a look at http://sqlcat.com/whitepapers/archive/2009/09/23/using-replication-for-high-availability-and-disaster-recovery.aspx

This is a customer study of using P2P replication to provide both high availability and DR. It might cover all you need.