Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A few posts ago in the plan cache series I discussed the children for the Statements element. I’ve gotten through two of the elements and in this post we’ll be … Continue reading Can You Dig It? – StmtCursor and StmtReceive Elements
Time for the third week of blogging about the things that I'm doing to study for the MCM exam. Last week wasn't too spectacular - with the holidays and all I was pretty lazy on the studying. The formatting issues did get fixed, so if you see anything messed up send me a message. As … Continue reading MCM Live Blog – Week December 27
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A couple posts ago in the plan cache series I discussed the children for the Statements element. This next post will focus on the second of the five possible child … Continue reading Can You Dig It? – StmtCond Element
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt The last post in the plan cache series discussed the children for the Statements element. As I noted in that post, there are five possible children. This post will focus … Continue reading Can You Dig It? – StmtUseDb Element
Time for the second week of blogging about the things that I'm doing to study for the MCM exam. It seemed to go pretty good last week except for the whole screwing up the TweetMeme and ShareThis plugins on my blog. As I mentioned in the first post, I've already failed this exam once and am … Continue reading MCM Live Blog – Week December 20
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 last couple plan cache posts, I talked about a couple items that are available within the SHOWPLAN XML for an execution plan. These posts looked at how to … Continue reading Can You Dig It? – SHOWPLAN XML Structure
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get up for the whole morning? If so or if the two opening questions intrigued you enough to get this far – then I have the answer for you. SSWUG is offering a half day virtual conference … Continue reading SSWUG Free SSIS Expo
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL Server 2005 make sure you take a look at this and the Microsoft SQL Server support lifecycle to see that you have the coverage that you need. As I mentioned a few months back, it is important … Continue reading SQL Server 2005 Service Pack 4 RTM
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session. I’m not going to be a pot calling the kettle black. Below are the two sessions that I submitted. Hopefully they will appeal to enough people that I’ll get a … Continue reading SQLRally Session Submissions
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. He remembered that I’ve recently had a thing for XQuery and asked me to take a look at it. To play around with the output of this query, generate some RING_BUFFER_OOM messages in the sys.dm_os_ring_buffer. This can … Continue reading Viewing RING_BUFFER_OOM Errors
Strate SQL 