It's amazing to me how the herd mentality works in Technology (and many other things) sometimes. I get the idea that since there are so many new things happening in Technology all the time, it is automatically assumed that "new = good" and "old = bad". I believe that this… Read more
As if I needed any further convincing that nested views were bad....
The other day I had to write a particularly ugly query to recover some lost data. The query was complicated (please don't ask) and the resulting SQL had 5 (five) levels of nested views. I realized that this… Read more
According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a Transact-SQL statement while using the serializable transaction isolation level". From this I took it to mean that Range locks are ONLY used in Serializable transactions.
So then I had to… Read more
Over the past few days I have been thinking that the Software Industry is in drastic need of a Professional Licensing mechanism. I cannot even begin to imagine how much it costs businesses when they hire people that are unqualified, and there is presently no mechanism that I know of,… Read more
Just saw something interesting....we have a requirement to divide a result set into a certain number of groups that have a certain size. This size is controlled by a configuration setting, so the user expects to see groups of At first glance I thought the NTILE function would be the… Read more
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work… Read more
OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data, we have to come up with additional tables and… Read more
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or how about… Read more