Welcome to EMC Consulting Blogs

July 2011 - Posts

• So you may have many different ways of Inserting Data - But which is the fastest?

  After getting 100,000 rows of Data using the 4 main flavours of Insert Statement I attempted to determine which method was the fastest.. To ensure that the results were not skewed by database re-sizing actions or cached data. I ran each query multiple Read More... Posted 06 July 2011 14:53 by Paul.McMillan | 3 Comments

• A Gotcha with the INSERT Statement Row Constructor and using a TALLY Table to Generate Test Data

  When I worked out there were at least 6 methods of Inserting data into a Table, I wanted to find out which was the fastest method... I will reveal the surprising fact in another posting. But I thought I would test the performance of each method with a Read More... Posted 06 July 2011 14:27 by Paul.McMillan | 0 Comments

• So now you can write an Insert Statement, 6 different ways - Why do you need to know this and why is MERGE the best?

  In my previous posting I identified 6 different ways to Insert Data into a Table in SQL Server. Now why do I need to know about these ?? Well in all probability you don't.. However, I work an awful lot of time with Business Intelligence systems and we Read More... Posted 06 July 2011 13:52 by Paul.McMillan | 1 Comments

• How many different ways can you write a SQL Insert Statement. 1, 2, 3.. 6?

  OK so you have been using Databases for a long time.. You know SQL Server, well I have been trying to work out how many ways there are to write a simple Insert SQL Statement. I think there could be around 6 different ways (4 main ways with 2 other flavours), Read More... Posted 06 July 2011 13:20 by Paul.McMillan | 1 Comments