July 2007 - Posts

• Which is Faster -- (1) Copy and Local Bulk Insert or (2) Bulk Insert across Network?

  A while back, I was asked which of the following two bulk insert options would be faster: Copy/Bulk Insert : First copy the data file from server B to server A, and then bulk insert the data into a table on server A Bulk Insert across Network : Directly Read More... Posted Tuesday, July 24, 2007 12:29 AM by Linchi Shea | 5 Comments Filed under: Best Practices, Performance, Testing Attachment(s): BULK_tests.zip

• Disk Partition Alignment in the Published TPC Benchmarks

  In SQL Server related storage literature, it is almost univerally recommended that disk partitions be aligned either on the 32K or the 64K boundary. On this subject, I posted some test results a while back, regarding the performance impact of disk partition Read More... Posted Thursday, July 19, 2007 1:49 PM by Linchi Shea | 2 Comments Filed under: Best Practices, Performance, Storage

• Picked a Wrong Name, But Connected to the Right Instance

  I was doing some tests with a named SQL2000 instance called NYSQL\SQL2000. After I had run the tests for three hours, I came to realize, much to my dismay, that the server name used in all the connection strings in the tests was NYSQL instead of the intended Read More... Posted Saturday, July 14, 2007 11:41 PM by Linchi Shea | 2 Comments Filed under: SQL Server connectivity

• Performance Impact of Procedure Calls without Owner Qualification -- SQL Server 2000

  My reaction was "Wow!", when I first saw the test results. I had to triple check the results and repeat the tests several more times in random order to make sure that I didn't make a mistake and that the results weren't a fluke. Good news is that the Read More... Posted Thursday, July 05, 2007 1:25 AM by Linchi Shea | 10 Comments Filed under: Best Practices, Performance, Testing Attachment(s): sql2000.gif