After migrating data from SQL Server 2000 to SQL Server 2008,when I am doing any a transaction in the table which find out more row on the database,that's gives me ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks -- in particular, what causes them -- is the key to preventing them and resolving ...

Expert Tips for Using SQL Server’s Extended Events and Notifications SQL Server offers plenty of details on problems that have already occurred. But what about potential issues lurking in the shadows?

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Update: Microsoft released SQL Server 2019 CU8 with a fix for the reliability issue that impacted SQL Server 2019 CU7. Microsoft pulled the Cumulative Update package 7 (CU7) for SQL Server 2019 ...