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,497 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,631 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,749 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,335 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,948 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,455 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,199 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,424 reads
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Comments posted to this topic are about the item We Are Eating Our Own...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers