Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened to come up tonight. Of course, the person asking for this was myself, but an answer was found nonetheless. Below are a couple scripts that can be used to generate RING_BUFFER_OOM errors in sys.dm_os_ring_buffers. Setup For RING_BUFFER_OOM … Continue reading Generating RING_BUFFER_OOM Errors
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the upcoming SQLRally! Some details if you are on the unawares – SQLRally is a 3-day SQL Server conference that will occur in Orlando, FL. Unlike the PASS Summit, SQLRally will be capped to 500 people. … Continue reading Last Call SQLRally Call for Presenters
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt When I started using XQuery to dig into the plan cache, it was just searching for some parallelism and I really wasn’t aware that I was using XQuery. I just … Continue reading Can You Dig It? – Missing Indexes
If you're reading this, it must be Monday morning. Oh dear, that means I am officially starting my public studying for the Microsoft Certified Master (MCM) exam. I've already failed this exam once and am not really up for failing again. To help prevent this, I figured studying through my blog and noting the things … Continue reading MCM Live Blog – Week December 13
It's a map! Have you been looking for something inside the system views of SQL Server 2007 R2 and haven’t known where to look? Tired of trying to figure out how to tie all of the system views together? Need a great new colorful way to spruce up your cube? If these or other questions … Continue reading SQL Server 2008 R2 System View Map
If you've been trying to come to the blog lately, you may have noticed a few errors connecting. Resources not available issues or content just not showing up. It appears that running a WordPress blog on a GoDaddy Windows server has some issues. It works for a while and then it just doesn't. And the whole … Continue reading Blog Under Some Repairs
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information. There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In this new series of posts, I plan to investigate the SQL Server plan cache. We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in town. It’s SQLRally! This is a 3-day conference that will occur in Orlando, FL. Instead of the typical unlimited number of seats that accompanies the PASS Summit, SQL Rally will be capped at 500 people. … Continue reading SQLRally Call for Presenters
Last week I suggested to others that we institute a little idea theft and put together a few blog posts sharing the things in life we are thankful for. As the holiday season is upon us and that whole Thanksgiving thing happened in the United States this seemed like a good time for doing this. … Continue reading Blog Round-up – What Are You Thankful For?
Strate SQL 