SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: In this blog, we will take a look at why it is essential to leave AUTO CLOSE database option turned OFF for a Production or a Non-Production SQL Server …

Continue reading SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Why %string% Is Slow in SQL server, convert scan to seek

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Users expect every application to have a built-in blazing-fast search functionality.  To pull that off, developers build search queries that let users enter a string, …

Continue reading Why %string% Is Slow in SQL server, convert scan to seek