SQL Server and Clustered vs. NonClustered Indexes
In SQL Server, an index is a data structure that allows you to quickly retrieve data from a table based on the values of one… Read More »SQL Server and Clustered vs. NonClustered Indexes
SQL Server
Finding the version of SQL Server being used
To find the version of SQL Server that is being used, you can use the @@VERSION system function. This function returns a string that contains… Read More »Finding the version of SQL Server being used
SQL Server Errors 823, 824, or 825
Errors 823, 834, and 825 are all related to I/O errors in SQL Server. These errors occur when SQL Server is unable to read or… Read More »SQL Server Errors 823, 824, or 825
SQL Server Isolation Levels and What They Mean
In SQL Server, the isolation level is a property that determines how transactions are isolated from each other, and how they access and modify data… Read More »SQL Server Isolation Levels and What They Mean
SQL Server HAVING clause on SELECT statements
The SQL HAVING clause is used in conjunction with the GROUP BY clause to filter the results of a query based on the group by… Read More »SQL Server HAVING clause on SELECT statements
SQL Server Windowing Functions
SQL Server windowing functions are a powerful and versatile set of tools that allow you to perform complex calculations and operations on a set of… Read More »SQL Server Windowing Functions
Christmas Queries
Here is a sample Christmas-themed query for SQL Server: This query returns the greeting “Merry Christmas!” and the current date. It only selects user tables… Read More »Christmas Queries
50% off TSQL JOIN Types class
As the last day of November, today is the last day that I will be promoting specials for our SQL Server training courses. Today’s promotion… Read More »50% off TSQL JOIN Types class
Free Ransomware Course – Everyday Value
Around a year ago I put together this free Ransomware Awareness course. It is one of those things that I felt so strong about because… Read More »Free Ransomware Course – Everyday Value
Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts
The reason that I have chosen this deal for Small Business Saturday is that this blocking query script has made such a big difference for… Read More »Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts