One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their order is important. For example, values lying along a time line. The solution is actually quite simple, but not immediately obvious.
2008-04-10
4,439 reads
When you are trying to pin down the cause of a problem with a SQL Server, there is probably going to come a time when you need to get 'trace' information. If you've ever done that, you'll know how easy it is to get overwhelmed by the detail. Here, Shawn McGehee shows how to get round the problem by capturing trace information on a schedule, filtering the captured information, and monitoring it from a central location.
2008-04-09
2,451 reads
This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.
2008-04-09
6,335 reads
Different ways of passing sets of data between stored procedures.
2008-04-08
7,906 reads
There is not enough time in the day to keep it all straight! There is no shame in making use of any short cuts or cheats that allow you to be a more productive and well-versed SQL Professional in order to cope with the sheer volume of expectations you are required to meet on a daily basis.
2008-04-07
3,496 reads
Robyn Page and Phil Factor show how to use XML-based arrays to make string handling easier in SQL Server 2005/2007, and illustrate the techniques with some useful functions
2008-04-07
2,521 reads
This article details the steps to automate the generation of Sql profiler traces in a Testing environment. The facility is useful when an application is User Acceptance Testing phase where a bunch of test users logon to the Testing site and use the application.
2008-04-04
5,619 reads
Part I of this series illustrated how to use simple case functions in queries. This installment discusses how to use case functions in different types of scenarios.
2008-04-04 (first published: 2007-04-12)
10,572 reads
Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
2008-04-04
1,985 reads
Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?
2008-04-04
1,816 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers