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?
SQLAuthority News – T-Shirts in Action
Thank you All for great response to SQLAuthority T-Shirts. I have ran out of all of them. Please put your request here. I will go over all of them soon and see what I can do. They are made from high quality fiber and very comfortable. Reference : Pinal Dave…
Read More
SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN
The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there are no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any distinct values from the query to the left of the EXCEPT operand that do not also return from the right query.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – T-Shirt
My friend sent me this in an email two days ago as he wanted me to have SQLAuthority T-Shirt with this image. I found it funny, I am not sure if I will have this on SQLAuthority T-Shirts. Please pay attention to the options available to select. I spend more than 3 hours to find the original source as my friend did not remember the source. Let’s see some SQL Humor here: