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

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

Hi All, I'm sure most of you who play with SharePoint also wear the DBA hat from time to time (or the other way around).  I have been working with a customer who has hundreds of instances scattered across the enterprise.  This script customized to answer several questions, but mainly t...

My wife says I have the humor of a 13-year old at times.  Maybe she's right. I was able to interview Mark Kashman, Product Manager for Interactive Media Manager, on IMM as a Digital Asset Management (DAM) solution.  I can't help but picture Beavis and Butthead, "Huh huh huh... he said DAM....

A very interesant whitepaper is now  available on HP site. Here are the covered subjects : SQL Server instances............................................................................................................................ 2 Processor affinity .........................................

Sometime you might be stuck in a situation for Analysis Services where you have to pull of security information from an external system to get the information about dimension or cell security. Implementing that is not that hard as you might think of. Though there are some things to keep in mind rega...

For two weeks in a row, Windows Update has told me that I need to patch my SQL Server 2005 SP2 installation - with a lower build number than I currently have! I have build 3159 (click here for an explanation of the SP2 silliness) and yet Windows Update tells me that I should let it install build 315...