SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL

Update: For SQL Server 2008 there is even better method of Row Construction, please read it here : SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

This is very interesting question I have received from new developer. How can I insert multiple values in table using only one insert? Now this is interesting question. When there are multiple records are to be inserted in the table following is the common way using T-SQL.

Read More

SQLAuthority News – Author Visit – Meeting with Readers – Top Three Features of SQL SERVER 2005

Lots of travelers are visiting to Las Vegas due to long weekend of Memorial Day. I was invited to dinner meeting by two of my readers. It was wonderful discussion with them. We primarily discussed about scalability and upgrading issues about SQL Server. I received feedback about SQLAuthority.com site. There…
Read More

SQL SERVER – MS TechNet : Storage Top 10 Best Practices

This one of the very interesting article I read regarding SQL Server 2005 Storage. Please refer original article at MS TechNet here. Understand the IO characteristics of SQL Server and the specific IO requirements / characteristics of your application. More / faster spindles are better for performance. Try not to…
Read More