SELECT * FROM Posts WHERE Date_Posted = 'October 2015'
The last weekend of October is a common date for the daylight savings (or summer time) to get to its end in the north hemisphere. According to Wikipedia: Daylight saving time (DST) or…
Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have attended to one of the most valuable SQL Server training you can find (IEPTO2 by @SqlSkills team), I’ve also met really nice people…
*First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul…
*First published @ Steve Stedman’s blog (2015/05/27) If you are looking for more info on the corrupt database with Week 6 of the Database Corruption Challenge, you can take a look at the original post. Week 6 was won by Raul Gonzalez who submitted his…
*First published @ Steve Stedman’s blog (2015/05/06) The following is a solution to Corruption Challenge #4 that uses DBCC WritePage to fix the corruption. Before proceeding, be sure to read this warning. WARNING: DBCC WritePage is a dangerous command, that should never be used…