Hmm. thanks for the good read. Time to change some code around 🙂

I use a recursive CTE for this usually. In this example it will give you all the days in June. Had to use this when I created a...

Generally we do the database changes first. Usually these are just adding more nullable fields and using optional parameters at first for the extra functionality we've added. Which...

Nice article. I consider myself recursively challenged, not because I'm bad at math, just from inexperience I suppose. It's nice to see several different uses in one place...

Nice utility. Just found some missing indexes on an cached plan that has ran 2 million times. It wasn't the table I thought was missing indexes and haven't touched...

Thanks. I was re-reading the msdn site. Guess I didn't pay enough attention that it only resets it to the max column value if the identity is less...

I'm a little confused why 2 isn't allowed. Even on the msdn site it states :

NOT NULL can be specified in ALTER COLUMN only if the column contains no...