December 2009 - Posts

• Problem with SQL Server service restart

  The few last days, our hosting company have updated their VMware environment a number of times and thus have forced equal number of restarts for our database servers. The problem with this is that one of the databases, Yoda, needed 1.5-2.0 hours to start Read More... Posted Wednesday, December 09, 2009 1:06 PM by Peso | 2 Comments Filed under: Data corruption, SQL Server 2008

• T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Without Using SQLCLR

  In response to Adam's new series of T-SQL Tuesday, I wanted to write that there are faster ways to get the data in a set-based manner without resorting to SQLCLR. http://sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspx Read More... Posted Wednesday, December 09, 2009 12:20 AM by Peso | 15 Comments Filed under: Algorithm, Optimization, SQL Server 2008, T-SQL Tuesday