SQL Server

There are 3 entries for the tag SQL Server
SQL Profiler - Being self-centered is a good thing

I don't know why I hadn't taken the time to do this before, but I just invested 5 minutes into SQL Profiler to make my life much easier when debugging stored procedures. When I'm faced with stored procedure debugging, especially procedures that take awhile to run, or require a series of steps in the application to fire off, I often use SQL Profiler to capture the SQL call.  Then I'll re-run the call directly in SQL Management Studio.  But SQL Profiler can bring back a lot of noise, making it tough to grab only what I need. I...

posted @ Thursday, February 7, 2008 3:44 PM | Feedback (2)

SQL Server JOIN conditions

Every time I write a SQL statement that has a JOIN like this... 1: SELECT * 2: FROM Products 3: INNER JOIN Categories ON Categories.category_id = Products.category_id I wonder why I can't just write it like this... 1: SELECT * 2:...

posted @ Thursday, January 24, 2008 12:15 AM | Feedback (0)

SQL Server Enhancement Idea - Inactive records

About a year ago, I had an idea for a SQL Server enhancement that I never wrote about.  I crafted a few sample queries that would utilize the feature, and I shared them with some colleagues, but I never wrote an article about it.  Needless to say, it's been in the back of my head ever since, as an "unfinished task." One problem that almost all of us face is dealing with inactive database records.  There are dozens of approaches out there, but a few are becoming pretty standard.  Personally, I've ended up using an 'IsActive' column on tables.  I noticed...

posted @ Thursday, January 24, 2008 12:07 AM | Feedback (2)