Viewing 15 posts - 6,196 through 6,210 (of 7,429 total)
Should not cause any harm even if it does not work.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 30, 2002 at 8:08 pm
Even with a large number of joins it may not be needed to de-normalize. Test somewhere to see if you get any bennefits de-normalizing by having fewer joins. Generally does...
April 30, 2002 at 8:05 pm
And to add in there. If you do not use the size of the column with a char it will add in blanks after and may require trimming in some...
April 30, 2002 at 8:02 pm
Again refer to BOL as there are still locks set when the NOLOCK hint is used. See my previous post.
"Don't roll your eyes at me. I will tape them in...
April 30, 2002 at 8:00 pm
Memory usage is not unusual as this is where it augments access speeds. However
quote:
after some time the SERVER restarts it self
April 30, 2002 at 7:58 pm
If I come across anything else I will pass along. Might want to try SP4 but it could be something with Access 2000, have you tried Access 97 just out...
April 30, 2002 at 7:53 pm
Also 2000 SP and Triggers are actually compiled code. It was that way in 6.x but not in 7. When I say compiled it is like create a VB executable...
April 30, 2002 at 7:41 pm
The only thing is you need to make sure you can do this when nothing else is going on, on the server as you get a squewed look. The values...
April 30, 2002 at 7:38 pm
This is possible due to the counts returning in the buffer to SQLAgent. May be reading each one and if you have a return each loop thru the cursor, then...
April 30, 2002 at 9:15 am
It is incorrect that the NOLOCK hint will not issue a lock from BOL
quote:
NOLOCK = Do not issue shared locks and do...
April 30, 2002 at 7:58 am
Sounds like someone set the internal password for the package and without this do not know of a way. Is this package run in a task or anywhere as they...
April 30, 2002 at 6:35 am
Only thing I think of with the event calendar is that on months with no inputs the calendar is extremely narrow. Might want to set a width on it to...
April 30, 2002 at 6:30 am
Can you post the ddl of the main tables so I cn make sure I getting this right and an example of the output you expect. I believe it can...
April 30, 2002 at 6:26 am
Also be aware that subqueries and orber by generate space in tempdb for storage. Are you using either in you code. If so it may be these type processes.
"Don't roll...
April 30, 2002 at 6:01 am
Can you script your job using EM so we can look at how it is defined. May be something there? Also try starting the job and watching under Profiler.
"Don't roll...
April 30, 2002 at 5:58 am
Viewing 15 posts - 6,196 through 6,210 (of 7,429 total)