Welcome to sensek.com

sensek.com web site provides free tips for technical help,handling interviews, plus careers advice n this web site we have given some technical tips for the following technologies and useful interview questions and answer to make you a successful candidate in the interview panel.

Also you can find some usefull information and tips for your IT carrier..

Technical Help Interview Tips DBA Tutorials
SQL Server DBA Oracle DBA DB2 DBA
Sybase DBA Windows AdminTips Unix Admin
MySQL Database VB Script Finace & Trade

DBA Technical Tips

Sql Server: DBCC Commands

The DBCC statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.

Database Console Command statements are grouped into these categories

Maintenance statements:

Maintenance tasks on a database, index, or filegroup.

  • DBCC DBREINDEX
  • DBCC DBREPAIR
  • DBCC INDEXDEFRAG
  • DBCC SHRINKDATABASE
  • DBCC SHRINKFILE
  • DBCC UPDATEUSAGE

Status statements:

  • DBCC INPUTBUFFER
  • DBCC OPENTRAN
  • DBCC OUTPUTBUFFER
  • DBCC PROCCACHE
  • DBCC SHOWCONTIG
  • DBCC SHOW_STATISTICS
  • DBCC SQLPERF
  • DBCC TRACESTATUS
  • DBCC USEROPTIONS

Miscellaneous statements:

Miscellaneous tasks such as enabling row-level locking or removing a dynamic-link library (DLL) from memory.

  • DBCC HELP
  • DBCC PINTABLE
  • DBCC ROWLOCK
  • DBCC TRACEOFF
  • DBCC TRACEON
  • DBCC UNPINTABLE

Validation statements:

Validation operations on a database, table, index, catalog, filegroup, system tables, or allocation of database pages.

  • DBCC CHECKALLOC
  • DBCC CHECKCATALOG
  • DBCC CHECKCONSTRAINTS
  • DBCC CHECKDB
  • DBCC CHECKFILEGROUP
  • DBCC CHECKIDENT
  • DBCC CHECKTABLE
  • DBCC NEWALLOC