Martin’s Blog Archive
- April 2013 (2)
- March 2013 (1)
- January 2013 (1)
- September 2012 (1)
- August 2012 (1)
- April 2012 (5)
- March 2012 (1)
- February 2012 (1)
- October 2011 (3)
- September 2011 (1)
- August 2011 (1)
- July 2011 (1)
- June 2011 (2)
- May 2011 (6)
- April 2011 (10)
- March 2011 (6)
- February 2011 (5)
- September 2010 (1)
Archive for October, 2011
-
Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds
Posted on October 27, 2011 | No CommentsTweetG’day, I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a VARCHAR) would have been fine. Apart from the storage... -
sp_configure OR sys.configurations? and do you back these up?
Posted on October 21, 2011 | 1 CommentTweetG’day, I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people actually use this table, or whether most people simply... -
Dropping a database – such a simple thing!
Posted on October 19, 2011 | No CommentsTweetG’day, I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect. Well, today I was experimenting with a development database....
