Category: Classes

Notes from SQL Server Classes

By Posted on Posted in Classes, SQL 2012, TSQL 2012 No Comments Tagged with ,

Like the other new Analytic functions, PERCENTILE_DISC and PERCENTILE_CONT require the use of the OVER clause. For this example I will be using almost the same revenue table in the sample database that I set up for the LEAD and LAG posting earlier in the week, and the PERCENT_RANK posting yesterday, just a few values changed to show the differences between these …

More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT Read more »

By Posted on Posted in CTE, Server Health, SQL Saturday No Comments Tagged with

I spent the day today at SQL Saturday in Vancouver BC.  I met some fabulous SQL Server professionals, and presented 2 sessions.   The first Session was on Unleashing Common Table Expressions in SQL Server.  This was the second time that I presented this one, the first was at a SQL Saturday, the first time was SQL Saturday 108 in …

A great day at SQL Saturday in Vancouver BC Read more »

By Posted on Posted in Server Health, SQL Saturday No Comments

In preparation for my presentation at SQL Saturday in Vancouver BC tomorrow, I have updated the SQL Server Health Reports. As I was preparing for my presentation I discovered a few areas that I wanted to improve on the layout, sorting and overall presentation. Too late for the presentation tomorrow, but I started on the next new report to add …

SQL Server Health Reports – Updated Read more »

By Posted on Posted in Code Camp No Comments Tagged with , , , , , , ,

It has been a busy week getting ready for  SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present. Today I submitted 4 sessions to Seattle Code Camp for their June session. Using SSRS 2012 Reports to Analyze SQL Server Health Unleashing Common Table Expressions in SQL Server SQL Server Performance for Developers What’s …

4 Sessions Submitted to Seattle Code Camp Read more »

By Posted on Posted in Server Health, SQL Saturday No Comments Tagged with ,

The SQL Server Health Reports have been updated.  As part of preparing for my SQL Saturday 114 presentation next weekend in Vancouver BC, I have updated the  SQL Server Health Reports one more time.   The latest update included lots of minor UI fixup making the reports look better.  Including more summary detail on the main Health Report.   Also, additional details …

SQL Server Health Reports Updated Read more »

By Posted on Posted in SQL Saturday, Steve, TSQL No Comments Tagged with , ,

Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that it can be quickly re-used in the future. If you are using proper parameterized queries, most of your queries will get kept around and re-used saving lots of CPU and memory on SQL Server. If …

How big is your procedure cache? Read more »

By Posted on Posted in SQL Saturday, SSRS, Steve No Comments Tagged with , , , , ,

As I have been working on my SQL Server Health Reports for my presentation at SQL Saturday 114 in Vancouver on March 17th, I have changed the way that I do things several times.  After attending a SSRS class “SSRS Beyond the Basics ” at SQL Saturday 108 in Redmond presented by @sqlbelle I learned a few tricks to help make this happen. …

SSRS – Using a subreport for navigation Read more »

By Posted on Posted in CTE, Performance, SQL Saturday No Comments Tagged with , , , , , , ,

After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people.  Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some additional content. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path …

CTE Hierarchy compared to the alternative Read more »