December 27, 2008 at 12:50 pm
Today somebody told me DBCC commands are old and I should not use them! I was very surprise because I use it all the time! This DBA is more experience and tell to me that it is old technology and better to use SYS schema objects. I try to read books online about them(SYS schema objects) but I don't understand anything :w00t:
Is it true that it is old technology that should not be used and why is it so? I am very use to DBCC!
December 27, 2008 at 1:27 pm
Well, DBCC certainly is old. Some of the commands have been around since SQL 6, but then that's true for a select statement too.
Many of the DBCC statements are deprecated in SQL 2005 and higher and will be removed in a future version. Not all of them though. Check in Books Online for the specific ones you're using and see if they are deprecated and, if so, what the replacement is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 27, 2008 at 2:14 pm
You can also use SQL Profiler to track down deprecated features. Add the "Deprecation Announcement" event class in a new trace and let that run for awhile. It may even show you what the alternatative recommendation is, for example for DBCC DBREINDEX it will show to use ALTER INDEX.
December 27, 2008 at 6:35 pm
hmmm interesting info here ... what about Identity columns if you want to reseed ... or check the identity value ...do we have any other possibility such as DBCC checkident isn't it!?
December 27, 2008 at 6:48 pm
Not all DBCC commands have been deprecated or given an alternative. I don't think reseeding can be done another way, but I'd like to see this added to ALTER TABLE.
The DBCC syntax is a little old, and not intuitive.
December 28, 2008 at 12:43 am
Dugi (12/27/2008)
...do we have any other possibility such as DBCC checkident isn't it!?
Does your copy of Books Online say that CheckIdent is deprecated?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2008 at 6:34 am
GilaMonster (12/28/2008)
Dugi (12/27/2008)
...do we have any other possibility such as DBCC checkident isn't it!?Does your copy of Books Online say that CheckIdent is deprecated?
Simple ...NO! - I don't have info for what next if MS has other way for some of DBCC commands!
December 28, 2008 at 7:21 am
Dugi (12/28/2008)
GilaMonster (12/28/2008)
Does your copy of Books Online say that CheckIdent is deprecated?
Simple ...NO!
If it's not marked as a deprecated feature (which, if you check, DBCC DBReindex and DBCC ShowContig are) then it's not been discontinued.
Not all of the DBCC statements are been replaced. The ones that are are documented as deprecated and will fire deprecation events to a profiler trace (if one is running)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2008 at 8:40 am
even better, BOL now contains more info on DBCC statements then ever !
No yet for all, but for the most of them you'll ever use.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply