G’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 implications of a VARCHAR(MAX) column there is also the issue that in SQL SERVER 2008, having a column of… Read more

G’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 use the more common system stored procedure sp_configure.

As sys.configurations is simply a table, we can use an ORDER BY… Read more

G’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. The script I was using employed simply reusable code to drop and re-create the database – or so I though. Read more