TSQL Pivot Table
TSQL Pivot Table? What’s 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… Read more…
Excited to Release Training Videos
Just this week the team at Stedman Solutions finished the SQL Server JOIN Types paid training course. I am very excited to complete this and to make it available to the SQL Community. Whether you have been writing SQL Querie Read more…
What’s your favorite SSMS time saving hotkey?
Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is to avoid switching to the mouse when you don’t have to. Here are some shortcu Read more…
Using the OUTPUT Clause in TSQL for Auditing
The OUTPUT clause is often times underappreciated by the TSQL programmer. There are many really interesting things that you can do with the OUTPUT clause, from inserting to two tables with one statement or to replace the SCOPE_IDENTITY option. Fo Read more…
Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to use it, I didn’t really explain what it means, or when to use it. Tha Read more…
More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the number of values. Percent rank is different than PERCENTILE, stay tuned for PERCENTILE_DISC and PERCENTILE_CON Read more…
Using a CTE in a Function to Split Up a Database Connect String
I came across this example when preparing my CTE presentation a while back. Which produces the following output.
August SQL Daily Monitoring – SQL Server Versions
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
The post August SQL Daily Monitoring – SQL Server Versions appeared first on Read more…
Risk Assessment Matrix for SQL Server Upgrades
A couple years ago in my Incident Safety Officer class with the fire department we studied risk assessment for any incident that the fire department may respond to. Since that time I have used a similar risk assessment matrix fo Read more…
TSQL Rounding or Truncating Date Time to Nearest Day, Hour, Minute or Second
One thing that I end up having to look search on regularly is rounding of dates and times in Transact SQL, having looked this up too many times I finally realized that it is time for me to do m Read more…
Using a CTE in a Function to Split Up a Query String
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. whic Read more…
How big is your procedure cache?
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 Read more…