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 or more columns. There are two main types of indexes in SQL Server: clustered and …
SQL Server and Clustered vs. NonClustered Indexes Read more »
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 information about the version of SQL Server, the operating system, and other details. To use …
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 write data to the disk due to a hardware or software failure. Error 823 “I/O …
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 in the database. SQL Server supports four different isolation levels, which are: The isolation level …
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 clause. The HAVING clause is used to filter the results of a GROUP BY clause, …
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 rows within a query. These functions operate on a set of rows, called a window, …
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 that have an even object ID and are accessed on December 25th, which is Christmas …
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 is 50% off the SQL Server JOIN Types class. The JOIN Types class is our …
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 I had seen so many small (and large) business being impacted by ransomware. If I …
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 so many of our small business customers. This is more than just a course, enrollment …
Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts Read more »