Don't know if it's exactly the same error message, but I've found you have to be logged in locally to start the Agent service; ie, you can't start up EM on your machine, connect to a remote machine through EM, and start the Agent up. You have to log in to the remote machine and […]
2003-07-28
1 reads
If you do a massive delete you may want to reindex the table or at least set recompile on for it.
2003-07-25
quote: Here's another good link on Visual Language Research Bibliography: You'll find everything under the sun there on this topic. woohoo, Dale, feel kissed through cyberspace for this one!!!! Cheers, Frank
2003-07-25
The optimal environment is if you have plenty of disks to put the system, tempdb, logs, data and indexes on different physical disk arrays. you could even partition your data on separate disks depending on your database design. the overal best performance for the data and the index disk is RAID10 and for log and […]
2003-07-24
...if you explicitly use the JOIN keyword, you cannot leave out the ON clause. /Hans
2003-07-24
Run a sample of the dynamic sql queries that run through the front end in Query Analyzer. Look at the execution plan and see what's taking the longest to execute.
2003-07-23
Just to clarify. The deletes have already been done with no issues. After the deletes the dynamic sql's from web frondend have started to work slowly. We cannot change them to stored procedures as of now.
2003-07-23
Can you check whether dynamic queries use correct indexes to find records that need to be deleted? Do you delete them in a single batch or split the deletion into many small batches that delete portion of the records at one time? Can you replace the dynamic queries with stored procedures?
2003-07-23
quote: temp table is written to tempdb and that IO will be very slow Dont forget that you can declare a table variable which is in memory temp table and not tempdb(disk) based.
2003-07-22
Hi jl75@9online.fr, quote: Yes but the amount of records is absolutely huge and MsAccess can't take it ! If that is an alternative to go, maybe you can split this amount like first quartile, second, ...? Cheers, Frank
2003-07-22
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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