2010-07-22
3,535 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
2010-05-21
3,281 reads
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
2010-04-20
14,820 reads
Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
2010-03-03
8,772 reads
2010-02-19 (first published: 2008-12-05)
38,698 reads
2009-05-27 (first published: 2009-04-30)
2,600 reads
Using XML to Enhance the Performance of String Manipulations
This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.
2008-08-20
9,838 reads
Using XML to pass Multi-Select parameters from SSRS to SQL Server
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
2008-05-08
9,665 reads
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Database DevOps Metrics
Comments posted to this topic are about the item Database DevOps Metrics
Replacing a NULL II
Comments posted to this topic are about the item Replacing a NULL II
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers