I use DBArtisan myself but it is rather expensive. I believe the less expensive version is RapidSQL but I think it is sold only for specific databases as opposed to DBArtisan which, like Katy points out, supports several platforms.
2003-07-31
1 reads
quote: Is the following statement a valid example of the checksum-statement ? I've read about the * on msdn (-which does not mention the abality to use the table-qualifications as t. and o.) but am unable to test because I have a couple of days off right now UPDATE o SET o.data1 = t.data1 , […]
2003-07-31
1 reads
Some timings: No UDFs (Basic) - 1036 rows/second Basic + Currency Conversion UDFs - 770 rows/sec Basic + Date UDFs - 550 rows/sec Basic + Currency UDFs + Date UDFs - 480 rows/sec Basic + Date validation as case statement - 710 rows/sec Basic + Date validation as case + table join for currency conversion […]
2003-07-31
1 reads
Just to chime in on the UDF issue... I think they are amazingly cool, but should be used in select statements with great caution. We were working on an application here and the other developer, who comes from a VB/CGI/web-development world, coded a lot of the logic into UDFs, then put the UDFs in the […]
2003-07-30
1 reads
Is the following statement a valid example of the checksum-statement ? I've read about the * on msdn (-which does not mention the abality to use the table-qualifications as t. and o.) but am unable to test because I have a couple of days off right now UPDATE o SET o.data1 = t.data1 , o.data2 […]
2003-07-30
1 reads
hbkdba, Great news! Give us an update when you do a performance comparison on the cursor... Jeremy, I have a feeling those UDFs might be the culprit, like NPeeters mentioned. Any chance to see an execution plan?
2003-07-30
1 reads
@jpipes: Thanks a lot ! This is exactly what we are looking for. A first test: two tables containing 1.2 million rows (temp and ods). After changing 47.000 rows on the temp. I've ran the update statement. (server Pentium III 500 Mhz 384Mb an old one to test on) completed in 27 seconds! Comparisons against […]
2003-07-30
I just wonder if using UDF is better than using a SP on the linked server. The SP would return a rowset, of course, that would be inserted into a local temp table. OR use a UDF and still insert into a local temp temp for further usage. So, does anyone have experience of comparing […]
2003-07-24
1 reads
Thank you very much MarkusB! I thought may be there are ways around.... If not, ok tough luck
2003-06-30
Thanks Shas3, This is a reporting db and I have additional backups on the VAX/Alpha platform. My mission-critical dbs use separate drives to store the data, the logs, and the backups. Loading is done once per week overnite so I/O is not a consideration. I am just trying to find out why the datafiles grow […]
2003-06-24
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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