Could you post the DDL of your table and the procedure you are executing?

How do you mean the row gets deleted? An UPDATE can never delete a row entirely. Sometimes an update is split into a delete/insert pair of operations, but that is...

No idea what caused this, but I would do a memory check and possibly look at other hardware items.

But that is exactly what the view solves.

You have this now: SELECT * FROM BIGTABLE

Now you create SMALLTABLE1 and SMALLTABLE2, move all the rows there and then drop BIGTABLE. Finally...

Yes, SQL Server Management Studio has integrated support for source control. In fact it also has projects and solutions where you tie scripts, then source control the entire solution. Just...

There is no alternative, at least not until SQL Server 2005. But why will this cause code changes? The beauty of it is that SQL Server automatically handles reads and...

No, you need to have a trace running and look it up there to see it. You can use Profiler for this.

If you are specifying internal physical properties for retrieving rows you are not really querying the database, you are telling it what to do. In fact, I would even say...

You can separate the BIG_TABLE into SMALL_TABLE1, SMALL_TABLE2 etc. Then create a view called BIG_TABLE that does the UNION ALL of the smaller tables. Your application won't notice any difference.

Take a look at Professional SQL Server 2000 DTS

And it is co-authored by SQL Server Central co-founder, Brian Knight.

The procedures cannot be owned by his login. Procedures are owned by users. His login might however be mapped to a specific user which owns the procedures. That user might...

You should do this on the client side as this is a presentation issue.

Both the Jet version and the proprietary SQL Server syntax is pretty ugly in my view.

Do you have multiple files in the filegroup where the table/index is stored? If so then the output value from DBCC SHOWCONTIG for external fragmentation should not be paid too...

You should never delete them directly from the system tables. You can however create a script that collects the info from INFORMATION_SCHEMA-views (or system tables) and then dynamically removes them...