2008-04-19 (first published: 2008-02-22)
3,869 reads
Scripts
Show all database's tables' columns' collations.
Created view displays all text columns' collations in the current database with the information whether
the collation is different from the database's one.
2008-04-04 (first published: 2008-01-22)
1,732 reads
Generating combinations 'm elements from n-element set'
This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.
2008-04-01 (first published: 2008-01-21)
1,214 reads
2005 Blocking Locks RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-03-28 (first published: 2008-01-18)
1,193 reads
2008-03-19 (first published: 2008-01-24)
3,570 reads
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)
961 reads
2008-03-14 (first published: 2008-01-29)
1,274 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,937 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)
933 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)
660 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers