SQL SERVER

Below I have listed some frequently used objects.

USEFUL TABLES AND VIEWS

1. master..sysperfinfo
2. <db>..sysindexes
3. master..sysprocesses
4. syslogins
5. sys.messages
6. sys.dm_exec_requests
7. sys.dm_exec_sql_text
8. sys.dm_exec_connections
9. sys.dm_db_index_physical_stats
10. sys.dm_db_missing_index_groups
11. sys.dm_db_missing_index_details
12. sys.dm_db_missing_index_group_stats
13. sysindexes – Using this you can count the rows in a table faster. make use of below query.
    

     select rows from sysindexes
     where id= OBJECT_ID('tablename') and indid < 2

USEFUL STOREDPROCS

1. sp_spaceused
2. sp_helpdb
3. sp_helpfile
4. sp_change_users_login
5. sp_changedbowner
6. sp_readerrorlog

USEFUL FUNCTIONS

1. fn_virtualfilestats()

USEFUL LINKS

1. Port numbers a DBA should know.
2. SQL Server DBA Interview Questions.