Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?
SQL Saturday is coming to Madison, Wisconsin on April 11th 2015. Join us for a free day of SQL Server training and networking and hear expert speakers like David Klee, Wendy Pastrick, and Jes Borland. Register while space is available.
Learn how to set colors for different connections in SSMS.
Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
Robin Shahan introduces the concepts of snapshots in relation to Azure blob storage. She explains what they're for and how to take them, promote them, and delete them.
Redgate are hosting a 1-day public workshop on April 10th 2015 in Los Angeles, California. This workshop will teach you how to link your source control system to a build system, trigger database builds automatically, and lay the foundations for package-based deployments.
This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.
How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.
What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of compliance? William Brewer argues that if the objective is rapid delivery of applications, then compliance controls must be understood as early as possible in development.
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
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...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers