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

Archives: July 2011

Roundup for Un-SQL Friday #005: Bad Interviews

It’s time for the Un-SQL Friday #005 roundup!

From managers…

First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got some excellent advice from the hiring manager’s point of view.   I particularly liked this:

When asked what your biggest weaknesses are, it’s a good…

Read more

1 comments, 1,749 reads

Posted in SQL Awesomesauce on 29 July 2011

Speaking Schedule! I’m here (and there, and there…) to help

Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable period of imparting knowledge, or (B) a wonderful opportunity to hear me speak at any of several different venues.

Here’s the summary:

7/27 4:45PM CST - EDMPASS. 

7/29… Read more

0 comments, 559 reads

Posted in SQL Awesomesauce on 25 July 2011

Un-SQL Friday #005: Bad Interviews

Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable candidate. (Most of his responses started with “Well, there was this girl, and we were at a party….”). This, again, is an Un-SQL Friday topic if ever there was one! Read more

0 comments, 691 reads

Posted in SQL Awesomesauce on 19 July 2011

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips

It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query.  Here’s a quick demonstration of the power of a well-thought-out search clause on a date column.  For this example we’ll use AdventureWorks… Read more

2 comments, 792 reads

Posted in SQL Awesomesauce on 18 July 2011

SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

I am easily distracted.  Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server Books Online. This time, I was arrested by this little nugget:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property,…

Read more

0 comments, 951 reads

Posted in SQL Awesomesauce on 14 July 2011

Meme Monday SQLstrology – Table Valued Zodiac Function

It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.

We’re going to have to figure out what astrological sign our SQL Server instance has – when it was “born” (installed) – before we can apply any kind of horoscope predictions.  I’ll start with the base query… Read more

0 comments, 940 reads

Posted in SQL Awesomesauce on 11 July 2011