Viewing 15 posts - 1 through 15 (of 21 total)
Can't really see what you are trying to achieve. But the below will delete records based on your WHERE clause requirements
DELETE FROM X
FROM (
select Value, LEAD(Value) OVER (Order By Value)...
March 19, 2014 at 10:53 am
Thanks for the response. I tried clearing out the VS7Debug folder without success. I have also been through the steps from the link but to no avail.
I will have to...
September 13, 2013 at 2:54 am
Not used SQL 2000 for awhile but can you right click the DTS in question on the server then export as the dts file?
July 30, 2013 at 3:02 pm
I am encountering the same issue. The same batch takes 24x longer on one server than another.
The server configurations are the same as are the data sets. The execution plans...
October 19, 2010 at 9:47 am
I have the directory structure built by passing the data into a recordset then using a for each container to delete and build the folder as required.
Within this same script...
May 27, 2009 at 6:45 am
No problem Phil. It is sourced from the dataset ie it gets the folder structure from columns 1 & 2 and the filename from column 3.
May 27, 2009 at 2:55 am
The files will contain a text line for each row based on Column 3. I thought scripting it would be possible.
May 27, 2009 at 12:36 am
Thanks for the update Paul. Let me know how you get on with the longer tests as I am very interested to implement this solution on my current project.
May 17, 2009 at 12:56 pm
Hi Paul
Any news on the testing front? We are just at the planning stage of a project where speed is critical and any savings would be benefical. Solid state drives...
May 16, 2009 at 5:34 am
Yes I would agree the performance gains in taking the flat tables behind the view and then doing all the work on the destination server is significant especially when not...
April 26, 2009 at 10:09 am
To move the produser schema to dbo you will need to run the query ALTER SCHEMA
For the example above use
ALTER SCHEMA dbo TRANSFER produser.tbl1
Now you will be able to run...
February 23, 2009 at 1:33 pm
What is the query you are running - is it working on a large chunk of data? Try breaking it down from one large transaction to smaller ones
December 18, 2008 at 3:08 am
I thought a user CAL gave access to a SQL Server instance. With the CAL could you access Server1 close the connection then access Server2?
July 10, 2008 at 9:10 am
I have fixed the issue I was having. We had a security issue so I had to change the login for the connections in the DTS's. When saved the job...
August 23, 2006 at 9:34 am
Viewing 15 posts - 1 through 15 (of 21 total)