Archive for the ‘Troubleshooting’ Category

Msg 7395: Unable to start a nested transaction

Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but I did have a developer email me with a problem she was having. (I do believe she may have been the only one actually working, can you imagine??) But that’s ok, I love using this [...]

January 5, 2012  Tags: , , ,   Posted in: T-SQL, Troubleshooting  2 Comments

SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?

So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install SQL 2012. (Aside: one of the biggest obstacles to progress is bureaucracy.) Anywho, I plan to explore all of the new features and functionality in 2012 and, of course, blog all about it here. But [...]

December 1, 2011  Tags: ,   Posted in: Features, Troubleshooting  2 Comments

SQL Server A to Z – Waits

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running; it’s the one getting CPU time. A runnable process has everything it needs to run, it’s just waiting for its turn on the CPU. A process that’s waiting, however, is one that needs some resource [...]

November 28, 2011  Tags: ,   Posted in: Troubleshooting  No Comments

Mistakes

This picture has never been more applicable to me than it was today.В  Here’s the story: One of my fellow DBAs was trying to configure DTC in an existing cluster and he was having some problems.В  In an effort to see where the problem lay, I added a DTC resource to the cluster.В  I then [...]

October 12, 2011  Tags: ,   Posted in: Troubleshooting  No Comments

Panic, Problems, and Plans

So what have I been up to?В  Well not writing blog posts, obviously. Everybody Panic!!! Really though, I haven’t exactly been slacking off these past couple weeks.В  As you may recall, one of my goals this year was to present at a SQL Saturday.В  To help me towards that goal, I have my very first [...]

September 14, 2011  Tags: , , , ,   Posted in: General, Professional Development, Troubleshooting  No Comments