Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Within the value() and query() methods it is sometimes desirable to return a portion of a string. Similar to T-SQL, there is a substring function in XQuery that provides this functionality. In this XQuery for the Non-Expert post … Continue reading XQuery for the Non-Expert – Substring() Function
We’re up to the seventh post on the in the plan cache series. This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element. StmtSimple, commonly referred to as statement simple, can contain the plan information for a query plan, a store procedure, or a user … Continue reading Can You Dig It? – StmtSimple Element
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be one of those that has been thinking – “I would love to move to Minnesota because I love the thought of their frigid winters” – and need that job to get that move started, Digineer … Continue reading Digineer Is Hiring
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to re-cap so that leaves this post fairly open ended. At some point a couple years ago I read an article about not publicizing your resolutions to help keep you on track. Now, though, since I don’t … Continue reading Wrapping Up 2010
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
Strate SQL 