Viewing 15 posts - 39,106 through 39,120 (of 39,510 total)
I like the article. We need a standard view of our jobs for it to be more accepted in all industries.
I think that the production DBA should report to an...
November 5, 2001 at 1:10 pm
I'd always leave it to users to change things, but try to standardize whereever possible for storage. especially for loads of data from an external source.
Steve Jones
November 5, 2001 at 1:06 pm
I think you need 3 environments at a min. Prod, dev and a QA/staging area. Refresh QA and test before moving changes to production. Reffresh dev rarely and be sure...
November 5, 2001 at 1:03 pm
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
Viewing 15 posts - 39,106 through 39,120 (of 39,510 total)