SQL RNNR

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

Twitter and Your Career With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this month these two questions: Why should average Jane or Joe professional consider using twitter? What benefit have you seen in your career because of twitter? But first, a [...]

SQL Server has means built into it to track possible missing indexes.  This used to be found through the use of the Index Tuning Wizard.  The process has improved over time (you can sort of see that from my April Fools post). As luck would have it, I was recently [...]

The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to take a second shot at a previous TSQLTuesday. This second shot is giving me fits.  I have no clue if it is TSQLTuesday 26 or if it is TSQLTuesday 23. [...]

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.

A quick question about the Impact column. I just want to check that the higher the number, the better ...

Excellent books. The first is better than the second, but the second has some good philisophical/thinking areas. If you haven't read ...

Hi Jason, this is very nice possibility in SSMS! Most of the DB Developers didn't know about it, I'm talking for ...

D'oh. I didn't even think of the funky naming conventions out there. I will fix that.