Siva,

It's not as easy as that.  The number of concurrent users on the SQL Server is not that important.  What is important is what those users are going to be...

I'd stick with cursors.  That's what they're designed for so I don't see the need to re-invent the wheel.  Plus it's likely to be more efficient as others have pointed...

1) Set up the database maintenance plan as normal. 

2) configure the maintenace plan to delete files older than x days (or hours)

3) Once the maintenance plan is set up, find...

This isn't advisable.

If you want to put backup files in a location other than the local server I would always suggest backing it up locally and then copying it.

If your...

Try changing the maintenance plan so that it deletes files older than 48 hours, instead of 2 days.  I can vaguely remember coming across problems when using the "days" option...

In this kind of scenario I would opt for log shipping over replication.  Assuming you can cover the cost of Enterprise Edition.

There's less of an administrative burden with log shipping. ...

Don't know about a "free" tool but check out Lumigent Log Explorer.  You might be able to get a trial version.

I would use a sub-query:

SELECT DISTINCT tot.po_tble_cod

  FROM po_tabelatotal tot (NOLOCK),

       po_tabelaitem itm (NOLOCK),

       po_parametro par (NOLOCK)

 WHERE tot.po_tblt_cod = itm.po_tblt_cod

   AND itm.po_para_cod = par.po_para_cod

   AND par.po_bloc_cod = 99

AND ...

When you say that you restore the database to your test machine.... where does that backup file originate from?  The same test machine?

Anyway, sounds like you might be getting orphaned...

You can definately take log backups whilst running dbcc indexdefrag.

However, dbreindex and checkdb both place schema locks on tables so you won't be able to run a log backup.  Well, you...

I would review using the update lock and make sure that it really does work.  I did a test in Northwind and tried to update multiple rows in Customers (using...

ignore my last post, figured it out

I don't understand how you can tell what is part of a continuous claim....

For example, what tells you that the claims made on 3/1/2005, 3/11/2005 and the 3/21/2005 are all...

I suspect that what might be happening is this:

When you run the update statement SQL Server will take out an exclusive lock on the rows that you are updating.  However,...

Almost forgot:

You could always set ANSI_NULLS OFF and then just run the one query as follows:

SET ANSI_NULLS OFF

SELECT * FROM  table1

 WHERE col=@parm

SET ANSI_NULLS ON

With ANSI_NULLS OFF, the equals sign...