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

Archives: August 2011

Bitwise and Derived Table revisited

Today I am going to revisit two posts from the past couple of weeks.  I want to revisit them just to make some minor updates and clarifications.  This is nothing earth-shattering but is good info to have.

The two posts to revisit are:

  1. Bitwise Operations
  2. Derived Table Column Alias


Read more

0 comments, 1,793 reads

Posted in SQL RNNR on 31 August 2011

Precision and Scale

As is the case with many of my topics of late, I came across this one by helping somebody else.  In SQL, we should be well aware of Precision and Scale of certain datatypes.

The particular case I was working on was focused on the decimal datatype, and so we… Read more

0 comments, 2,787 reads

Posted in SQL RNNR on 24 August 2011

TSQL Sudoku II

As luck would have it, today I came across this TSQL Challenge.  It just so happens that I had already worked on a SQL Sudoku script and blogged about it less than one week ago – here.

Since posting that last article on my work on that script,… Read more

0 comments, 1,068 reads

Posted in SQL RNNR on 23 August 2011

SQL Saturday 94

SQL Saturday 94 in Salt Lake City is fast approaching.  Will you be there?  I submitted three sessions in hopes of maybe getting one selected.  Last year, I only submitted one at the inaugural SLC SQLSaturday.  I even blogged about my experiences with that one (here and here Read more

0 comments, 675 reads

Posted in SQL RNNR on 22 August 2011

Bitwise Operations

Some time ago, I wrote an introductory post about bitwise operations in SQL Server.  I had fully intended on writing a follow-up to that.  Alas the opportunity has passed for the idea I was working on back then.

As luck would have it though, I encountered a new opportunity to… Read more

7 comments, 1,574 reads

Posted in SQL RNNR on 19 August 2011

Derived Table Column Alias

By now, you have heard of subqueries.  You have also heard of Common Table Expressions.  I am sure you know what a derived table is and that you get a derived table through either a subquery or CTE.  How familiar are you with the subquery flavor of a derived table… Read more

1 comments, 894 reads

Posted in SQL RNNR on 18 August 2011

TSQL Sudoku

I am a big Sudoku fan.  Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android Apps, Puzzle Books).  Over time, I have come across a solution here or there to solve these puzzles… Read more

2 comments, 1,017 reads

Posted in SQL RNNR on 17 August 2011

Top 5 Oracle Nuances I learned Today

I don’t do much with Oracle – at all.  Once in a blue moon, I find a little project to do that might involve Oracle.  I have never put a lot of thought to the differences between SQL and Oracle.  On the pet project I am doing right now, I… Read more

5 comments, 2,046 reads

Posted in SQL RNNR on 16 August 2011

Send DBMail

With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server.  The new method is called Database Mail.  If you want to send emails programmatically, you can now use sp_send_dbmail.  You can read all about that stored procedure here.

What I am really… Read more

3 comments, 1,291 reads

Posted in SQL RNNR on 15 August 2011

Summit 2011

Call me a slacker.  I have been postponing registering for Summit 2011.  I wanted to be sure that I had the week available in order to attend.

I finally did it!  I registered for Summit 2011.  I was stoked about it too.  Then I got the schedule for my sons’… Read more

0 comments, 497 reads

Posted in SQL RNNR on 11 August 2011


It is TSQL Tuesda… err Wedn… err Tuesday for August 2011.  This month the party is a day later and bringing us oodles of failure.

Adam Machanic is hosting this month.  He thought it would be a good idea to poke and prod us while getting us to torture ourselves.… Read more

0 comments, 714 reads

Posted in SQL RNNR on 10 August 2011

FK Hierarchy v 2.1

Last month I published an update to my Foreign Key Hierarchy script.  Today, I am providing a new update for that script.  A friend (Rémi Grégoire) helped out with some mods to this script.  The change for this month is nothing too intrusive.  The script is now updated for those… Read more

0 comments, 659 reads

Posted in SQL RNNR on 9 August 2011

S3OLV August Meeting II

I recently published a post about the upcoming meeting for S3OLV.  This post is to serve as an update to the post.  It is quite important that a more accurate abstract be shared concerning the presentation that will be given.

So, here is the update on that abstract and hopefully… Read more

0 comments, 571 reads

Posted in SQL RNNR on 8 August 2011

SSRS Export En Masse

Have you ever found yourself in need of exporting all of the reports from a Report Server?  I have found myself in need of extracting all RDLs from a Report Server on more than one occasion.  Reporting Services 2008 would rather have you do that in a rather monotonous and… Read more

6 comments, 2,371 reads

Posted in SQL RNNR on 8 August 2011

Come One Come All S3OLV August 2011

Hey Yo!!  We are primed and ready for this month down in Las Vegas.  We have a return presenter and we are looking to get some speed freak on with our TSQL Code.

From the Invite – one would see these notes:

This month we have a new feature we… Read more

0 comments, 553 reads

Posted in SQL RNNR on 5 August 2011

August Meme Monday – Crap Code

Interesting topic this month posted by Thomas LaRock.  This month he has chosen “crap code” as the topic.  I think it is interesting because there really are so many different ways to take this.

Knowing that there are so many qualifications for crap code, I personally like that… Read more

0 comments, 779 reads

Posted in SQL RNNR on 1 August 2011