Thanks for the tips. Also, has anyone used Double take or similar third party software that basically replicates all changes made to a server to a standby one. It's not...

Is there any way to have maybe a clustering at the software or hardware level where you can have multiple copies of the same database and can somehow apply changes...

-- The Table1 has four fields 'Id' unique identifier, 'Body' varchar field with some text, 'XTime' date time field specifies

the time after which the record can be picked...

Thanks.

Is it true that you can only create Instead Of Triggers on Indexed Views?

Tried to use the debugger as explained in the site you've mentioned, got the following error:

Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1

[Microsoft][ODBC SQL Server Driver][SQL Server]Unable...

Thanks, I landed up changing the way we were querying so this is not an issue really, but we were not really trying to lock anything it's just that logically...

Just a clarification...

In the sql that I wrote I call the first column in both tab1 and tab2 as 'Id' instead of 'Id_no' and the second columns as 'name' instead...

Here's a quick N dirty solution. May be not that dirty really......

In the following code, tab1 is your first table with id's and peoples names and tab2 is the second...

Did without the 'readuncommited' still the same result. No locks on the permanent table.

Steve,

I tried creating a small perm table with a few records and then updated a temp table which joined with this perm table in the from part of my...

Here's the list of arguements that I get:

StmtText,StmtId,NodeId,Parent,PhysicalOp,LogicalOp,Argument,DefinedValues,EstimateRows,EstimateIO,EstimateCPU,AvgRowSize,TotalSubtreeCost, OutputList, Warnings Type, Parallel,

EstimateExecutions.

If I am looking to see how efficiently my query is performing, what all should I be looking at....

I said defragmentation instead of fragmentation. We would probably need to defrag the table with text fields on a regular basis?

I need to store files upto 6MB, there will be mostly inserts and reads and maybe some updates (very few though). I have the choice of either using the file...

Yes, the gain if any is expected on the client side. Will let you know what we find when our developers run benchmarks.