Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Content with tags
Advanced Querying
,
nums
,
SQL Server 2005
,
Miscellaneous
Items 1 to 2 of 2
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
Read more...
By
Jesse Roberge
2009/07/15
|
Source:
SQLServerCentral.com
|
Category:
advanced querying
Rating:
|
Discuss
|
Briefcase
|
1,263 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2005
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.
Read more...
By
Jesse Roberge
2008/08/05
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
894 reads
Items 1 to 2 of 2
Tags
development
(2)
sqlinsider scripts
(2)
table of numbers
(2)
tally
(2)
t-sql
(2)
counter
(1)
prime
(1)
prime number
(1)
sieve
(1)
table
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.