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

Archives: December 2011

SELECT GetDate() – 30 AS [This actually works??];

I just ran across this in a piece of code (that I didn’t write):

WHERE Thing >GETDATE()- 30

Aaaand it works. If you run the title of this blog post, you’ll get the date 30 days ago. I had no idea you could do this…I’m very… Read more

4 comments, 1,225 reads

Posted in SQL Awesomesauce on 19 December 2011

PASS Board of Directors – Who I’m Voting For

I was inspired by fellow blogger and all around good guy Nic Cain (Twitterblog) to write about the PASS BoD election, ending 12/20.  Here is Nic’s take on the subject. So, who am I voting for?

I’m not telling you.

It’s not that I don’t… Read more

0 comments, 660 reads

Posted in SQL Awesomesauce on 15 December 2011

#SQLLove for my Mentor

In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later by gifting various Apple games to me, and teaching me about pre-Internet BBSs

In 1992, my high school purposefully encouraged me on that same road by offering Programming… Read more

2 comments, 719 reads

Posted in SQL Awesomesauce on 14 December 2011

SQL Server is Smarter Than You

I had a brief email discussion recently, which could be effectively be boiled down to:

  • Them: “Are foreign key constraints more performant than referential integrity triggers?”
  • Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.”

Let’s start with a generic statement, and get more specific. Generally speaking: Don’t try to circumvent… Read more

2 comments, 816 reads

Posted in SQL Awesomesauce on 8 December 2011

How to Build a Resume (that doesn’t suck)

Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain key functions are very hard to perform.  In this case, not having a resume makes the job-getting difficult.

We’ve talked about resumes, and even reviewed a few, on the show… Read more

6 comments, 3,153 reads

Posted in SQL Awesomesauce on 6 December 2011