SQL RNNR

As I have wanted to do each year, here is my goals post for 2012.  Last year I set out to do this very same thing but was very unsuccessful at completing the post.  Here is all I had written: Personal Family Blogging Build out my Virtual Environment Professional SSIS [...]

We are rapidly closing in on the February meeting for S3OLV.  You might remember reading about the upcoming meeting here. We are looking to have an excellent meeting this month.  We have had a good run on superb presentations, and Troy aims to keep us going in the right direction. [...]

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon. I enjoyed reading this book.  The story continues from Daemon, but in a largely different direction.  I like the direction the book took, for the most part.  I was hoping that there would [...]

On January 19th, I published a post about the Dedicated Administrator Connection.  I spoke very briefly of the system base tables in that article.  Today, I want to dive into these tables a little bit more. First, let’s get the Microsoft definition for these tables.  ”System base tables are the [...]

Slammer By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm it caused came largely due to unpatched, unprotected SQL Servers. We are now 9 years out from the initial discovery of this worm.  The worm has made its way [...]

Do you recognize this person?   If you are from the Colorado Springs area, you probably do.  This is:       Troy Ketsdever (twitter) Troy will be presenting to the Las Vegas SQL User Group on February 9, 2012 @ 6:30 Pacific.  Here is his bio: Troy Ketsdever is [...]

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh Lewis (Twitter).  Josh presented on a pretty tough topic in my opinion.  He chose to present to us the topic of [...]

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that those functions were in some DMOs and that you could get at them through the resource database. Today I found myself learning more about the resource database.  Due to what [...]

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be dark 18 Jan 2012 between 10:30 and 21:30 GMT-8. Normal services will return after that.   You can see support of [...]

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me some interesting things I had never really paid much attention to in the past.  When I started paying attention to these things, I found myself jumping down a rabbit hole. [...]

Has anyone figured out how to get this to work in a database at compatability level 80 on a 2005/2008 ...

You know you could just call Pizza Hut and have them deliver a pizza to my door...that'd be swell of ...

@Neil - thanks for the additional script. Be careful of sp_msForeachdb. It has limitations and will throw some ...

I have worked an alternative without a cursor. DECLARE @STATEMENT NVARCHAR(MAX) SET @STATEMENT = N'USE [?]'+ CHAR(13) +';' +CHAR(13) + N' SELECT SO.name , ...

As a follow-up to this, I have monitored my logs throughout the day and continue to see various different hosts ...

Yes - that would definitely be an issue. Thanks for getting back on it.

I found that the problem was related to the database being in compatibility mode 80. It works fine for compatibility ...

I created the script on 2008 R2. Are you using the script as is, or did you modify? ...

does this only apply to SQL 2005? I get an error on SQL 2008 R2: Msg 102, Level 15, State ...

Yes. The higher the value, the more likely the index would be of benefit to you.