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)
TSQL Archive
-
Multiple ALTER DATABASE SET options
Posted on April 6, 2013 | No CommentsTweetG’day, Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement. It’s true, you can! Mostly I never see this done. Maybe it... -
Following good practice saves wasted time down the line.
Posted on September 10, 2012 | 1 CommentTweetG’day, Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this often results in simply delivering code that works –... -
2012 DDL for Roles
Posted on April 22, 2012 | No CommentsTweetG’day, I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures. The particular case that I came across today... -
Database ownership
Posted on April 5, 2012 | No CommentsTweetG’day, One of the features that I most like about management studio is the ability to generate a script of the actions that have been taken in one of the... -
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.... -
Select from a table with no rows returned.
Posted on July 5, 2011 | No CommentsTweetG’day, I recently ran into a nice feature that I had never encountered before. Sometimes, when developing or administrating an unfamiliar table we will simply do a “SELECT *” so... -
Catalog view or compatibility view?
Posted on May 9, 2011 | No CommentsTweetG’day, The recommended way to access SQL SERVER metadata is through the catalog views. The challenge is to be able to distinguish between the catalog views and the compatibility views,... -
How do you create or update stored procedures.
Posted on May 4, 2011 | No CommentsTweetG’day, Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system is being built in an agile manner. Stored...
