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 moreTag: sql server
SQL Server:Write on “???” failed: 1453(Insufficient quota to complete the requested service.
Error:Write on “???” failed: 1453(Insufficient quota to complete the requested service. solution: Restrict the max server memory setting of the[…]
Read moreSQL Server -Find Nth Highest Salary
Problem: Find Nth highest salary in Minimal time. Solution: Interviewer often asks to find Nth Highest Salary in an interview. Many solutions are available on[…]
Read moreSQL Server -Window XP useful commands for DBA
run>msinfo32 It gets the system information like OS, version name, components and many more. run>sqlservermanager11.msc Opens the SQL server configuration[…]
Read moreSQL Server -Find currently Running jobs
If you want to find the currently running jobs then following queries will help you. List All Currently Running SQL[…]
Read moreSQL Server 2005 -Trouble Shooting Client To Server Connection
Applies on : SQL Server 2005 and above Tested on : SQL Server 2005 1). Check Server Property: 1.1 Right[…]
Read more
