Preview of the Table Size Advisor
As I get the Database Health project ready to release as a beta, more of the components are coming together. For instance shown here is… Read More »Preview of the Table Size Advisor
SteveStedman
Should I Use A Unique Identifier As A Primary Key?
Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other… Read More »Should I Use A Unique Identifier As A Primary Key?
TSQL to Determine Plan Cache Size
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… Read More »TSQL to Determine Plan Cache Size
Index Defragementation and Management
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… Read More »Index Defragementation and Management
Making Progress on the Server Health Re-write
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… Read More »Making Progress on the Server Health Re-write
Gone Fishing.
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… Read More »Gone Fishing.
SQL Server Health Reports — Working on Version 2
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… Read More »SQL Server Health Reports — Working on Version 2
TSQL Pivot Table
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… Read More »TSQL Pivot Table
Working on my Lean Software Development presentation today.
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… Read More »Working on my Lean Software Development presentation today.
Common Table Expression – links
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… Read More »Common Table Expression – links