Built in Functions in SQL Server 2012
Microsoft SQL Server 2012 introduced 14 new built in functions. These new functions are: Conversion functions PARSE TRY_CONVERT TRY_PARSE Date
Read moresql server 2012
Find Users with DBOwner Database role
Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted
Read moreSQL Tip-8 | How to script out multiple SQL Server jobs at once
Migrating SQL Server jobs from one server to another is a critical task and there are many alternatives available for
Read moreUsing Covering Index
A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is
Read moreUnderstanding, Analysing and Troubleshooting Deadlocks – Part2
In First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves
Read moreFree SQL Server Webcast | Tap is the only Solution Ver.2 | 08-Nov-2012
Tap is the only solution – Ver. 2 Scarcity is the fundamental economic problem of having humans who have unlimited
Read more