SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2010

Marathon Schedule

Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are Hurricane Half Marathon, HobbleCreek Half Marathon, Top of Utah Half Marathon, Top of Utah Marathon, St. George Marathon, and the Deseret News (Pioneer Days) Marathon. My normal season would have… Read more

4 comments, 1,449 reads

Posted in SQL RNNR on 30 April 2010

BLOB Index Columns

For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database.  I have since seen a request to add to that script.  The addition would add some good information concerning the columns involved in a BLOB index.  This information is to… Read more

0 comments, 1,195 reads

Posted in SQL RNNR on 27 April 2010

Index Stats Duplication

I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index.  This kind of behavior can be somewhat concerning since that view should have a unique entry for each index.  As described by Microsoft, this view

“Returns counts of different types of index operations and… Read more

10 comments, 1,803 reads

Posted in SQL RNNR on 22 April 2010

SQL 2008 R2

Really short post here.  I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released the SQL 2008 R2 book.  I knew this book was in the works from speaking to Stacia over the last few months (she’s in my UG).… Read more

1 comments, 550 reads

Posted in SQL RNNR on 21 April 2010

Stepping Stone Cert II

Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and MCITP.  I had planned on keeping regular updates about the topic on my blog and have been slacking a bit.  It is certainly time to post an update.

Since that… Read more

3 comments, 728 reads

Posted in SQL RNNR on 20 April 2010

BLOB Report T-SQL Tuesday #005- Reporting

This month for my second submission into T-SQL Tuesday, I decided to go with something that provides some insight into the data that is being stored and the impact it may have on storage.  If you haven’t seen it by now, I made a bone-headed mistake last week by submitting… Read more

2 comments, 1,125 reads

Posted in SQL RNNR on 13 April 2010

S3OLV April Meeting Recap

We held our meeting last night and had a good time.  Thanks to those that were able to make it out.  Comments made after the meeting were favorable.  People enjoyed the meeting, there was a lot of discussion, and some good information disseminated.  Oh, and we had PIZZA too.

Our… Read more

2 comments, 441 reads

Posted in SQL RNNR on 9 April 2010

How Silly

Have you ever done anything that made you feel like a dunderhead?  Maybe a little bone-headed, thick, numb-skullish?

Here is my grin and bear it oops post about a recent post I wrote.  I somehow believed that 6 April 2010 was the second tuesday of the month.  I wasn’t paying… Read more

1 comments, 540 reads

Posted in SQL RNNR on 7 April 2010

LV April SQL Users Group Meeting

S3OLV or SSSOLV will be holding our meeting Thursday April 8th.  The User Group is in affiliation with PASS and meets monthly typically on the second thursday of the month.

This month we will be hearing from Stacia Misner (blog |blog 2 | @StaciaMisner).  She will be… Read more

0 comments, 451 reads

Posted in SQL RNNR on 6 April 2010

IP and Default Trace…T-SQL Tuesday #005 - A week early - D'oh

As chance would have it, I had been checking Adam’s blog daily for the last few days to find the next T-SQL Tuesday.  Not having seen it, I started working on my next post yesterday evening.  The fortunate thing is that the post I was working on fits well with… Read more

4 comments, 1,740 reads

Posted in SQL RNNR on 6 April 2010

Goal Review Q1

As we close out the First Quarter of 2010 it is time to review progress made on the Goals I set at the beginning of the year.  So far, I think I am progressing pretty well.  There has been measurable progress.  Thus I will break down each of the goals… Read more

3 comments, 490 reads

Posted in SQL RNNR on 1 April 2010