Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
CTP, SQL Download
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your organization scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will…
Read More

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Constraint and Keys, SQL Index
About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…
Read More