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...

Happy Mardi Gras. today is Fat Tuesday.. usually we celebrate and party like Zulu’s; but this morning the bytes hit the fan. we’re in the process of deciding how to proceed literally. either we move to B2Evo or kill another database and start anew; sans the past few years and months. wel...

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...

SQL is ubiquitous, but it’s hard to use. “It’s complicated, confusing, and error prone — much more so, I venture to suggest, than its apologists would have you believe,” says C.J. Date. “In order to have any hope of writing SQL code that you can be sure is accurat...

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 ...

InfoQ: Language Parity: Closures and the JVM - In this presentation from the JVM Languages Summit 2008, Neal Gafter discusses closures on the JVM. Topics covered include the JVM libraries, the challenges of running other languages on the JVM, language-specific wrapper/shim libraries, ways of making ...