Author: VidhyaSagar
-
List of DMVs & DMFs available in SQL Server 2005
I’ve listed down all the DMV’s that are related to SQL server 2005
-
Database Management Views & Functions – SQL 2005
DMV’s are system views and its a new feature started SQL server 2005 with nearly 80 DMVs. DMV’s are system view that surface the internal counters of the database engine help present an easily comprehendible dashboard of the database engine performance that can be used to monitor the health of a server instance, diagnose problems,…
-
Enabling Remote connections via DOS or T-SQL
How to use the script 1.) Create the procedure in master db 2.) Use the command as below
-
Enable Disable Remote connections Via DOS or T-SQL
Ive seen in forums seeking to enable disable Remote connections via DOS prompt T-SQL. Ive searched google for this topic and didnt get any article on this topic, so i decided to write a procedure to change Remote connections via T-SQL so that this can be called from DOS.
-
Database Tuning Advisor – DTA
The Database Engine Tuning Advisor is a new tool in Microsoft SQL Server 2005 that enables you to tune databases for improved query processing. Database Engine Tuning Advisor examines how queries are processed in the databases you specify and then it recommends how you can improve query processing performance by modifying physical design structures such…