Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Test Data Rss

   Items 1 to 9 of 9   

Managing Test Data as a Database CI Component - Part 1

Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.  Read more...
By Additional Articles 2015/02/16 | Source: SimpleTalk | Category: test data
Rating:  Rate this |   Briefcase | 6,950 reads

Generating Dummy Data

A quick and easy way to generate test data for load testing.  Read more...
By Jamie Ingram 2013/08/22 | Source: | Category: cross join
Rating: |  Discuss |   Briefcase | 7,800 reads

Generating Test Data: Part 2 - Generating Sequential and Random Dates

Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.  Read more...
By Jeff Moden 2012/04/25 | Source: | Category: test data
Rating: |  Discuss |   Briefcase | 5,326 reads

Generating Test Data: Part 1 - Generating Random Integers and Floats

Learn how you can easily generate large amounts of test data efficiently in this new series from Jeff Moden. Part 1 covers integers and floating point values.  Read more...
By Jeff Moden 2012/03/26 | Source: | Category: data generation
Rating: |  Discuss |   Briefcase | 7,288 reads

Generating SQL Server Test Data with Visual Studio 2010

As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. So how you can generate test data or replicate similar data as in production for your development or test environment?   Read more...
By Additional Articles 2010/12/31 | Source: | Category: test data
Rating:  Rate this |   Briefcase | 5,450 reads

Generate Lots of Test Data with CROSS JOIN

“Joe Test” “Joe Test2? “Joe Test3? “Arrgh! There has got to be a better way to create some test data!” Ever had that conversation...  Read more...
By Joe Webb 2009/10/19 | Source: | Category: blogs
Rating:  Rate this |   Briefcase | 2,265 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: | Category: cursors
Rating: |  Discuss |   Briefcase | 605 reads

Test Data Generation with Data Dude

The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.  Read more...
By Additional Articles 2008/01/09 | Source: SQL Server Universe | Category: data dude
Rating:  Rate this |   Briefcase | 3,393 reads

Performance Tuning: Concatenation Functions and Some Tuning Myths

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...
By Jeff Moden 2008/01/01 | Source: | Category: test data
Rating: |  Discuss |   Briefcase | 15,638 reads
   Items 1 to 9 of 9   
data generation (3)    
random numbers (3)    
abs() (2)    
checksum() (2)    
rand() (2)    
advanced querying (1)    
blogs (1)    
cartesian product (1)    
cross join (1)    
cursors (1)    
data dude (1)    
performance tuning (1)    
random dates (1)    
t-sql (1)    
user defined function (udf) (1)    
visual studio (1)    
while loop (1)