Viewing 15 posts - 1 through 15 (of 48 total)
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!
James
MCM [@TheSQLPimp]
February 22, 2013 at 8:25 am
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 -...
James
MCM [@TheSQLPimp]
February 22, 2013 at 7:52 am
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...
James
MCM [@TheSQLPimp]
February 21, 2013 at 7:27 am
And the compare stuff, that rocks! Although SQL Server Data Tools does a damn fine job of this too and has intellisense.
James
MCM [@TheSQLPimp]
January 1, 2013 at 2:05 pm
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...
James
MCM [@TheSQLPimp]
January 1, 2013 at 2:00 pm
Smashing article Jeff. Binary sorts rule! I have been using these with recursive CTEs for a few years now and they rock!!!
James
MCM [@TheSQLPimp]
November 14, 2012 at 2:27 am
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...
James
MCM [@TheSQLPimp]
April 18, 2011 at 9:39 am
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...
James
MCM [@TheSQLPimp]
April 18, 2011 at 7:55 am
Jessica,
A fine series of articles and certainly a good learning tool for my junior developers!
James
James
MCM [@TheSQLPimp]
April 13, 2011 at 6:56 am
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!...
James
MCM [@TheSQLPimp]
April 12, 2011 at 2:34 am
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...
James
MCM [@TheSQLPimp]
April 11, 2011 at 2:30 am
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...
James
MCM [@TheSQLPimp]
April 8, 2011 at 2:35 am
David,
This is exactly how I do it!
Nice article.
James
James
MCM [@TheSQLPimp]
February 17, 2011 at 2:20 am
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...
James
MCM [@TheSQLPimp]
February 17, 2011 at 2:17 am
Very helpful article. I will certainly make use of this.
Cheers, James
James
MCM [@TheSQLPimp]
February 14, 2011 at 1:42 am
Viewing 15 posts - 1 through 15 (of 48 total)