Other SQL Server Blogs around the Web

Browse by Tags

• 823
• 8966
• advice
• best practice
• best practices
• blogs
• buffer pool
• checkdb
• CHECKDB From Every Angle
• corrupted
• Corruption
• data type
• database
• Database Maintenance
• dba
• defrag
• delete
• disaster recovery
• disk space
• diskkeeper
• error log
• file
• fragmentation
• hardware
• index
• internal error
• kba
• max worker threads
• Microsoft
• monitoring
• object
• page
• paul
• performance
• randall
• resources
• security
• server
• showcontig
• space
• sql server
• sqlperf
• sqlskills
• sysindexes
• system
• table
• testing
• transact sql
• tuning
• updateusage

• DBCC CHECKDB

  DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the... Posted May 14 2008, 05:15 AM by SSQA.net Filed under: sql server, dbcc, Database Maintenance

• What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

  Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best... Posted Mar 26 2008, 03:01 AM by SSQA.net Filed under: sql server, performance, disk space, dbcc, monitoring, best practice, defrag, showcontig, file, object, blogs, diskkeeper

• If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

  Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must... Posted Nov 15 2007, 09:41 AM by SSQA.net Filed under: sqlperf, sql server, performance, Microsoft, server, testing, dbcc, system, tuning, best practice, resources, max worker threads

• CHECKDB From Every Angle: How long will CHECKDB take to run?

  This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out... Posted Nov 14 2007, 10:22 PM by SSQA.net Filed under: performance, dbcc, disaster recovery, Database Maintenance, Corruption, CHECKDB From Every Angle

• FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Sep 19 2007, 05:21 PM by SSQA.net Filed under: sql server, error log, kba, dbcc, checkdb, buffer pool, internal error

• Advice and care you need to follow when you get a solution to your quest on SQL Server forums?

  Paul Randall has highlighted the importance of DBCC statements you execute within your SQL environment and care you need to take care when you get a solution for your question on the forums & newsgroups. Best advice is to test whatever has been specified... Posted Sep 15 2007, 05:56 AM by SSQA.net Filed under: sql server, dbcc, best practices, disaster recovery, advice, paul, sqlskills, randall

• Failed to claim unused space with SP_SPACEUSED?

  Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name... Posted Aug 31 2007, 04:09 AM by SSQA.net Filed under: sql server, database, dba, table, dbcc, space, transact sql, data type, delete

• Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

  This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level... Posted Aug 24 2007, 06:24 AM by SSQA.net Filed under: sql server, performance, security, table, fragmentation, dbcc, index, defrag, showcontig

• Error: Could not find row in sysindexes for database. 8966, 823 and 602

  Long ago, not long ago.... No doubt that many of you might have gone through the error above within your SQL environment, also I see many forum posts out there to resolve the issue. The bottom line of this issue is Hardware and no other issue can contribute... Posted Aug 14 2007, 04:35 AM by SSQA.net Filed under: sql server, performance, corrupted, database, table, hardware, dbcc, 823, sysindexes, page, checkdb, 8966

• How to get updated page or row count information for the current database?

  DBCC UPDATEUSAGE (0); GO Best practice to use DBCC UPDATEUSAGE i ntermittently and must if you have upgraded the database from SQL 2000 to 2005. The usual working fashion of this DBCC statement is to correct the rows, used pages, reserved pages, leaf... Posted Aug 13 2007, 09:00 AM by SSQA.net Filed under: sql server, performance, database, updateusage, dbcc