One of my Developer asked how to handle the concurrency and locking on one application where ASP.NET is used, by default the SQL Server 2005 behavior that allows Pessimistic & Optimistic locking for concurrency. To avoid the access of records by multi-users
Read More...
In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you
Read More...