Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Get out of a jam by using SQL Server's DBCC
- DBCCTo perform DBCC is it necessary that the DB should be in 'Single-User-Mode'. If is it so why? Can anyone justify it?Regards,G.Rajamurali.DBCCIts not necessary for the DB to be in single user mode to run DBCC, it is necessary for the
- Tags: DBCC, grajamurali@..., Microsoft SQL Server, security, server, software
- Discussion threads 2007-01-02
- Get out of a jam by using SQL Server's DBCC
- Arthur Fuller reveals why you should get to know the database consistency check DBCC. He also explains how to run DBCC and how to use five of its extensions. In moments of distress, the database consistency check DBCC may prove to be your most valuable friend. This tip...
- Tags: Microsoft SQL Server, DBCC, Arthur Fuller, Storage, Databases, server, database, SQL Server Newsletter, TechRepublic Inc., Index, Argument, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-12-21
Additional Resources
- Avoid output message when using Trigger
- I created a trigger for delete on my table. When a user try to delete an item, several processes are lunched, and I don't want this processes to output. When the user try to delete a row, he got a result like (1 rows affected)(2 rows affected)(0 rows affected)Is it...
- Tags: Avoid DBCC, trigger avoid output, werewolf_@..., software, identity
- Discussion threads 2006-08-31
- How to show senior (non IT) managers what performance gains they can get
- Right get ready to laugh but my company has 10 2000 SQL servers but no DB, or in fact anyone approaching a DB. SO I have taken it on myself to have a look around having had some experience before, But please go easy on the answers as my SQL...
- Tags: Performance management, edward@..., performance
- Discussion threads 2007-11-01
- Inserting specific values into identity columns
- Setting the next index valueYou may also want to execute DBCC CHECKIDENT to check then set the next identity value if you plan to insert new rows.
- Tags: Value at Risk, techr@..., one more thing, software
- Discussion threads 2005-07-14
- dbcc logical scan
- I have a database on sql server 2000 sp4. Not long ago I had something wrong with my transaction log and the DB went into "suspect mode". Microsoft showed me basically how to destroy the transaction log and rebuild it. I didnt loose any data, everything had already been commited....
- Tags: Databases, fragmentation, Avg
- Discussion threads 2005-12-29
- Renaming/Removing extended system extended stored procedures
- Hi.Can someone please point me in the right direction for rendering a list of system extended stored procedures? I've tried using sp_rename, drop procedure, sp_dropextendedstoredproc and dbcc dropextendedstoredproc. All to no avail.I've tried creating a user that is a memeber of the sysadmin and securityadmin sever roles, and...
- Tags: craigh@...
- Discussion threads 2007-09-25
- Two SQL Server maintenance tips to help you service like a pro
- By Kaye GartenSure, database maintenance is usually left to the “DBA guys,” but occasionally as a developer you’ll be pressed into service. So, try out these two SQL Server maintenance tips and learn to change database owners and defrag your indexes with ease. Who knows? You could even teach those...
- Tags: Storage, Databases, Guest Contributor, server, database owner, database, ISUser1, ISUser2, Microsoft SQL Server
- Technical articles 2003-01-10
- MS SQL Maintenance Plan Help!
- I’m trying hard to figure out what the write way of managing our SQL server is. We have sporadic success. Sometimes the jobs work sometimes they do not.We would like to implement an effective MS SQL Maintenance Plan. Should we use the wizard or something else, not sure?Sorry if this...
- Tags: cd2041@..., DBCC CHECKDB, Help, job, Maintenance, maintenance plan, MS-SQL, Plan, software, sql maintenance plan
- Discussion threads 2005-08-10
- TechNet Webcast: Data Recovery in SQL Server 2005 (Level 200)
- This webcast covers troubleshooting methods and tools in Microsoft SQL Server 2005 that one can use to recover from various scenarios. Topics include database access problems, such as the database being marked as suspect during recovery; backup and restore failures; database runtime consistency failures, such as checksum; and DBCC CHECKDB...
- Tags: Data Recovery, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Microsoft TechNet, Storage, Databases, Digital Media, Hardware, Enterprise Software, Software, Data Management, Consumer Electronics, Personal Technology
- Webcasts
- Track down deadlock errors with the SQLDiag utility
- SQLDiag, introduced in SQL Server7.0, is a very handy SQL Server utility that you can use to monitor yourdatabase server for problems. It is a command-line tool that was created toprovide necessary information for Microsoft customer support calls. When run,the tool outputs data from different SQL Server utilities into a...
- Tags: database, deadlock, Microsoft SQL Server, server, SQLDiag, Tim Chapman
- Technical articles 2006-09-18
- MSDN Webcast: Secrets to Fast Detection and Recovery From Database Corruptions (Level 400)
- It is all about limiting downtime and data loss when a corruption occurs, from knowing the tools, to understanding the choices, to planning a successful strategy. Some of the features discussed in this webcast are torn-page detection and page checksums, IO read-retry, backup checksums, consistency checks (DBCC CHECKDB and related...
- Tags: Microsoft Developer Network, Recovery, Webcast, Corruption, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Webcasts
- SSMS++ (exe)
- SSMS++ extends the management studio to give the DBA the features that let them run context sensitive critical DBCC commands. From the familar SSMS gui create, view and edit DDL/DML triggers as well as the full range of Service Broker objects (Message Types, Contracts, Queues, Services, Routes and Remote Service...
- Tags: Database Administrator, SSMS++
- Software downloads 2008-02-13
- Daytona Beach Community College Saves Money While Delivering Advanced Services to Students, Staff
- Daytona Beach Community College DBCC was the first comprehensive community college to be established in Florida. As the college grew, its communications network accumulated products from several different manufacturers. By the late 1990s, users were suffering from poor performance and reliability. Daytona Beach Community College migrated to a Cisco Systems...
- Tags: Network, Cisco Systems Inc.
- Case studies
- MS SQL 2000 Database
- Would appreciate info on whether we can perform compact on a MS SQL 2000 database? if so, how can this be done? Thanks.You should be able to tell SQL Server to do that automatically. Open SQL Server Manager and go to the database you want to compact. Right-click...
- Tags: Storage, Databases, database
- Q&A 2004-11-03
- Diskeeper Can Boost Your SQL Server's Performance
- One of the biggest hardware bottlenecks of any SQL Server is disk I/O. And anything that a DBAs can do to reduce SQL Server's use of disk I/O will help boost its performance. Some of the most common things DBAs do to reduce disk I/O bottlenecks include; Tuning queries to...
- Tags: Disk, Performance, Microsoft SQL Server, I/O, Server, Diskeeper Corp., Databases, Enterprise Software, Software, Data Management
- White papers 2005-01-10
- Diagnose SQL Server performance issues using sp_lock
- A common misconception among IT pros is that "locks are bad," and you must do everything possible to ensure database locking doesn't prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use of a resource when that...
- Tags: Procedure, Performance, Microsoft SQL Server, Lock, Locks, Spid, Dbid, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-03-31
- TechRepublic Tutorial: Troubleshooting Microsoft SQL Server 2000 installations
- Microsoft SQL Server 2000 installationsThe database server is the heart of information storage for the enterprise, so you must take special care in managing this critical resource. When a problem arises, you must address it quickly, efficiently, and correctly, or an organization stands to suffer critical losses. In this Daily...
- Tags: Backups, Databases, Enterprise software, Storage, Scott Lowe MCSE, database server, Microsoft Corp., Microsoft SQL Server 2000, backup, Microsoft SQL Server, database
- Technical articles 2002-08-22
- 10 common SQL Server problems and solutions
- This list outlines 10 common SQL Server problems and solutions. This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From "Out of Space" errors to a database going suspect, this list is great quick reference for every SQL administrator.Here's a sample:Number...
- Tags: Microsoft SQL Server, Problem, Server, Databases, Enterprise Software, Software, Data Management
- Download resources 2005-12-14
- Tips on optimizing your SQL Server indexes
- Proper indexing is a major factor in performance tuning your SQL Server database. Follow these tips to get your applications in tiptop shape.Within SQL Server there are several tools that you can employ to monitor, tune, and optimize performance. Here, I will explain how to utilize and interpret the results...
- Tags: Databases, Enterprise software, server, Microsoft SQL Server, fillfactor, data page
- Technical articles 2002-12-17
- << Previous
- page 1 of 1
- Next >>
