Also, the query takes 8 seconds to run when I add the rest of the fields to it. Huge difference. The UNION did nothing at all for performance -- exactly the same. If this were the only query running for a particular web page, 8 seconds MAY be acceptable, however, it is one of many, […]
2004-02-10
Thanks for the reply. We are moving the direction suggestion already but this change has go through the regular release process and we wanted to understand what is happening with the current implementation until the modification can get to production.Does that mean I cannot trust OPENXML when participating in joins?
2004-02-02
Personally I would preprocess the data outside of sql then load.But if you want to use sql1. DTS the data into staging table (varchar columns as Mike suggested) including an IDENTITY column 2. Parse the data into rows of ColumnName,Data pairs (including identity) 3. Create table consisting of all columns 4. Insert.Update table with data […]
2004-01-30
Helder, Try creating a table with a single column VARCHAR(2000) and build the FTP command into a string and then INSERT that string into the table you just created.You can then review the information that you are passing into the FTP command and see where it is going. I agree with you that the problem […]
2004-01-29
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-26
Use just like a regular table in SQL2K...select * from OpenQuery(AS400, 'select * from "F.M.AS400Table" ') AnAS400TableAliasInsert into OpenQuery(AS400, 'select fld1 from "F.M.AS400Table" ') AnAS400TableAliasSelect QSL2kFld1 From SQLTable Notice AS400 query was DoubleQuotes around the AS400 table since smoe of your tables on AS400 side might be name/qualified that way.Did not use DTS.
2004-01-20
1 reads
Hi,Can we have SQL Server Standard Edition and Developer Edition on the same box? We are thinking of running SQL Server Developer edition (for development) instance along with SQL Server Standard Edition (for contingency) instance on Contingency BOX.Are there any precautions we need to take if we need to run the above mentioned way?Also I […]
2004-01-20
Have you checked the use of CHECKSUM_AGG?With it, you can calculate a checksum over a complete table or a column. Don't know if it is possible to calculate one over a recordset...Obviously, if the Checksum is the same, your recordsets are identical.
2004-01-20
1 reads
alter or create need to be the first thing in the batch. I typically always drop and recreate, but I keep the security with the code.
2004-01-16
1 reads
I have a tab delimited file that is not relational. I need to split each row in the file into two relational tables. The tab file looks like this: name otherinfo grade1 grade2 grade3 grade4 What I need to do is sep. name and otherinfo into one table, stamp a unique recordID number on it […]
2004-01-06
3 reads
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...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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