Category: SQL Server

How to find the duplicate records on certain fields in SQL Server ?

You can use the group by and having clause in your T-SQL query to find out the duplicate records from the table. How to find the duplicate records on certain fields in SQL Server ? Lets have a look at the query that uses the group by and having clause on the Person table in the AdventureWorks database. The firstname column is used as the…

SQL Server Error Code – 35384 the statement failed because column ‘%.*

In this blog post, you’ll learn more about the SQL Server Error Code 35384 and the error message description that is shown SQL Server Error Code 35384 SQL Server Error Description for the Code :35384 The statement failed because column ‘%.*ls’ on table ‘%.*ls’ is a lob column. Non clustered index with lob column as included column cannot co-exist with clustered columnstore index.

SQL Server Error Code – 41826 stored procedure ‘%.*ls’ tried to set a

In this blog post, you’ll learn more about the SQL Server Error Code 41826 and the error message description that is shown SQL Server Error Code 41826 SQL Server Error Description for the Code :41826 Stored procedure ‘%.*ls’ tried to set a lower limit to the user memory quota. The operation failed because the user memory consumption is larger than the specified target, delete some…

SQL Server Error Code – 8740 the row is too large to be shuffled betw

In this blog post, you’ll learn more about the SQL Server Error Code 8740 and the error message description that is shown SQL Server Error Code 8740 SQL Server Error Description for the Code :8740 The row is too large to be shuffled between distributions. Row Size in Bytes: %d: Max Allowed Row Size in Bytes: %d. Please contact support for assistance.