It is a common argument which I hear among developers these days, regarding SQL locks. Some say that the ‘locks are held for the duration...

  Sometimes this is a common error message that we encounter, when we try to restore a SQL database, which is being used by other users. ...

  What is an Unsafe Assembly? Assemblies which are built using normal computational functions are considered as safe assemblies. But when ...

Why use CLR? Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different progra...

A view can be defined as a virtual table or a stored query and the data accessible through a view is not stored in the database as a distinc...

There can be a situation where you have to use a cursor, even though the experts say not to use cursors or to avoid them as much as possible...

There are times that we get requirements such as populating and duplicate SQL rows, based on a value, on another column. E.g.: In an invento...