A colleague had a problem concerning a query using the (NOT) IN predicate, use the following table creation script (attached to the blog entry) to see the effects of the problem and to repro it on your machine. Imagine you have two tables (not that hard till here) and you want to get the info...

I can talk about database almost all the day. Yesterday I had two technical meetings. One with Tech User Group of Markham and another with TorontoCASolutions. Let us go over my summary of both the meetings. Tech User Group of Markham, Canada Steve Jagadishan is very enthusiastic leader of the Tech U...

I am traveling to Toronto from Microsoft MVP Sumeet. I will be very tired as I am continuously working very hard from last 27th Feb. I am still Jet Legged from my trip from India to USA and now I am again changing time zones by visiting Canada. I get all my energy from feeling that what I am doing i...

This is the 137th edition of Log Buffer, the weekly review of database blogs. Dave Edwards is enjoying a week off, and so as part of my plot to take over the world, I am writing this week’s Log Buffer. First, the fun stuff: Josh Berkus tells us that the American English Translation of the Mang...

It’s been a while since I last blogged. I’ve become a forum moderator, an All-Star and also completed my final exams for my bachelor’s degree since then. Now that I have a little more time, I hope to contribute more often. I was installing SQL Server 2008 Dev Edition with all features, and ran...

Have you ever ran into database tables with a field which is used to mark if a row has been 'deleted' ? Probably. These fields are used to implement 'soft-deletes'. For the soft-delete impaired, a quick introduction. Soft-deletes are row deletes which are not really happening: instead of removing th...

As I am doing lots of experiements on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder - the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary files I have left there taking up my hard drive ...

Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx. ...

Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud. One key message this sends is, "if you want vast, on-demand scalability, you need a non-relational database". If that is true, then is this a sign that the once mighty relational database finally has a...

Wow - we had a full house last night..actually 5-6 people had to sit in the window sill as we simply ran out of room. The presentation was delivered by Aaron Griffith and Greg Davey, from mhm (www.mhm.com.au) and from the initial glance of the feedback forms it was a total success! I was partic...