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
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
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
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
918 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)
639 reads
2008-02-27 (first published: 2008-01-21)
1,008 reads
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
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
895 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
There has been a lot of noise over the last few weeks since it...
By Arun Sirpal
If you have come from a windows background you may be curious about the...
hi all, I need some help here. Recently, I've found a db with error...
I'm struggling with the performance of one of my stored procedures. Depending on the...