Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
Give us all the features
The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should be simplified to only matter for hardware and scale, not features.
Maximizing SQL Server Throughput with RSS Tuning
Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.
TSQL Challenge 67 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the largest sequence of alphabets from a string.
Mimicking Network Databases in SQL
Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a generalized 'graph' structure that describes the relationships between the nodes. Nowadays, the relational model is used to solve the problems for which the network model was created, but the old 'network' solutions are still being implemented by programmers, even when they are less effective.
Webinar: Setting up a SQL Server sandbox development environment
Do you need to setup a SQL Server development environment in short order? Are you familiar with the options available? Are they all laborious? Are you facing security and data privacy issues? Do you have sufficient storage? Attend this information-packed session to learn about the best ways to build, manage and protect your sandbox development environment.
Does It Help
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
Stairway to MDX - Level 8: Member “Family” Functions: .LastChild and .FirstSibling
BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group with the .LastChild and .FirstSibling functions.
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers