If you want to remove all the data from a table, use TRUNCATE TABLE because its damn fast. The transaction log will just contain the TRUNCATE TABLE command.If you use DELETE FROM then the transaction log contains a record for EVERY ROW in the table, a slower process.
2004-08-20
Hi, I need to write a DTS that is able to read a file that can have different format. E.g., I have a CSV file created by the Performance Monitor (it is a counter log) on a server running Windows 2003 (64-bit) that I need to load to a SQL Server table. This process has been running […]
2004-08-18
1 reads
That's why I was suggesting the openrowset, because what you do is force sqlserver to make the inner join instead of coding it yourself (which is exponentially slower as you add records in the tables... and even slower because ado is object based and not sql based). As for the execution method I'm really no […]
2004-08-17
Yes, this can be done.You need to have the OLEDB provider for Exchange and create a remote server connection to Exchange from SQL Server. start here:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_wss.asp
2004-08-11
Very undocumented... select * from syscolumns where colstat & 1 = 1 Will give the Identity columns /rockmoose
2004-07-17
Hello to all. I have a DTS job that creates a flat text file including an amout field (money) when the column is written into the text file it has to be maked as follows:1. Amonut 25.23 or 485.562. Mask should be: 0000002523 (ten characters with leading zeros and no decimal point) or 0000048556I did masked […]
2004-06-08
1 reads
Hello AllI have been SELECT_ed the new SQL Admin. for the office.I need help finding licence info. on 6 server running Sybase SQL 4(I think), SQL6.5, 7 and 2000.I need to know the Licence number, type of Licence(CAL, Per Processor), and the amount I have. Once I have this info. I can assess the amount of new […]
2004-06-08
2004-03-15
I am being told that there is no benefit to having a primary key defined, especially a surrogate key of identity if it is not used in joins. We have another table of account information that does have unique rows (key is account_num) however the uniqueness is enforced only by an index that is created […]
2004-03-11
See the following article - its not a extended stored procedure, but involves returning a resultset. I've generally opted for the extended stored procedure, because of the performance impact of doing anything significant with Oracle.http://groups.google.com/groups?q=%22Umachandar+Jayachandran%22+%22SQL+SERVER%22+%22ORACLE%22+OPENQUERY&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=OgiCJDW%23BHA.2552%40tkmsftngp05&rnum=2
2004-03-11
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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