Dynamic SQL allows for the creation of command(s) from a complex set of parameters/variables/conditions. When used properly it enables the centralization, extensibility and re-use of sp code.

The SQL Inject...

what is being argued about? The tools were created to fulfill certain needs and are there to be used. Some tools are be better suited to certain situations...

Have used NOLOCK for years for batch processing requirements to attempt to avoid the impact of on-going updates when these updates do not impact the underlying batch process(different columns in same...

my recollection was that SyBase added cursors in the early 90's to prevent it from being run out of business by Oracle.  In the mid-80s I remember listening to a Sybase...

>>I don't think you understood... the whole idea is to get rid >>of cursors and other RBAR methods in SQL Server.

My point is that the idea of "getting" rid of...

Have you tried setting the recovery model to simple, then shrinkig the log file?

In SQL Server I have found that using temp tables(non-memory) as a pre-processing staging area makes for more optimized code, reducing the burden on the optimizer(yes these do need help!) and overall...

I personally try to avoid clustered indexes except where the predominant search method on the table will be on the clustered index.  so in your example creating a clustered index...

IDENTITY columns as PK makes no sense as they don't really tell you anything.  SGID (system generated IDs), which is what an IDENTITY COLUMN is, usually are essential for properly ordering work in...