I'm blogging again, and about time too

Posted by fatherjack on Simple Talk See other posts from Simple Talk or by fatherjack
Published on Sat, 12 May 2012 02:02:00 GMT Indexed on 2012/05/30 16:56 UTC
Read the original article Hit count: 325

Filed under:
|
|
|
|
No, seriously, this one is about time. I recently had an issue in a work database where a query was giving random results, sometimes the query would return a row and other times it wouldn't. There was quite a bit of work distilling the query down to find the reason for this and I'll try to explain by demonstrating what was happening by using some sample data in a table with rather a contrived use case. Let's assume we have a table that is designed to have a start and end date for something, maybe...(read more)

© Simple Talk or respective owner

Related posts about SSMS

Related posts about Tips and Tricks