SQL Server Education (by the geeks, for the geeks)
Hi Friends, Here I am going to explain a problem which is asked by one of my friend. Problem: Let’s run the below query: USE master go create database PRINCE go …
SQL Server Fragmentation for the table having less than 24 data pages Read MoreThis is the most common question I come across from some of the inexperienced DBAs in SQL Server or experienced Oracle DBAs who are administering SQL Server under the assumption that …
SQL Server: Unable to shrink the tlog file? Read MoreIndex Fill Factor FILLFACTOR, The FILLFACTOR option allows you to allocate a percentage (0 to 100) of free space on the leaf-level index pages to reduce page splitting. This option is …
SQL Server Index Fill Factor Read More