2 min read
0
Category: MSSQL
3 min read
1
2 min read
0
Find cached execution plan
An execution plan, simply put, is the result of the query optimizer’s attempt…
8 min read
3
Configuring Database Mail in SQL Server
SQL Server Database Mail facilitates email communication directly from the…
2 min read
0
SQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified…
2 min read
1
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical…
2 min read
4
4 min read
0
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database…
2 min read
0
Find all the users for a particular database
Introduction In SQL Server, managing user access and permissions is…
1 min read
0
How to run a SQL query using command prompt without SQL SSMS
Introduction How to run a SQL query using command prompt…