Troubleshooting | SQL Server Blog - StraightPath Solutions

Got SQL Server Questions?

A Great Idea – #SQLHelp hashtag on Twitter
I was following a conversation today between Brent Ozar, who is @BrentO on twitter and Aaron Nelson, who is @SQLVariant on twitter.
A great idea was discussed: A twitter hashtag that, as Jorge Segarra (or @SQLChicken on twitter) describes it in his blog post, can act like a bat [...]

What’s Your Point?

As a DBA you are getting pinched between developers, project managers, budget conscious managers and server teams. When a critical issue with no one easy answer for those people pops up, what do you do? You can panic or try and point the blame someplace else or you can rise to the situation and help [...]

A Picture That Says,

So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more.
I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use in [...]

Rolling Back (or is it??)

Interesting Issue Today/Yesterday -
A query was using a linked server to grab data from DB2 via an ODBC connection. Normal execution time is about 15 minutes. This had run on for at least 7 hours when it was decided to kill it, appeared to be doing nothing but causing blocks (due to Intent Shared and [...]

Troubleshooting Methodology

What is a troubleshooting methodology?
A lot of the technical problems I encounter with clients or in various roles are not really the fault of the technology at hand. They are either the result of rushed work, apathetic work or botched troubleshooting.
Before talking about what troubleshooting is, let’s talk about what it is not. It is [...]

SQL Server Blog – StraightPath Solutions

Categories

Archives

Got SQL Server Questions?

What’s Your Point?

A Picture That Says,

Rolling Back (or is it??)

Troubleshooting Methodology

Recent Posts