Category: sql server

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

Post author By Jen McCown
Post date December 19, 2011
Categories In sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on 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 much used to using DateAdd() for all my […]

PASS Board of Directors – Who I’m Voting For

Post author By Jen McCown
Post date December 15, 2011
Categories In Community, News-ish, sql server, SQLPASS, sqlserverpedia-syndication, SSC

I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) 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 support the people I’m voting for – I really and truly do. It’s […]

SQL Server is Smarter Than You

Post author By Jen McCown
Post date December 8, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC
2 Comments on 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 SQL Server’s primary features. This means that […]