In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here are the before and after queries to determine the plan cache size in SQL Server 2012, and prior to SQL Server 2012. SQL 2012 Plan Cache Size Pre-SQL 2012 Plan Cache Size For more details …
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole project is the index defragmentation part of the project. This has turned out to be more challenging that I originally expected, but a lot more interesting than I expected as well. Yesterday I discovered a …
Originally I implemented the Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard to distribute in a way that they could be shared and customized to the needs of a project like the Database Health Reports should be. Here is what I have so far, and I think …
I am off today and headed out fishing, with hopes of catching some salmon. It is going to be a great season. http://Fishing.stevestedman.com -Steve Stedman Bellingham WA
Late last year and early this year, I created a collection of report in SSRS that I called SQL Server Health reports. Some of the things that the Server Health report evaluates are the following Index Fragmentation Big One Time Use Queries Long Running Queries Duplicate Indexes CPU Utilization Database Size Backup Set Statistics But…. I have found it very challenging to …
SQL Server Health Reports — Working on Version 2 Read more »
TSQL Pivot Table? Whats that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below creates a database called pivot, you probably already have your own database to work in. Then it creates a table called REVENUE and fills it in with department revenue for just over a 10 year …
Working on a 1h hour introduction to LEAN Software development entitled Applying Lean Manufacturing Principles to Software Development. Its a little bit of agile, a bit of lean, and a ton of common sense. Here is a link to the presentation: Lean Software Development its not done yet, just a start.
Here are a few links to some of the other CTE examples used during my Common Table Expressions presentation. Using a CTE in a Function to Split Up a Query String Using a CTE to Split a String Into Rows Can we use CTEs use in SSRS? CTE Hierarchy compared to the alternative Calculating Factorials with a Recursive CTE CTE …
What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was Accelerating your Development Workflow presentation by Ian Davis. What a great presentation, it touched on the lean and agile development processes, it was very well done. The next one was a PowerShell presentation that …
Code Camp Schedule… The photo is pretty bad, but if you could see it you would see my three sessions.