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.
2012-04-25
6,860 reads
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.
2012-04-25
6,860 reads
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.
2012-03-26
9,790 reads
Something like this..CREATE TABLE SSNTemp ( SSN char (10) NOT NULL ) CREATE UNIQUE INDEX [IX_SSNTemp] ON SSNTemp ([SSN]) WITH IGNORE_DUP_KEYinsert into SSNTemp select ssn from yourssntable delete from yourssntableinsert into yourssntable select ssn from SSNTemp
2004-08-12
In the Cube Drillthrough Options screen, on the Columns tab, you should see all of the columns contained in all of the tables used in your model. Assuming you have only 2 tables, a fact and a single dimension, the columns may be something like COLUMN TABLE fkCol1 tblFact fact1 tblFact fact2 tblFact pkCol1 tblDim1 […]
2003-11-28
quote: ...if you placed a GO between the Alter and the Select... True in this contrived example but not if the intention was to use it in a procedure.
2003-11-26
2 reads
the user that you want to change the sql service account need to be a user at a minimum at your local box. mom
2003-11-20
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers