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,197 reads
This procedure prepares a query for generating permutations of n-numbers set and executes it.
2008-03-18 (first published: 2008-02-04)
935 reads
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
923 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)
645 reads
2008-02-27 (first published: 2008-01-21)
1,011 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,262 reads
2008-01-14
971 reads
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
902 reads
By Steve Jones
Today’s coping tip is to discover your artistic side. Design a friendly greeting card....
So, we made it through our first 90 days, things start getting tougher now...
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...
In Transactional Replication, create index and Alter index commands do not get replicated to...
Comments posted to this topic are about the item The Last Valid Restore Time
Comments posted to this topic are about the item Getting started with ROUND() and...
Ask SSC