He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!
2015-10-23 (first published: 2013-04-08)
29,524 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
2009-03-11 (first published: 2009-02-13)
1,652 reads
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
683 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
Hi All,II have a question on Transaction commit/rollback. Question My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles). For Example if i am doing a bulk copy of millions of records from a flat file on to sql server table, untill all the records are […]
2004-03-09
So where do you find this free Reporting tool? I found a trial edition but nothing that was totally free?
2004-01-29
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
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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