Viewing 15 posts - 2,536 through 2,550 (of 3,667 total)
In general I agree with this article but there is one massive BUT that has been overlooked here and that is performance.
I have a database where the design of the...
January 17, 2006 at 5:18 am
I have a similar requirement for a date changed Excel file. There are several ways of doing it but I put an ActiveX task as the first step...
January 17, 2006 at 2:13 am
Because of the limitations of the FTP task I resorted to using a Windows CMD file to execute the FTP commands I needed and called these using an Execute Process...
January 16, 2006 at 5:09 am
The idea is that you get a performance boost however in most small to medium installations the extra administrative hassle just isn't worth it.
The theory is that searching an index...
January 13, 2006 at 12:00 pm
Our apps are .NET and C++ based so we use NUNIT to devise a long list of test scripts. Come service pack time we simply rerun the NUNIT...
January 13, 2006 at 6:16 am
You should have
an Icon for a server that represents you connection to your SQL Server.
An Icon for your text file that represents you CSV file.
A connecting line between the...
January 12, 2006 at 10:39 am
Are you allowed to change your database recovery mode to BULK LOGGED?
January 12, 2006 at 4:33 am
DTS's can be as simple or as complex as you want.
You can import/export from/to a variety of different sources. For example, I had a datawarehouse that needed to almagamate...
January 11, 2006 at 12:29 pm
Just for the sake of testing change your INSERT INTO query to SELECT INTO TestTable
That way
INSERT INTO MarketRiskdev.dbo.Import_Argentina
SELECT * FROM TestTable
should work. If it doesn't you will be closer...
January 11, 2006 at 12:01 pm
bcp is very fast at extracting or importing data.
As Data Transformation Services suggest they can do just about anything you want to data. DTS includes a specific task that...
January 11, 2006 at 11:57 am
I'm just wondering why you are using SQL Query Analyser to do this?
Is is just for a quick one off?
If you have to do it more regularly then consider using...
January 11, 2006 at 11:54 am
Recognition, visible results, the desire to fund a decent mid-life crisis.
January 11, 2006 at 5:50 am
Within SQL Query Analyser make sure that under Tools/Options/Results you have the following settings
Default Results Target : Results To File
Results Output Format : comma delimited
Print Column Headers : Checked
Putting the...
January 11, 2006 at 5:49 am
My point about removing the INSERT was to prove that the XML shredding actually works and could come back as a recordset.
If this was the case the chances are that...
January 10, 2006 at 3:33 pm
Put it this way, you have sat for 15 years in front of a cathode ray gun.
When I was at college in the 1980s one of our tasks was to...
January 10, 2006 at 1:27 am
Viewing 15 posts - 2,536 through 2,550 (of 3,667 total)