With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

I am contributing to the effort of optimizing our SQL 2000 server where I work. The downside is--I'm a novice (but quickly learning) when it comes to SQL 2000 tuning. One of the areas that I want to ...

Microsoft released the first service pack for SQL Server 2016, featuring a consolidation and addition of advanced features across all versions of its flagship relational database management system ...

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

One highlight of this roll-up release is the addition of row-level security and dynamic data masking, which were only available in the Enterprise version, are now in Standard, Express, and other ...