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,688 reads
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,200 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-03-28 (first published: 2008-01-18)
1,183 reads
2008-03-19 (first published: 2008-01-24)
3,555 reads
This procedure prepares a query for generating permutations of n-numbers set and executes it.
2008-03-18 (first published: 2008-02-04)
944 reads
2008-03-14 (first published: 2008-01-29)
1,257 reads
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,897 reads
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
924 reads
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)
649 reads
2008-02-27 (first published: 2008-01-21)
1,016 reads
I was asked to do a review of the book Microsoft Power BI Performance...
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Comments posted to this topic are about the item A Strange Result
First time here...hoping I can find some direction and answers so I can devise...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers