Viewing 15 posts - 39,316 through 39,330 (of 39,717 total)
sp_recompile forces the procedure to recompile when you run it and a new query plan is built at that time. We were thinking the query plan is out of date...
November 5, 2001 at 12:55 pm
November 5, 2001 at 12:51 pm
Post your code and we can help, but Leon is right. Get it working in QA first.
Steve Jones
November 5, 2001 at 12:46 pm
Don't use sa in DTS!!!!!
You might need to re'save your DTS packages. I see them sometimes flip out with changes like this.
Steve Jones
November 5, 2001 at 12:44 pm
I would add that most people stink in this business. I think the curve for IT people (especially DBAs) is bent to the left.
I'd be interested in knowing how he...
November 5, 2001 at 12:38 pm
Sounds like you are missing something.
Can you try another machine? (Another copy of EM)
Steve Jones
November 5, 2001 at 12:15 pm
Keep one thing in mind.
Cost of DBA/developer: $$/hr.
Cost of hardware $$$$/life of server.
The human cost can quickly exceed the box cost in trying to optimize/profile code. Not that it shouldn't...
November 5, 2001 at 12:12 pm
November 5, 2001 at 12:07 pm
no alias allowed.
yes you need a temp table
avoid this. Compute the sum yourself.
Steve Jones
November 5, 2001 at 12:04 pm
November 5, 2001 at 12:00 pm
Be careful using a COM object from SQL Server, espeically if this proc gets used a lot.
Steve Jones
November 5, 2001 at 11:56 am
I agree with the two above. A couple items to think about.
1. As of right now, I have the decrpytion algorithm to decrpyt any v6.5 view/sproc/trigger. I also have 2...
November 5, 2001 at 11:54 am
November 5, 2001 at 11:49 am
November 5, 2001 at 11:48 am
Personally, it seems that not much is being said about AD all around. In fact, the last few .NET presentations I have seen haven't mentioned it at all.
Has anyone completed...
November 5, 2001 at 11:47 am
Viewing 15 posts - 39,316 through 39,330 (of 39,717 total)