In the past there has been reasons to set up a schedule reboot process for Windows/SQL machines due to the large amounts of memory leaks which came from some Microsoft apps - but most of those leaks are fixed. I agree with sqltimd in theory that unless you see the problems of memory leaks, you […]
2003-06-11
I don't know how much of the problem is solved in the enterprise version. We didn't have that option and finally resorted to using a middle tier to address each machine directly and separately. The response was 100 times faster. Also - If you are not using dynamic SQL, you can perform the updates through […]
2003-06-11
Supplamental I have checked the query plan and found out that when I am updateing or deleteing a remote table scan is preformed I have tiried to use thw "with (index(0))" but the analyzer wont allow me! I am using sql server 7 sp3
2003-06-11
I guess I should just stick to Admin work eh, It took a little bit, but I figure it out yesterday. BOL doesn't exactly give you those type of examples. Thanks Paul and mlwang for your examples. cheers John Zacharkan
2003-06-11
Allowing negative inventory is bad practice, particularly in ERP systems. The computer system should reflect actual ("real") data. It's impossible to have negative inventory; however, it is possible to have reservations against future inventory. I agree with the above comments that yesterday's QOD wasn't a very good question. Sure there was a deadlock, but the […]
2003-06-11
There have been some threads about multi-processor machines behaving strangely. Maybe something to check out ...
2003-06-11
Hello tmp, quote: Maybe you have the select into/bulk copy option checked in your db, and operations like bulk insert, bulk copies, truncate tables are made against it. This kind of operations are non-logged. the option is not checked, but I heard some developer has applied some patches to the GUI that accesses the db. […]
2003-06-10
Can you run the job to completion in the dts designer? If not, you can determine which step is causing the problem by running them individually using the Right Click menu - execute step.
2003-06-10
Carl, When you do a test run (non-scheduled) of the package, do you do so logged on to the SQL box itself, or using client utilities from your workstation?
2003-06-10
We do this same thing with about 200 jobs ... on an AS400 9406-730 OS400 v5.1 .. Have verified the jobs are connecting to the AS/400?
2003-06-10
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
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