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)
929 reads
Rafal Skotak
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)
852 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)
918 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)
639 reads
2008-02-27 (first published: 2008-01-21)
1,008 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,260 reads
2008-01-14
968 reads
Generating number sequences
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
895 reads
Blogs
Daily Coping 15 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Another One Bites the Dust - PASS is Gone, so...What Now?
There has been a lot of noise over the last few weeks since it...
SQL Server Linux
By Arun Sirpal
If you have come from a windows background you may be curious about the...
Forums
DB corruption error 8905, fixed using repair_allow_data_loss ,
hi all, I need some help here. Recently, I've found a db with error...
alternative to temp tables with 3M+ records and growing
I'm struggling with the performance of one of my stored procedures. Depending on the...
Ask SSC