Author: Dhruv Sheth
Hello friends, My self Dhruv Sheth, I have more than 10 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.
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