I also found it handy to write a CLR procedure to a SQL Broker Queue process.  The CLR procedure formatted an XML document based on parameters passed in message body,...

Even that type of table should have PK, just not necessarily a clustered key.

The only two examples I have ever seen is temporary working tables for bulk import (where you...

What a cheesy cheapskate you are!  Open your wallet (that's the dust-covered lump you sit on.  No, the other lump.).  Pull out a credit card and do what normal hard-working...

Usually faced with less than ideal server purchases, I have tended to got Raid1 instead of Raid5.  Even if I only have 4 drives, I will setup 2- Raid1 and...

What do you want the query to do?  Are you looking to get rid of duplicates?  Or just find duplicates?  Or list out everything except for duplicates?

GREAT Idea, Camilo.   I had forgotten about that resource.

Here's the link for 101 Samples for Visual Basic 2005

Hope this helps

Regan;

I agree with you.  I believe, given limited resources, it is better to isolate 1 tempdb on its own drives rather than have multiple tempdbs sharing spindles with data files.

Also,...

Formatting in the spreadsheet does not matter; that is only for display purposes. 

PW is correct, the Excel ODBC driver looks at the first 8 rows to guess at each...

Go ahead and store the picture in the database;  define the column as varbinary(max).  In your VB.Net application, using an ADO.Net dataset to query the table. 

You don't say if...

Your sample code is good. But it should be pointed out that once you have the file data in your Stream object (binObj), there are many options besides just writing...

Another pro: File storage in the database often takes less disk space, especially if files are small and disk size is large.  Since a disk cluster can only hold one...

I may be oversimplyfying the problem, but would it not make sense that, if time zone...

You need to save the error value.  As soon as another statement executes, the @@error value is reset (to the error code .  Try this (changed code in red):