2008-03-19 (first published: 2008-01-24)
3,596 reads
Scripts
Generating permutations - procedure
This procedure prepares a query for generating permutations of n-numbers set and executes it.
2008-03-18 (first published: 2008-02-04)
1,027 reads
2008-03-14 (first published: 2008-01-29)
1,293 reads
Trim Trailing Blanks in SQL Queries
Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.
2008-03-10 (first published: 2008-01-09)
2,966 reads
Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2008-03-06 (first published: 2008-01-24)
1,014 reads
Db files size per directory
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
947 reads
Random varchars
This procedure generates a list of random varchars (8 charactes length, only letters - lower or upper case).
2008-02-28 (first published: 2008-01-14)
687 reads
2008-02-27 (first published: 2008-01-21)
1,082 reads
2008-02-25 (first published: 2008-01-15)
948 reads
Sorted views in 2005 and TOP clause
These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.
2008-02-22 (first published: 2008-01-22)
1,344 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers