Welcome to EMC Consulting Blogs

Browse by Tags

• Database Development
• Database Edition
• Datadude
• Performance Tuning
• SQL
• SQL Server
• SQL Server 2005
• SQL Server 2008
• Team Edition for Database Professionals

• Calculating the ROI of DRY SQL vs FLY SQL

  My colleague Jamie Thomson   posted an intriguing article on DRY SQL which you can read all about here . It raised a number of questions for me so I thought I’d post my own response to it. Here is a list of some of these questions that sprung to Read More... Posted 15 July 2009 16:53 by James.Rowland-Jones | 2 Comments Filed under: Database Development, SQL Server, SQL Server 2008, T-SQL, Performance Tuning

• ISNULL() <> COALESCE(). Discuss.

  Crikey.  That title sounds like an essay I had to write when I was at school and that was a long time ago... Jamie Thomson raised an important point in a comment on a blog I posted yesterday entitled " Getting rid of getdate() ".  Read More... Posted 18 July 2008 10:30 by James.Rowland-Jones | 4 Comments Filed under: Database Development, SQL Server, T-SQL

• Getting rid of Getdate()...

  Ok I admit - I use it. Pretty much everyone I know uses it and yet I feel dirty when I do.  Why? Well it's not portable SQL and most certainly not ANSI standard.  I need to get the datetime I hear you say.  How do I do this without getdate()?  Read More... Posted 17 July 2008 10:32 by James.Rowland-Jones | 3 Comments Filed under: Database Development, SQL Server, SQL, T-SQL

• Using a Bitmask - a practical example

  A colleague of mine asked for a simple example to get him up and running with the basics of bitmasking.  Since I had gone to the effort to create the example I thought I might as well blog it :o). This example uses the logical AND operator &. Read More... Posted 04 July 2008 23:28 by James.Rowland-Jones | 4 Comments Filed under: Database Development, SQL Server, SQL, T-SQL

• T-SQL IDENTITY : Fun and Games with DBCC CHECKIDENT

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       Read More... Posted 03 July 2008 18:26 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, Datadude, Database Edition, SQL, T-SQL