Like operator searching so slow in SQL server

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: Searching a query result from the table with LIKE operator with string in %% always takes a huge time. This happens because, A LIKE with a leading % cannot …

Continue reading Like operator searching so slow in SQL server

Slipstreaming easy steps from SQL Server 2012 onwards

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: SQL Server 2008 introduced something that’s called “Slipstream Installation” and it’s exactly what you need – a way for you to deploy a SQL Server instance …

Continue reading Slipstreaming easy steps from SQL Server 2012 onwards

Working versions of SQL Server on Windows Server

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: The purpose of writing this post on what SQL version supported with what Windows version is because one of onshore client wanted to migrated its …

Continue reading Working versions of SQL Server on Windows Server