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

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

J'ai pris quelque retard ces derniers temps dans ma lecture de la newsletter SQL-Server-Performance.com (que je vous recommande vivement) : Subscribe to our newsletter    aussi vais-je faire une liste des articles qui m'ont semblé les plus intéressants au cours de ces derniè...

Well, this has been a great "conference season" but I'm also glad that it's over for a bit. In the past 4 weeks, Paul and I have been to Vienna (check out Paul's post here), Barcelona (for TechED EMEA ITPro), Las Vegas (for SQL Connections) and finally to Seattle (for PASS). We...

I've tackled this type of question before but it's a very challenging thing to decide. Budgets are tight and training is always hard to quantify. However, working more efficiently and effectively - when properly trained - means smoother operations, less downtime, less data loss, less stress. So, if ...

At the end of June I run workshops with 2 ISVs both looking to completely re-develop their applications. One is entirely VB6, the other a combination of VB6 with C++. The beauty of "starting from scratch" with a one to two year development plan is you can take a hard look at the latest tec...

OK, I first posted on some of the limitations to indexes in SQL Server 2005 and 2008 in part one here. Now, I want to dive into index internals for a post (or two). And, I often get the question “who is the best audience for your blog – or, for this post� and well, that’s a bit hard to answe...

Memorial Day weekend we were in Chicago to celebrate my Father's life. We did a "Celebration of Life" memorial and we had a few drinks (celebratory Meyers, Tonic and lime - which was my Father's favorite drink), we (7 of us) gave a few heartfelt speeches, and a few friends wrote a song (and passed o...

There is a good article on this here : http://www.simple-talk.com/sql/t-sql-programming/sql-code-layout-and-beautification/ The problem : Badly-formatted SQL is the bane of my life. That is because my life is spent staring at SQL Code. Other peoples SQL code often looks ridiculous to me. As there is...

Yesterday I spoke about the new T-SQL Debugger. One of the readers wrote and told me that I should mention that this feature isn’t in the February CTP - and they are correct. I should have told you that you will see this very cool feature in the next release, which we currently plan to release som...