Category: SQL Server

SQL Server Error Code – 41805 there is insufficient memory in the reso

In this blog post, you’ll learn more about the SQL Server Error Code 41805 and the error message description that is shown SQL Server Error Code 41805 SQL Server Error Description for the Code :41805 There is insufficient memory in the resource pool ‘%ls’ to run this operation on memory-optimized tables. See ‘http://go.microsoft.com/fwlink/?LinkID=614951’ for more information.

SQL Server Error Code – 41867 consistency errors detected in the memor

In this blog post, you’ll learn more about the SQL Server Error Code 41867 and the error message description that is shown SQL Server Error Code 41867 SQL Server Error Description for the Code :41867 Consistency errors detected in the MEMORY_OPTIMIZED_DATA filegroup. See preceding error messages for details. Consult https://go.microsoft.com/fwlink/?linkid=845604 for details on how to recover from the errors.

How to Get a value to a Variable in SQL Server ?

When you use the declare a variable using the DECLARE statement. The same variable can be used to store a value retrieved from the database and later can be used in your SQL Query. How to Get a value to a Variable in SQL Server ? For example , you want to retreive the value of the column JobTitle and store it in the variable…