SQL Server Code,Tips and Tricks, Performance Tuning

Before you ask, SOT means Slightly Off Topic :-()) Take a look at Hi, I need help on simplyfying this Update query! I don't even want to...

The last two days have been the worst of my life; it feels like he combination of a really bad hangover, the flu and a massive toothache. It...

Remember the How Is Your Sensitive Data Encrypted In The Database? post I wrote a while back? A colleague just informed me that he got a le...

Take a look at this post: Rails Is A Ghetto This is probably one of the longest rants I have ever seen, interesting but be warned NSFW

Posted here at the microsoft.public.sqlserver.programming forum Hello world. I had some problems with my business. My name is Noor Hisham ...

This is part two of a three part series. Part one was about the phone interview , this part is about the in person interview. Part three is ...

SET ANSI_NULL_DFLT_OFF ON this is what this means, in English.... Set the setting ANSI NULL Default Off to ON Why not just SET ANSI_NULL_DFL...

How many Java programmers does it take to round up to a power of two? Well take a look: http://forum.java.sun.com/thread.jspa?threadID=24821...

I don't know if I should laugh or cry after looking at this code. This could not have been written by a human right? Anyway here it is, ...

You all have been through this at least once in your life. In your shop there is this one person who likes to use Enterprise Manager as thei...

I won't comment on the Britney madness but here is another gem: A man who was fired by IBM for visiting an adult chat room at work is su...

What Happens When You Let a Three Year Old Use Your Computer For 2 Minutes? This (I Spy a bunch of trouble) Shipping Method: Standard Shipp...