http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops6.asp

I have developed applications (and currently developing applications) that put large amounts of large blobs on a MS SQL Server database and I have not encountered any problems.

I have no...

hanslindgren: i meant databases in general and not datawarehouses. the concept of databases was developed earlier than datawarehouses. its true that different departments might have slightly different needs and uses...

now this is weird when you realize that databases were invented precisely for the purpose of integrating the data of an organization, eliminate the "islands of data" problem and providing...

now this is weird when you realize that databases were invented precisely for the purpose of integrating the data of an organization, eliminate the "islands of data" problem and providing...

For those interested in writing extended stored procedures the easy way, see: http://www.bramc.ru/soft/xproc.html. I havent used it personally but it allows the creation of extended stored procedures in...

Just use a view. That way you can put any column in the SELECT clause into the WHERE clause of the view

i would go for simplicity first unless there is some evidence it will not fit the requirements. keep it all in one db.

1) delete the data you dont need....

Multiple GETDATE()s in one SQL statement will evaluate to a single value. Thus,

UPDATE Table

SET Column = GETDATE()

will set the Column column to the same date value regardless of how...

The issue mentioned by shew01 might be true. However, it should be relatively simple as a physical level optimization to partition the relevant table into two tables, one containing the...

the decision to use the filesystem directly or use BLOBs is always a trade-off. the filesystem excels at one thing: storing files. if the system you will be developing uses...

i use a clipart management app that i developed own my own that stores files and images as BLOBs in a MS SQL Server db. for simple retrieval you cant...

the best way to determine the future size of your database is to compute it!

the formula for computing the database size for sql server 7 (i guess it applies to...

do you have the appropriate indexes defined? an index on Policy(AccountID) seems appropriate here.

There so many things to comment on about this article that I almost don't know where to start!

Suffice to say that the fact that the kind of solution proposed is...