2015-07-31 (first published: 2015-07-12)
1,414 reads
2015-07-31 (first published: 2015-07-12)
1,414 reads
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
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
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
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
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
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
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...
Some of our databases are getting be close to 2 terabytes. We are backing...
I'm working on a data analysis project in Python and need to calculate both...