2010-07-22
3,545 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
2010-05-21
3,295 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,883 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,849 reads
2010-02-19 (first published: 2008-12-05)
38,805 reads
2009-05-27 (first published: 2009-04-30)
2,617 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,889 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,725 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers