2010-07-22
3,552 reads
2010-07-22
3,552 reads
2010-05-21
3,300 reads
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,943 reads
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
2010-03-03
8,888 reads
2010-02-19 (first published: 2008-12-05)
38,866 reads
2009-05-27 (first published: 2009-04-30)
2,627 reads
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,925 reads
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
2008-05-08
9,751 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers