Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during...

A Full Day of Query Tuning

I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...

Guest Post on SQL Authority – Default Trace & Deleted Databases

I had the opportunity to write another guest post at SQL Authority:
Finding Out What Changed in a Deleted Database
This one...

SQLSaturday Orlando Marketing Plan-Part 34

Tuesday we sent our metronomic email of the week. No huge call to action this week. My schedule called for...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

More than sp_help

If you have worked with SQL Server for very long you have probably run across the extremely useful system function...

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause.

For example, in case of "IN", one can use...

Announcing SQL Server Radio – English Edition!

About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...

AVG() function in SQL Server

Avg():- This function is used to get the average value of a numeric column

Syntax:-

      SELECT AVG(column_name) FROM table_name

In this article,...