SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key
SQL SERVER – Change Default Fill Factor For Index
SQL Server has default value for fill factor is Zero (0). The fill factor is implemented only when the index is created; it is not maintained after the index is created as data is added, deleted, or updated in the table. When creating an index, you can specify a fill factor to leave extra gaps and reserve a percentage of free space on each leaf level page of the index to accommodate future expansion in the storage of the table’s data and reduce the potential for page splits. Let us learn about how to change default fill factor of index.
SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
SQL SERVER – Disadvantages (Problems) of Triggers
SQL SERVER – 2005 Retrieve Configuration of Server
SQL SERVER – NorthWind Database or AdventureWorks Database – Samples Databases
SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.