Another issue to consider in the bit vs tiny int debate is that tinyint fields can be indexed, bits cannot.

Including a tinyint in an index can give more of a...

Don't kid yourself.... moral victory, you still FAILED.

As stated above the correct answer is syntax error for the reasons already stated

DONT do it !! It's bad database design and will produce a vfery slow database.

It's far more efficient to store the binary file in a subdirectory and store the path\filename...

AT ALL COSTS !!!! do not use TEXT !!!

1. It is extremely slow for large databases.

2. The text is stored seperately and referenced by a pointerle.

3. It prevents point...

picking up on the previous comment. using comparisons like <> can cause table scans even when a suitable index is available.

If table is a big table, I'd also look...

picking up on the previous comment. using comparisons like <> can cause table scans even when a suitable index is available.

If table is a big table, I'd also look...

1. You need to change your join types. Microsoft recomend that you use the explicit JOIN command, in fact Microsoft declare that the join syntax you are using returns inconsistant...

To add to this... DBCC ShrinkDB does not recover space no longer used by text and image data if they are stored in the same filegroup as the data.

The only...