Here is the original and another method.It works from 1743 to 9998Steve Declare @Year_Begin as int, @Year_End as int, @IndependeceDay as char(10), @DayofWeek as char(10)If exists (select * From dbo.sysobjects Where id = object_id(N'Independence')) Drop Table IndependenceCreate Table Independence ( Four_of_July varchar(10), Day_of_Week varchar(10)) Set @Year_Begin = 1753 Set @Year_End = 9998While (@Year_Begin […]
2004-11-05
If you can add one more column to your table than: create table FIFO(xxx,xxx,xxx, GUID uniqueidentifier) declare @GUID uniqueidentifier set @GUID = NewID() INSERT INTO FIFO ( xxx,xxx,xxx,xxx, GUID  VALUES( xxx,xxx,xxx,xxx, @GUID  // Insert recordSELECT UID AS Value FROM FIFOwhere GUID = @GUID // Get the UID of the record just inserted It works much faster than using temporary table, especially if […]
2004-08-30
Would executing a transaction log from several days of prod activity against the test database work to simulate this load? Just a thought. I'm still confused on how to simulate the traffic since there are updates/inserts/deletes.
2004-08-30
And look at the explanation:"You need to remove the existing data, using the Excel automation model, copying a blank spreadsheet onto the target spreadsheet, or executing a drop table, create table on your spreadsheet.""Copying a blank spreadsheet" means not removing data from a spreadsheet but removing old spreadsheet and replacing it with new (empty) one. Than […]
2004-08-18
You were in the process of moving WHAT files? And how were you trying to move the files?-SQLBill
2004-03-17
I am getting an error trying to update a table in DB2 via SQL Server using a Linked Server. I can query the table using OPENQUERY but not via four-part name.I can do this...SELECTSelect * from OpenQuery(db2link, 'Select frst_nm from yccfssc9.person where id_prsn = 2')When I try to Query using four-part names I get the following […]
2004-03-12
119 reads
Discover the script section here. There are several scripts for finding duplicates.
2004-03-02
Haven't used it, but these guys (http://www.easysoft.com/products/2002/lotus.phtml) have an ODBC driver.
2004-01-23
Paul, It doesn't work, and unfortunately I can't correctly detach it since it does not show up as existing at this point.
2003-11-13
2003-08-28
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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