Well, on questions concerning BLOBs I usually refer people to this source

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Not sure, if it is terribly useful for you. I don't know if there are books specifically...

Let me throw in something from the lighter side of life. Get a cup of coffee, sit back, relax and read this excerpt...

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

SET @oldtable = (select a.name from sysobjects b inner join sysobjects a on (a.id = b.parent_obj and b.name = 'PK_biomart' and b.xtype = 'PK'))

declare @stmt nvarchar(100)

set @stmt =...

Without knowing the exact requirements, I would say that the single db approach is preferable.

• RDBMS are designed and optimized for handling large amounts of data without losing too much...

One single line to type in your message? I only have this problem when using not IE, but Opera or Mozilla.

There are pros and cons for each approach. I do also store BLOBs in a db. Mostly ranging from 26kb up to 10MB. No problem this far, but the db...

Is there a specific reason for this?

Just asking, because if it is for some kind of security audit, you might want to take a look at C2 auditing in BOL,...

I only know he maintains his homepage http://www.khen.com , but I doubt if you'll find the sources there as this is the stuff he makes his living of. If you have...

When you say resume db, I guess you have some Word documents and now want to know if it is possible to store and query them in SQL Server, right?

If...

Layout #1 with the colours of #2. As for colours why not harmonize it with those from the forum template? Maybe you can make the whole thingt animated

This might be interesting for you

http://www.sqldts.com/?212

Have you ever looked at what EM does behind the scenes when removing the identity property from a column?

Here's an example:

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

SET ARITHABORT ON

SET...

Would you like it better when it was way more complicated?

The leaf level of a clustered index is the actual table data. So...

Hi Greg,

let me say sorry for the bad advice I posted. Last week I made several remarkable poor postings here

Hope quality will improve...