Avoiding Bad Query Performance

There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:

That’s certainly not...

Computed Columns and Divide by Zero

I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...

Conditional Default Values in SSRS

I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. ...

Convert comma separated string to table and vice versa

I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...

Denali

Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...

February 2012 – Monthly SQL Server Checklist

It’s the first Monday of February, mostly, it’s a short month, but there’s no reason to skirt on checking out...

Finding the Missing Perfmon Counters in SQL Express

My post this weekend about slaying beasts with magical .dll incantations was my way of relieving some stress after having...

Freedom

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon.
I enjoyed reading this...

Freedom

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon. I enjoyed reading this book.  The story continues from Daemon, but in...

LAST_VALUE() Analytic Function–SQL Server 2012

Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...