If this procedure has been working fine with good performance then my first suspicion would be that something else is causing the problem. Perhaps some long running process that is locking the tables that your procedure needs.As an additional note I would avoid using the exec dbo.spMySP 1,2,3,4 syntax. Use the command object and specify […]
2004-10-11
2004-09-28
1 reads
I was able to serve at his second inaugaration while in the military. I was proud to serve in the military under him. It hasn't been until I grew up a little more to finally realize what an incredible man he was who had clear ideas of right and wrong and was able to work […]
2004-06-08
Look into the command line switches for MSDE2000 setup. I believe DISABLENETWORKPROTOCOLS=0 will install MSDE with tcp/ip enabled. Mike
2004-05-28
Thank u very much wz700 and Jeff for ur posts.i finally decided to use Jeff's suggestion.You guys r very helpful
2004-05-04
Thanks for all the replies and suggestions! This gives me some place to start if and when it happens again. Cheers, Andre
2004-04-05
Dear ckempste,I already thought of your idea before but it takes a lot of time. I need to change quite a lot of tables. Any other ideas?
2004-01-27
quote: "Jumping jobs" as it spending 3 months here, 6 months there, 3 months at the next job, etc. The work experience shows one of several possibilities we didn't want to get into: (1) The person appeared competent at initial hiring but as the companies got to know him his experience was lacking and he […]
2004-01-02
1 reads
Wrong "correct answer", but right Explanation... QOD is getting worse every day. Yesterday it was a minor mistake about an underline, today is a huge difference between DESCending and ASCending. Needless to say that I answered "None of the above" and... I want my points back ! Razvan
2003-12-17
Of course this is a problem in procedural programing, not batch programing. Thus, this is the kind of code that makes DBAs (like me) tense up and make ugly faces. With that being said, assuming that you have a unique index, I believe you want something like this: declare @id int declare @newvalue int declare […]
2003-12-15
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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