I create the table using create table #mytable(..). Then u update some rows in it and then return the results using select f1,f2, from #mytable

thanks for the responses. We have t-rep and log shipping as well. One of the DBAs tells me that running dbcc reindex will cause a delete and insert of rows...

Folks,

Thanks for your response. We turned off unicode in JDBC and the search string is "company_name like 'abc%' " . It works great now. Here is the link for those...

Thanks for your reply. I have 4 gb RAM and the /3Gb switch in the boot.ini. However SQL does not use more than 1.6 Gb  for most part. Should i...

Not just scalability, it simply does not have some enterprise features. Oracle has Dataguard ( sql's log shipping) which allows automated failover, handles spatial datatypes and load balancing. When companies...

Allen:

You are dead right. I see the message on in my errorlog. Do i have to call Microsoft ? We dont have paid support. Is there a download fix somewhere...

What version/edition of SQL are u using

forgot to mention that the 122 Tb was on Analysis Services

Scalability is related to the 64-bit processors that the UNIX boxes that host Oracle have. Given similare hardware, 64 bit itanium processors , sql will scale. London Stock Exchange uses...

Merge is best suited for a disconnected environment. If you use transactional replication, u have to use immediate updating subscriber if u want those changes to be reflected at the...

If you change the stored proc, u have to regen the snapshot. Otherwise the subscriber will not have the same proc

You can have identities with the "not for replication" clause turned on. In case of a disaster , the subscriber becomes you primary site. http://www.microsoft.com/sql has documents decribing...

Yes Andy. Normally i would use stored procs and replicate the stored proc.( keep the transaction short and sweet)

T-1 speeds should be ok.

the option exists only for push subscription