SP3 for SQL Server 2016 Just Released
Just over 3 years since Microsoft released SQL Server 2016 SP2, today Microsoft released SP3. There was a total of 17 Cumulative Updates in that… Read More »SP3 for SQL Server 2016 Just Released
CheckDB Chat with Steve and Derrick
Steve Stedman 0:15 So Derrick, one of the things we run into is customers who are a little bit resistant to running CheckDB as frequently… Read More »CheckDB Chat with Steve and Derrick
Cumulative Update #26 for SQL Server 2017
Today Microsoft released CU #26 for SQL Server 2017. Wow 26 CU’s for a SQL Server product. What is really amazing is that it is… Read More »Cumulative Update #26 for SQL Server 2017
Nested CTEs
Russian Nesting Dolls If you have ever seen the Matryoshka dolls known as the Russian nesting dolls or babushka dolls they are very interesting. They… Read More »Nested CTEs
SQL Server SEQUENCE
In 2012 SQL Server introduced the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years.… Read More »SQL Server SEQUENCE
September 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… Read More »September SQL Daily Monitoring – SQL Server Versions
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?
Recursive CTE to Calculate Dates for the Last 30 Days
Have you ever needed to generate a list of dates for the last 30 days. There are lots of different ways to do this with… Read More »Recursive CTE to Calculate Dates for the Last 30 Days
August Blog Post Wrap-up
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.… Read More »August Blog Post Wrap-up
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… Read More »TSQL Pivot Table