Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2014

Standard Deviations with CTE in SQL

I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE).

The first CTE gets the standard deviation and the average for the entire database. The Database holds all of…

Read more

0 comments, 2,148 reads

Posted in Mike Davis SQL on 24 February 2014

SSRS – Creating Drill Through reports with MDX

If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill through report must be changed to Unique Name instead of…

Read more

1 comments, 789 reads

Posted in Mike Davis SQL on 10 February 2014

SSIS – Using Kill with SP_Who to Break locks

The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How can I get rid of these table locks?” This blog will show you how to build a package that will kill any SPID’s that are running on your system that…

Read more

2 comments, 977 reads

Posted in Mike Davis SQL on 3 February 2014