TSQL Archive

  • TweetG’day All, While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came to my notice that we additionally have the IIF […]

    THE IIF statement – SQL has it at last.

    TweetG’day All, While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came to my notice that we additionally have the IIF […]

    Continue Reading...

  • G’day, I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced in SQL SERVER 2012. So what does […]

    The CHOOSE keyword

    G’day, I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced in SQL SERVER 2012. So what does […]

    Continue Reading...

  • TweetG’day, Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to each TSQL-Tuesday of the year – lets see how […]

    TSQL-Tuesday#050 – Automation

    TweetG’day, Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to each TSQL-Tuesday of the year – lets see how […]

    Continue Reading...

  • TweetG’day folks, I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that used several temporary tables and had faily complex logic. […]

    Do you clean up after yourself?

    TweetG’day folks, I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that used several temporary tables and had faily complex logic. […]

    Continue Reading...

  • TweetG’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 […]

    Multiple ALTER DATABASE SET options

    TweetG’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 […]

    Continue Reading...

  • TweetG’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 – […]

    Following good practice saves wasted time down the line.

    TweetG’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 – […]

    Continue Reading...

  • TweetG’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 […]

    2012 DDL for Roles

    TweetG’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 […]

    Continue Reading...

  • TweetG’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 […]

    Database ownership

    TweetG’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 […]

    Continue Reading...

  • TweetG’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 […]

    sp_configure OR sys.configurations? and do you back these up?

    TweetG’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 […]

    Continue Reading...

  • TweetG’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. […]

    Dropping a database – such a simple thing!

    TweetG’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. […]

    Continue Reading...