Charles Hawkins

Random Number Generator

Often the RAND() function is predictable based on the seed. This stored procedure generates a pretty good random integer because the seed itself is quite unpredictable. You can’t put this in a UDF since it is indeterminate due to the RAND and GETDATE() functions used.

2006-09-15 (first published: )

580 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Transcation Log Backup Restoration Time

By Harshana-455711

Hi Is anyone know please advice, how much time will take for restoration 250GB...

Slimymed

By ouhgqabhugop

https takeapills com/slimymed-de/  

Update 22/01/2020 - ICQ678924920 => Sell Credit Card/DeadFullz/Gifts Card

By jack678924920

Hi guys! Call me Jack.. Update 22/01/2020 12:04 PM LIST CREDIT CARD AND GIFT...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers