2015-07-31 (first published: 2015-07-12)
1,420 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,742 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,078 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
286 reads
2008-12-12 (first published: 2008-11-19)
847 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,335 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,161 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
THREEMA-: KBKDHCXN , get dmt 5meo bufo toad venom here
THREEMA-: KBKDHCXN , kroosyann@gmail.com , WireID // DustID: 15107362652 , SignalID: yk15107362652.09 get dmt...
Volunteering SQL Server Skills
Apologies if this is the incorrect SQLServerCentral forum for this post, but hopefully someone...
Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
Question of the Day
Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers