count(*) or count (1) or count(”) Which is better in SQL server?
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
Does Index Improve SQL Server Query Performance. Yes Index improves the SQL Server query performance to a large extend. Let’s do an experiment.
MSDB – What is msdb database in sql server and what is it used for? Id this database important? Where is it located? Can we delete this database?
SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.
Using isnull in where clause is expensive in SQL Server. How to avoid useing isnull? Simple way to use case instead of isnull in where clause.