As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.
2003-12-19
9,490 reads
Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.
2003-12-03
7,630 reads
Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!
2003-11-28
16,707 reads
New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.
2003-11-20
10,319 reads
New Author! The first of two articles this week on fill factors, this article looks at the impact fill factor can have on performance and shows you the key tools and counters you use to assess the impact of changes to fill factor.
2003-11-19
25,938 reads
Troubleshooting performance problems takes a lot of time and work. This article outlines the process the author uses - pretty interesting.
2003-09-04
7,453 reads
Randy starts a multiple part series on tuning queries. We've asked Randy to really start from scratch and walk through the process. This week he takes a look at viewing query plans in Query Analyzer.
2019-11-11 (first published: 2003-08-19)
26,136 reads
This is a follow up article on the database comparison they did about 18 months ago.
2003-07-24
604 reads
This is a performance analysis and tuning application. Visit the site to get to more info, they also have a free book on performance tuning (registration required). (Not reviewed)
2003-06-12
786 reads
Vicktor has a bunch of scripts he uses to monitor performance, he explains why he built them and how to use them. Good coverage of the different reasons for slow performance.
2003-06-09
16,419 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers