Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
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.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
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.
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.
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.
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers