Viewing 15 posts - 39,061 through 39,075 (of 39,466 total)
Whew, not sure if you can get the db without the log.
I think you need to recreate the database with a blank file (using the GUI). Then shutdown the server...
November 5, 2001 at 1:16 pm
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
Viewing 15 posts - 39,061 through 39,075 (of 39,466 total)