A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

When I worked for Sybase, much of the advertising we published was based on the TPC performance benchmark figures of Sybase SQL Server compared to the competition ...

As data continues to explode, DBAs must constantly stay a step ahead by finding new ways to improve database efficiency and performance. Managing data in today’s complex IT environment requires ...

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

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, ...

During the last few weeks, two events important to the SQL Server community have transpired. First, Microsoft announced SQL Server 2000 pricing. Second, the company withdrew its record-breaking TPC-C ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...