Ah, that does complicate things. Do look into it though, as it would make for a good follow up article for you to write. And do keep writing!

In the long run, especially with examples of having 7,500 active out of 20M, you will want to move to partitioned views if you stick on standard edition.

Table A -...

Nigel, certainly a good quick method of reducing IO in this situation with no code changes. Bear in mind that statistics are NOT automatically maintained on filtered indexes and you...

And the compare stuff, that rocks! Although SQL Server Data Tools does a damn fine job of this too and has intellisense.

Hi Eliassal. It was nearly two years ago that I wrote the article, so please forgive me for being rusty. There are embedded line feeds in the function, so if...

Smashing article Jeff. Binary sorts rule! I have been using these with recursive CTEs for a few years now and they rock!!!

Thanks all, I too was unaware of this data type but have now put it into use. I agree that DST is a pain. The timezones in .net know that...

Good point Mark, Date would be better here as the time portion is irrelevant. I don't tend to store many dates like this but the Date data type would be...

Jessica,

A fine series of articles and certainly a good learning tool for my junior developers!

James

A good first article. Yes there are a few minor points that will be picked up on but that's all good, as you only learn about article writing this way!...

Nice Article David, it certainly highlights a potential problem when using ORMs against SQL Databases (and dynamic SQL in general!).

I think many people though, especially junior developers/DBAs, could make more...

Nice article Eli and has certainly generated some discussion.

I too would use OPENROWSET in a derived table, rather than creating the view etc. if I was trying to achieve...

David,

This is exactly how I do it!

Nice article.

James

Todd,

Nice article. I also have large calendar tables to deal with - as one of my clients uses a rolling four week cycle starting the first saturday before February the...

Very helpful article. I will certainly make use of this.

Cheers, James