Cathan Kirkwood

Started working with databases in 1984. Clients have kept pushing me into front end programming over the years, giving me a widely varied background in VB, ASP, HTC, SQL, DHTML, COM, RPG, Cobol, Fortran (how many people know what .HTC is anymore...grin). I've worked with SQL Server in particular since version 4.2 was released. I've worked with DB2, AS\400's, Sybase, Oracle, Informix, Alpha4 & 5, Access (all versions to date.) (Boy, I almost didn't even mention that one.), and a lot of databases which people still debate as to whether they were even databases or not. Hold a lot of different certificates I got before I realized how little they matter.

How to Diagnose and Fix Wait Locks

by Cathan Kirkwood

SQLServerCentral.com

Administration

This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2002-11-21

36,113 reads

Discuss

Blogs

Monday Monitor Tips: Finding the Hostname for Queries

I was chatting with a customer recently and they wanted to know which host...

Can AI Read Execution Plans?

By Grant Fritchey

Yeah, yeah, second AI post in a row. I promise not to make a...

Streamline Dependency Management in Databases

In the intricate world of business, where precision and efficiency are paramount, managing database...

Read the latest Blogs

Forums

SSIS Won't Create Log Entries

Hi everyone My SSIS package will not log to sysssislog. I am not sure...

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Understanding CROSS APPLY and OUTER APPLY in SQL Server

Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers