tag:blogger.com,1999:blog-21211117944669791852011-11-27T18:02:39.965-06:00M. W. Albertnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2121111794466979185.post-27941498380114512002010-02-18T19:00:00.000-06:002010-02-18T19:00:02.191-06:002010-02-18T19:00:02.191-06:00M. W. Albertnoreply@blogger.com0I've become a big fan of Ola Hallengren's SQL Server 2005 and 2008 database maintenance solution since I discovered it a few months ago. As anyone that has delved very far into the Reorganize and Rebuild Indexes tasks in SQL 2005/2008 maintenance plans knows, they couldn't exactly be described as 'sophisticated'. The tasks do not take the existing fragmentation level in the indexes into account - <p><a href="http://feedads.g.doubleclick.net/~a/bLrM1HdStKVqyXnAKsOdGoRGk6g/0/da"><img src="http://feedads.g.doubleclick.net/~a/bLrM1HdStKVqyXnAKsOdGoRGk6g/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/bLrM1HdStKVqyXnAKsOdGoRGk6g/1/da"><img src="http://feedads.g.doubleclick.net/~a/bLrM1HdStKVqyXnAKsOdGoRGk6g/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/YetAnotherSqlServerBlog/~4/R-oPb8asqJo" height="1" width="1"/>http://yassb.blogspot.com/2010/02/sql-server-maintenance-solution.htmltag:blogger.com,1999:blog-2121111794466979185.post-46584698261116847852010-02-16T19:00:00.000-06:002010-02-16T19:00:00.561-06:002010-02-16T19:00:00.561-06:00M. W. Albertnoreply@blogger.com0I ran into an interesting problem the other day with a SQL Server on a virtual machine that was a clone of another machine. My co-workers had received a request for another virtual machine that had the same data on it as an older, test server for use in production. So, rather than build a new machine from scratch and backup/restore the test data to it, they simply cloned the virtual machine and <p><a href="http://feedads.g.doubleclick.net/~a/3x1henPRNiuzWtU9w9FialXmBMg/0/da"><img src="http://feedads.g.doubleclick.net/~a/3x1henPRNiuzWtU9w9FialXmBMg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/3x1henPRNiuzWtU9w9FialXmBMg/1/da"><img src="http://feedads.g.doubleclick.net/~a/3x1henPRNiuzWtU9w9FialXmBMg/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/YetAnotherSqlServerBlog/~4/Rs9t-avF4VI" height="1" width="1"/>http://yassb.blogspot.com/2010/02/cloned-server-problem.html