Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2010

XQuery for the Non-Expert – Substring() Function

Talk to the Experts

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

0 comments, 581 reads

Posted in StrateSQL on 31 December 2010

Can You Dig It? – StmtSimple Element

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

0 comments, 655 reads

Posted in StrateSQL on 30 December 2010

Digineer Is Hiring

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

0 comments, 200 reads

Posted in StrateSQL on 29 December 2010

Wrapping Up 2010

Goal Setting

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

2 comments, 319 reads

Posted in StrateSQL on 28 December 2010

Can You Dig It? – StmtCursor and StmtReceive Elements

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

1 comments, 534 reads

Posted in StrateSQL on 28 December 2010

MCM Live Blog – Week December 27

Watching videos?! Su-ure!

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

1 comments, 180 reads

Posted in StrateSQL on 27 December 2010

Can You Dig It? – StmtCond Element

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

0 comments, 303 reads

Posted in StrateSQL on 22 December 2010

Can You Dig It? – StmtUseDb Element

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

0 comments, 247 reads

Posted in StrateSQL on 21 December 2010

MCM Live Blog – Week December 20

Watching videos?! Su-ure!

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

0 comments, 190 reads

Posted in StrateSQL on 21 December 2010

Can You Dig It? – SHOWPLAN XML Structure

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

2 comments, 214 reads

Posted in StrateSQL on 20 December 2010

SSWUG Free SSIS Expo

Stinking Feet?

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

1 comments, 215 reads

Posted in StrateSQL on 20 December 2010

SQL Server 2005 Service Pack 4 RTM

Service Pack 4

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

1 comments, 294 reads

Posted in StrateSQL on 18 December 2010

SQLRally Session Submissions

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

2 comments, 255 reads

Posted in StrateSQL on 16 December 2010

Viewing RING_BUFFER_OOM Errors

Onion Ring Buffer?

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

2 comments, 620 reads

Posted in StrateSQL on 15 December 2010

Generating RING_BUFFER_OOM Errors

Onion Ring Buffer?

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

1 comments, 198 reads

Posted in StrateSQL on 15 December 2010

Last Call SQLRally Call for Presenters

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

1 comments, 226 reads

Posted in StrateSQL on 15 December 2010

Can You Dig It? – Missing Indexes



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

8 comments, 1,088 reads

Posted in StrateSQL on 14 December 2010

December PASSMN Meeting Today

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

1 comments, 225 reads

Posted in StrateSQL on 14 December 2010

MCM Live Blog – Week December 13

Watching videos?! Su-ure!

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

2 comments, 177 reads

Posted in StrateSQL on 13 December 2010

December PASSMN Meeting This Week

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

1 comments, 195 reads

Posted in StrateSQL on 12 December 2010

Older posts