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… Read more

She can dig it!
D Sharon Pruitt

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… Read more

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… Read more

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… Read more

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 looking at the StmtCursor and StmtReceive elements.

The SHOWPLAN XML schema defines both… Read more

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… Read more

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 elements – the StmtCond element.  You might want to call this the “Statement… Read more

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 on StmtUseDb.  Or as little children sometimes say “Statement Use Database”

As the… Read more

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… Read more

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 find execution plans that utilized parallelism or contained information on missing indexes Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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 kind of glanced over it and let it be.

Fast forward a couple… Read more

Getting SQL Server for
Christmas!

Happy holidays and seasons greetings! 

Don’t forget, PASSMN meeting is today.  As I’ve said before, we’ve teamed up with the new Minnesota PowerShell user group to put together this month’s meeting.

Date and Time:

• December 14, 2010, 5:00 PM CST

Location:

• 8000 Norman Center Drive,…

Read more

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… Read more

Getting SQL Server for
Christmas!

Happy holidays and seasons greetings! 

Let PASSMN put a little SQL and PowerShell in your stocking this week.  On Tuesday, Minnesota’s new PowerShell user group and PASSMN will be having a combined meeting.

The topic will, of course, cover both PowerShell and SQL Server.  The… Read more