InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:21:39 GMT20http://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxOn the other side... I have never run REPAIR_ALLOW_DATA_LOSS.Wed, 02 Jan 2013 19:46:22 GMTAlan.Bhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxCorrectly said Gail, these two were the DBCC commands which I had used a lot during those days and were really a blessing while looking for optimization. Though now there are new and efficient ways like using sys.dm_db_index_physical_stats (for DBCC SHOWCONTIG) and ALTER INDEX...REORG (OR REBUILD) (for DBCC INDEXDEFRAG)Wed, 02 Jan 2013 03:15:51 GMTsqlnaivehttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspx[quote][b]sqlnaive (12/28/2012)[/b][hr]Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.[/quote]Both of those were deprecated 7 years ago, are included only for backward compatibility with SQL 2000 and should not be used any longer.Fri, 28 Dec 2012 03:39:43 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxI definitely use DBCC INPUTBUFFER(spid) and DBCC OPENTRAN the most and at times DBCC SQLPERF. These are the most basic, effective and commonly used DBCC commands.Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.Fri, 28 Dec 2012 03:20:46 GMTsqlnaivehttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxIf you retain your backups for a week or more, running CheckDB just on weekends is fine. Just be sure that you retain backups (full and log) long enough that restoring from a backup is always an option if you do find corruption.Mon, 17 Dec 2012 01:25:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspx[quote][b]Hemant.R (12/17/2012)[/b][hr]hi ,i m executing DBCC checkdb on weekends for large database , bcoz its taking more time to execute .Need suggestion whether to execute daily..[/quote]Try using the PHYSICAL_ONLY clause during the week and full checkdb at weekendMon, 17 Dec 2012 01:07:57 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxhi ,i m executing DBCC checkdb on weekends for large database , bcoz its taking more time to execute .Need suggestion whether to execute daily..Mon, 17 Dec 2012 00:00:27 GMTHemant.Rhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspx[quote][b]SQLRNNR (12/14/2012)[/b][hr]DBCC CheckConstraints would be another useful command.[/quote]I hope people aren't having to use DBCC CHECKCONSTRAINTS all that often ;-)DBCC CHECKIDENT is one that comes to mind that I have seen become part of standardized processes although it probably should not have made it that far. It has many valid ad hoc uses, especially in production support and unit testing scenarios.Fri, 14 Dec 2012 11:59:45 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxDBCC Checkdb would be my vote for most frequently used - or at least should be very high on the list.DBCC updateusage DBCC CheckConstraints would be another useful command.Fri, 14 Dec 2012 09:20:09 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxI used to Use DBCC SHOWCONTIG quite a bit for looking at fragmentation but have replaced that with the SQL statements against DMV tables and functions, especially for partitioned tables.DBCC REINDEX or INDEXDEFRAG, but again i've switched to using ALTER INDEX WITH REBUILD/REORGANISE.DBCC ShrinkDB normally only after restoring to a db to dev environment with limited space or as an emergancy measure on a log file once its backed up if its very low on disk. Fri, 14 Dec 2012 07:56:45 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxDBCC CHECKDB would be one of the most common if you're smart ;-)Fri, 14 Dec 2012 06:37:00 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspx[quote][b]Hemant.R (12/14/2012)[/b][hr]DBCC shrinkfile(file_id ,size) to shrink file[/quote]I would certainly hope shrink isn't a 'most frequently used command', as one should not shrink database files without good reason.DBCC Inputbuffer can be mostly replaced with the sys.dm_exec_sql_text DMV.Fri, 14 Dec 2012 05:45:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxhi ,please check below link..http://blog.sqlauthority.com/2007/10/19/sql-server-types-of-dbcc-commands-when-used-as-database-console-commands/in this commands,most frequetly used command areDBCC INPUTBUFFER(Spid) to get query DBCC shrinkfile(file_id ,size) to shrink fileFri, 14 Dec 2012 04:53:12 GMTHemant.Rhttp://www.sqlservercentral.com/Forums/Topic1396578-1292-1.aspxHi All,This is Rangaraja.im fresher.Can anyone please explain mostly used in real time DBCC Commands?Regards,Rangarajarangarajasqldba@gmail.comFri, 14 Dec 2012 04:20:42 GMTbrangaraja