Blogs

March 2006 - Posts

• PASSMN - March User Group

  March 21, 2006 4:30 pm – 7:00 pm Register at www.passmn.org Custom Aggregations Itzik Ben-Gan, Mentor and Founder, Solid Quality Learning SQL Server provides you with several built-in aggregate functions like SUM, COUNT, MIN, MAX, etc., but sometimes Read More... Posted Wednesday, March 08, 2006 10:10 PM by Lara Rubbelke | 0 Comments

• SQL Server 2005 and Substring Searches

  SQL Server 2005 statistics are now built on substring character in text, ntext, char, varchar, and nvarchar columns. This greatly improves string searches using wildcard characters. SQL Server 2000 did not always generate the best plan or choose the right Read More... Posted Tuesday, March 07, 2006 6:56 PM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2005 Optimizer Enhancements

• Transitive Law and the SQL Server 2005 Optimizer

  As with all other SQL Server upgrades (and recent SQL Server 2000 service packs), significant work was made to the algorithms driving the query optimizer to improve how SQL Server decides to execute a SQL statement. For example, SQL Server 2000 did not Read More... Posted Monday, March 06, 2006 4:32 PM by Lara Rubbelke | 0 Comments Filed under: SQL Server 2005 Optimizer Enhancements

• When Should I Use SQL-Server CLR User Definied Types (UDT)?

  I happened across this blog when I was researching some information for my client. It was not only funny in its delivery of the message, but it does give one pause to consider real life implementations of this new feature. http://weblogs.asp.net/alex_papadimoulis/archive/2005/10/20/428014.aspx Read More... Posted Sunday, March 05, 2006 2:57 PM by Lara Rubbelke | 2 Comments Filed under: Programming