Category: SQL SERVER
018. find a list of Weekends between given two Dates in SQL Server
This script helps to DBA for finding available weekends between the dates so they can set auto-schedule for database maintenance.
017. Find stored procedures which have used Dynamic Sql
Whenever we are finding some issues in performance, we are also try to avoid Dynamic Sql in Stored Procedure.To avoid
016. Find stored procedures which have used Temporary Table
Whenever we are finding some issues in performance, we are also try to avoid Dynamic Sql in Stored Procedure.To avoid
014. Who has CONNECT permission for an endpoint script – SQL Server
When we install SQL Server, SQL Server requires some of permissions like TSQL Local Machine, TSQL Named Pipes, TSQL Default
How to return XML in SQL Server?
We can use FOR XML statement at the end of the query to return xml data from the SQL Server.