The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
2009-01-29
840 reads
Articles
The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
2009-01-29
589 reads
2009-01-28
16 reads
Sample Chapter from Murach's SQL Server 2008 for Developers
Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a database table. In the process, you’ll master the basic skills that you’ll use in coding almost any SELECT statement, no matter how complex. At that point, you’ll be ready to learn how to code joins, summary queries, subqueries, and action queries, and then move on to working with server-side features like cursors and stored procedures.
2009-01-28
1,903 reads
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-28
520 reads
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-28
777 reads
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-28
535 reads
Creating Hierarchical Data Structure Mashups
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
2009-01-28
2,188 reads
Using CROSS JOIN queries to find records out of sequence
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
2009-01-28
4,596 reads
Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,359 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
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