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

Archives: August 2010

Defensive Db Programming Chapter 06

We are here again after another week and ready for another episode in this series.  Today we get to talk about chapter 6 in the book by Alex Kuznetsov (Blog).  You can find more on this series by looking here.

Common Problems with Data Integrity

Alex explains… Read more

0 comments, 672 reads

Posted in SQL RNNR on 30 August 2010

Memory

Not a sound from the pavement

Have you ever come across a SQL query that used to run faster?  Has that query just recently begun to run considerably slower?

I just ran into one of those situations.  I had a query that should have been running in seven minutes or… Read more

18 comments, 1,381 reads

Posted in SQL RNNR on 25 August 2010

SSSOLV: Twitter Compliant

This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter).  I am not certain why it took so long for us to do this, but we have finally got the UG on a twitter account.  We plan to use this medium… Read more

0 comments, 166 reads

Posted in SQL RNNR on 24 August 2010

Sp_whoAmI

I was doing a little catching up on some blog reading today and came across a new post from Adam Machanic (Blog | Twitter).  The post is titled Who Are You and is asking for input from the readers.  Quite frankly, I think it is a great idea.… Read more

2 comments, 144 reads

Posted in SQL RNNR on 24 August 2010

Defensive Db Programming Chapter 05

We are here again with after another week and ready for another episode in this series.  Today we get to talk about chapter 5 in the book by Alex Kuznetsov (Blog).  You can find more on this series by looking here.

The title of the chapter this… Read more

1 comments, 802 reads

Posted in SQL RNNR on 24 August 2010

Star Struck

Have you ever run into an error and been puzzled as to why that error occurred?

Recently I have been working on a project to backfill a development and QA environment.  These environments are essential in any database environment to help ensure the production database will continue to work after… Read more

9 comments, 168 reads

Posted in SQL RNNR on 17 August 2010

S3OLV August Recap

The SQL Server Society of Las Vegas meeting has come and gone once again.  This meeting is held typically on the second thursday of the month each month.  Once the meeting got under way, it was a very good meeting and people were highly impressed with the meeting.  Getting to… Read more

0 comments, 130 reads

Posted in SQL RNNR on 16 August 2010

TSQL Tuesday 009 Roundup

T-SQL Tuesday #009: Beach Time

I hope you enjoyed your time in the sun with your toes in the sand.  We are wrapping up this vacation with a little recap on what we learned.  There were some similarities and some differences amongst our vacationers.

I enjoyed reading the comments made… Read more

0 comments, 166 reads

Posted in SQL RNNR on 13 August 2010

Defensive Db Programming Chapter 04

This week we will be checking out the fourth chapter of this book by Alex.  This is a continuous effort that started with my blog post on the first chapter.  In this chapter, Alex delves into a couple of features that are new with SQL 2005 that could affect… Read more

0 comments, 206 reads

Posted in SQL RNNR on 11 August 2010

R & R

It is once again time for the blog party known as TSQL Tuesday.  I am hosting this month and wanted to also participate.  The theme is “Beach Time” and this is TSQL Tuesday #9.  Why did I choose this theme?  There are a few reasons for it.  1.)  There are… Read more

2 comments, 119 reads

Posted in SQL RNNR on 10 August 2010

August SSSOLV Reminder

Just another reminder about the Las Vegas User Group meeting coming up on August 12th.

Here is the info:

The S3OLV UG will be meeting Thursday August 12 at 6:00.  Come and enjoy the fun and socialize with local SQL Server enthusiasts.

This month we will be hosting another LiveMeeting…

Read more

0 comments, 131 reads

Posted in SQL RNNR on 10 August 2010

August S3OLV UG Meeting

It is nearly UG meeting time once again.  The S3OLV UG will be meeting Thursday August 12 at 6:00.  Come and enjoy the fun and socialize with local SQL Server enthusiasts.

This month we will be hosting another LiveMeeting presentation.  We have the pleasure of listening to Grant Fritchey ( Read more

0 comments, 148 reads

Posted in SQL RNNR on 4 August 2010

TSQL Tuesday Coming Up

The next TSQL Tuesday is only 1 week away.  This month the topic covers getting a little R&R.  We would like to know some of the things that you do in order to get the much deserved R&R.  Even if R&R means that you are changing jobs and you need… Read more

0 comments, 142 reads

Posted in SQL RNNR on 3 August 2010