<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Development
,
Miscellaneous
Items 1 to 5 of 5
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,177 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
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
864 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2000
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
Read more...
By
Jesse Roberge
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
442 reads
An Auditing Solution with XML And XSL
Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.
Read more...
By
David McKinney
2007/08/20
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
4,954 reads
Fixing SysDepends
Have you been burned by sysdepends at some point in your SQL Server DBA career? Steve Jones has many times, but a FREE new utility ends all that.
Read more...
By
Steve Jones
2005/09/22
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
9,636 reads
Items 1 to 5 of 5
Tags
sql server 2005
(4)
t-sql
(4)
advanced querying
(3)
nums
(3)
sqlinsider scripts
(3)
table of numbers
(3)
tally
(3)
counter
(2)
table
(2)
prime
(1)
prime number
(1)
security
(1)
sieve
(1)
sql server 7
(1)
strategies
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
