Different ways to get the internal database version for SQL Server...

In SQL Server, a page is 8K (8192 bytes) and what is the largest data size [when storing one or many rows] that can be stored in a page if you exclude LOB data?...

Hi Nupur, There seems to be an issue (unconfirmed yet) with the way fragmentation is calculated in tempdb on SQL Server 2005 and its reporting slightly higher number than in SQL Server 2008 R2. But that is unrelated to the actual question. Thanks for pa...

Robert, a SQL Server developer is surprised to see high index fragmentation on a table that has a clustered index. The table has only few thousand records and even after repeated attempts to rebuild the clustered index, the inde...