SQL Server Troubleshooting

SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)

SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)

In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment, under certain circumstances, the installation might fail along with reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the…

The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏ 

The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏ 

When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏    Symptoms One symptom due to the above issue, is that the transaction log of a memory-optimized table, might continue to grow,…

The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.

Question: What I’m I doing wrong and I’m getting the following error message when trying to list my database’s tables? “The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.” Here’s the screenshot also: Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that…

There is insufficient system memory in resource pool ‘internal’ to run this query.

There is insufficient system memory in resource pool ‘internal’ to run this query.

This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to…

Internal Query Processor Error: The query processor could not produce a query plan

OK folks, it did happen a few days ago to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. I was trying to execute the following query: SELECT * FROM dbo.tbl1WHERE tbl2ID=(SELECT id FROM dbo.tbl2 WHERE Code=’Code1′)AND tbl3ID=(SELECT…

A transport-level error has occurred when sending the request to the server

This post’s purpose is to explain the above connectivity error and ways of resolving it. In some cases (upon “wrong” actions or network problems 🙂 we might get the following error in SQL Server: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider,…