2015-07-31 (first published: 2015-07-12)
1,414 reads
Random Numbers
A More Versatile SQL Server Random Number Function
Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.
2015-04-02
10,277 reads
Raffle SQL Server Style
This article presents a possible solution to the raffle logistics employed in SQL Server user group meetings around the world.
2011-01-06
3,685 reads
Random problems
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
2009-06-09
5,071 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
282 reads
2008-12-12 (first published: 2008-11-19)
838 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.
2013-05-15 (first published: 2008-09-24)
3,326 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
2012-06-14 (first published: 2008-01-16)
1,114 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
I can query one by one. Need help how to become Single Query
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...
Baking up and restores VLDBs
Some of our databases are getting be close to 2 terabytes. We are backing...
Data Analysis with Python: Calculating Mean and Median
I'm working on a data analysis project in Python and need to calculate both...
Ask SSC