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)
31,367 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
7,113 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
10,032 reads
2009-03-11 (first published: 2009-02-13)
1,665 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
687 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
This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...
This article describes the steps you take to prepare the VMware infrastructure for installing...
Hi, I have a SQL query below in which i need to be...
Comments posted to this topic are about the item A week in Seattle in...
Hi All, We are deploying website by using windows authenticated user. It is default...
Ask SSC