Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Leon Dudovich — Sun, 23 Aug 2009 12:53:33 GMT

Thanks for sharing. I just starting online.

Its really need. What do you think about www.site2you.com? Is that really possible to make a website pretty quick and is that good quality CMS does they using?

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Michelle Ufford — Fri, 31 Jul 2009 19:22:54 GMT

Great post, Ward! My primary server will be upgraded to 2008 in the next couple of months, and MERGE is one of the features I'm most looking forward to (after filtered indexes, of course!).

Also, I've just recently started using indexed views myself and was wondering if you could expound on the improved performance you received in the 1NF table vs the indexed view.

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Lara Rubbelke — Thu, 30 Jul 2009 06:16:10 GMT

Hi Ward. I believe indexed views were introduced in SQL 2000.

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Andrew Bauer — Tue, 28 Jul 2009 08:08:57 GMT

Can you please elaborate (perhaps in another blog) on your "CTE with a MERGE and a TRY-CATCH block" code? I have done something similar in SQL 2005 before, and am curious how you approached it.

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Adam Machanic — Mon, 27 Jul 2009 18:22:53 GMT

Also, regarding the idea of creating a "driver table", based on just-inserted keys, did you consider Change Tracking? It might be interesting to work something up using the CHANGE_TRACKING_CONTEXT feature, where the parent process figures out the most recent change version, then generates a unique context and does its work. Then the child process can take the version and the context and figure out what work the parent process did based on the change data.

re: Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

Adam Machanic — Mon, 27 Jul 2009 18:17:52 GMT

Hi Ward,

Interesting post. Can you share some information on how big the data sets you used MERGE for were? In my attempts to use it to date I've found its performance to be less than ideal; between twice as slow and 100x as slow as my pre-MERGE methodology (using a temp table).

BTW, indexed views were introduced in SQL Server 2000 :-)