Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- Diagnosing SQL Server performance issues using sp_lock
- A common misconception among IT pros is that "locks arebad," and you must do everything possible to ensure database lockingdoesn't prevent processes from running. In order to ensure a consistentdatabase environment, the database engine must use a mechanism to acquireexclusive use of a resource when that resource is being modified.SQL...
- Tags: database, lock, Microsoft SQL Server, performance, Tim Chapman
- Technical articles 2006-06-26
Additional Resources
- How Can I use the RMAN to recovery Oracle9i ?
- How Can I use the RMAN to recovery Oracle9i ?good answer can somebody help me? thank uRMAN>startup nomount;RMAN>set dbid=RMAN>alter database mount;RMAN> restore database;RMAN>recover database;RMAN>alter database open resetlogs;This question was closed by the author
- Tags: houxf@..., linux, RMAN, Oracle9i
- Q&A 2006-01-16
- (Photos: Fujifilm flirts with the frugal)
- devil is in the detailsThe fuji camera looks like a price point breakthrough, but the details are very important, such as . . Does the camera line include Video with sound? Is there external light support?Does it use USB memory or connectivity?Sound with video, yes. USB Connectivity, yesExternal light support,...
- Tags: camera, daarka@..., fuji, still, feedback, avi, digital, details, photograph
- Discussion threads 2007-03-01
- Monitor query performance with the SQL Server 2005 procedure cache
- In SQL Server 2005, you only need to recompile the statements inside stored procedures. This is much different than SQL Server 2000, where the entire procedure or batch may be recompiled. The benefit to the statement level recompile in SQL Server 2005 is that typically just a few statements inside...
- Tags: Monitor, Procedure, Performance, Microsoft SQL Server, Statement, Database Engine, Microsoft SQL Server 2005, Execution Plan, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-01-17
- 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
- Find blocking processes using recursion in SQL Server 2005
- Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set or subset of records. This causes the second process to wait until the first process is done so it can acquire the records; this...
- Tags: Process, Microsoft SQL Server, Statement, Information, Microsoft SQL Server 2005, #Processes, BlockingSPID, SELECT, RowNo, LevelRow, usp_StoredProcedure3, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-01-28
- Undocumented tips for restoring your SQL 6.5 master database
- Worried about what could happen if you lost your SQL 6.5 master database? Learn how to restore it properly with these undocumented tips from Mark Solomon.If you’ve never designed and implemented a disaster-recovery strategy for your structured query language SQL server, it's not too late to start. I have a...
- Tags: Databases, Storage, Mark Solomon, database, SQL, Microsoft SQL Server 6.5, Microsoft SQL Server, master database
- Technical articles 2000-04-18
- Write your own sp_lock system stored procedure in SQL Server 2005
- The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock...
- Tags: Procedure, Microsoft SQL Server, Statement, Information, Session, Microsoft SQL Server 2005, LEFT JOIN, Sql_handle, sp_LockDetail Example, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-01-07
- << Previous
- page 1 of 1
- Next >>
