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
This is another popular question I receive. How to see text/content/code of Stored Procedure. System stored procedure that prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view. Syntax sp_helptext @objname = 'name' sp_helptext [ @objname = ] 'name' [ , […
Read MoreSQL SERVER – Disadvantages (Problems) of Triggers
One of my team member asked me should I use triggers or stored procedure. Both of them has its usage and needs. I just basically told him few issues with triggers. This is small note about our discussion. Disadvantages(Problems) of Triggers It is easy to view table relationships , constraints,…
Read MoreSQL SERVER – 2005 Retrieve Configuration of Server
Few days ago I was asked what is our SQL Server’s configuration. I provided way more information then they requested. Run following script and it will provide all the information about SQL Server . SQL Server provides in detailed information if Advanced Options are turned on. It is very clear…
Read More
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.Â
SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator
I come across very interesting documentation about Joins, while I was researching about article about EXCEPT yesterday. There are few interesting kind of join operations exists when execution plan is displayed in text format. Left Semi Join Showplan Operator The Left Semi Join operator returns each row from the first…
Read More
SQLAuthority News – Funny One Liners – Humor
Once in a while we should laugh and relax. Here are few of my favorite funny one liners which I often use in my presentations. Let us start-
Just read that 4,153,237 people got married last year, not to cause any trouble, but shouldn’t that be an even number?