Clipmarks - Dbcc Clipmarks

1
POPS SQL Server 2005 List all IDENTITY columns

by Osolage 12-12-2007

When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.

0
POPS You can use sp_MSforeachtable undocumented stored procedure to

by guercheLE 8-15-2007

No Remarks

1
POPS DBCC DROPCLEANBUFFERS

by Osolage 6-7-2007

I saw one of my colleagues using this procedure. I haven't used it myself, but I think I'm about to start experimenting with it. I think the part about executing a CHECKPOINT first makes sense.

1
POPS SQL Server 2005 equivalent to DBCC MEMUSAGE

by Osolage 5-31-2007

No Remarks

1
POPS Use fn_get_sql instead of DBCC INPUTBUFFER

by Osolage 5-14-2007

This is going to help quite a bit as we are getting into evaluating performance and concurrency issues.

0
POPS DBCC CACHESTATS

by Osolage 5-10-2007

One of my colleagues was using this. I had never come across it before. Thought I'd read up on it a little bit.

0
POPS DBCC SHOWCONTIG WITH TABLERESULTS

by Osolage 4-5-2007

No Remarks