A lot of the time, the key to making SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethinking in terms of a set-based declarative approach. Joe takes a simple discussion abut a problem with a UDF to illustrate the point that ingrained procedural reflexes can often prevent us from seeing simpler set-based techniques.
2010-03-09
3,459 reads
2010-03-08
4,662 reads
2010-03-02
4,051 reads
Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.
2010-03-01
7,061 reads
2010-02-22
3,824 reads
Cleaning up garbage from data can be a big problem for a developer.Check out a simple solution from Shubhajyoti Ghosh to cleaning up garbage from data.
2010-02-22
9,987 reads
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.
2010-02-22
4,532 reads
2010-02-12
4,385 reads
2010-02-11
4,203 reads
2010-02-10
3,735 reads
By Brian Kelley
Recently, on a post celebrating a female professional earning a significant achievement within the...
By Rob Sewell
Four of our favorite new themes.
By John
Last Updated on September 24, 2024 by John Morehouse Years ago, I saw the...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers