Following are couple of DBA must know commands. –Get the db details EXEC SP_HELPDB ‘Db_name’ –know the definition of the objects EXEC SP_HELPTEXT ‘object_name’ –Identify the size of database and table EXEC SP_SPACEUSED –Know the details of the disk drives EXEC MASTER..XP_FIXEDDRIVES —Quick view of SQL server sessions EXEC SP_WHO2 –It’s advanced version of sp_who2 but not shipped with SQL server.Get it from the following link. EXEC SP_WHOISACTIVE[…]
Read moreMonth: March 2017
Exam 70-461 Notes – Set Theory
Ordered list of returned result set is called Cursor. Without “order by” clause query doesn’t return results in particular order even[…]
Read moreSQL Server Tuning – Top 10 high memory consuming Queries
Problem Statement: Script to find top 10 high memory consuming Queries. Solution: SELECT TOP 10 Object_name(qt.objectid) AS ‘SP Name’, Substring(qt.text, ( qs.statement_start_offset / 2 ) + 1, ( ( CASE qs.statement_end_offset WHEN -1 THEN Datalength(qt.text) ELSE qs.statement_end_offset END[…]
Read moreAzure 70-775: Big Data Engineering with HDInsight
1) Administer and Provision HDInsight Clusters Deploy HDInsight clusters Create a cluster in a private virtual network, create a cluster[…]
Read moreSQL Server – Database Consistency Check DBCC CheckDB
Problem: How to check the consistency of a SQL Server database. Solution: DBCC checkdb WITH no_infomsgs, all_errormsgs; This Command can put overhead on the[…]
Read moreSQL Server Tuning: Quick overview of SQL Server performance using Activity Monitor
Question:How to get a quick overview of SQL Server performance. Ans: Use activity monitor in SSMS to get the quick[…]
Read moreSQL Server Tuning: Find Slow running queries using the Reports in SSMS
Find Slow running queries using the Reports in SSMS 1) High CPU consuming Queries: To run the report right click[…]
Read more
