Viewing 15 posts - 856 through 870 (of 1,319 total)
vishacad (11/24/2008)
It used to take 8hrs to backup the DB size of 300GB to a local drive and + 6hrs for copying it...
-- You can't be late until you show up.
November 25, 2008 at 6:22 am
millsrustyk (11/21/2008)
-- You can't be late until you show up.
November 21, 2008 at 6:35 am
While I know the economic issues are having some effect on the job market, I believe it's also related to end-of-year activities and new budget items and the like. I...
-- You can't be late until you show up.
November 12, 2008 at 9:43 am
rbarryyoung (11/12/2008)
I wasn't aware that there was a difference between "!=" and "<>"?
There isn't but isn't "!=" "old school"??? I haven't used it for about ten years! 😀
-- You can't be late until you show up.
November 12, 2008 at 7:27 am
Patrick Ige (11/12/2008)
THanks guys but what i need isnot in ('TX','NY,'MN')
I want to remove some more...
Will != or <> permit this?
"Not in" will work. Don't use != but you can...
-- You can't be late until you show up.
November 12, 2008 at 6:10 am
Patrick Ige (11/10/2008)
select distinct(area) asfrom Stores where state
not in ('TX - Area 1')
Something tells me there is more to the code than what you've posted. In...
-- You can't be late until you show up.
November 11, 2008 at 3:02 pm
dastagirid (11/11/2008)
urgentI need the how to create subreport in main report.
send me good links.
Dastagiri.D
Ever heard of Google?? Based on that overwhelming volume of information you provided...
-- You can't be late until you show up.
November 11, 2008 at 2:50 pm
roadtrain64 (11/10/2008)
How can I recover my datbase from suspect mode??
You stated you wanted help to "recover from suspect mode"......The backup you are trying to restore, is it SQL 2000 backup...
-- You can't be late until you show up.
November 11, 2008 at 2:19 pm
vladimir.antovic (11/6/2008)
Thank you for the answer,but how then you can forbid developers to create DTS package on the production server?
Soory, I should've quoted this in my first post. The point...
-- You can't be late until you show up.
November 6, 2008 at 10:35 am
J (11/6/2008)
Of course.I would expect any "Senior DBA" to make a backup FIRST.
There a plenty of threads opened with the phase "I've deleted my data but don't have a backup...
-- You can't be late until you show up.
November 6, 2008 at 10:04 am
And be sure you have a recent backup BEFORE you run the deletes.
-- You can't be late until you show up.
November 6, 2008 at 9:54 am
Never give your developers access to your production servers. That should be your responsibility. They develop and unit test. Somebody (you??) does a final test and promotes to production, period....
-- You can't be late until you show up.
November 6, 2008 at 9:19 am
Your baseline is always the full backup restored first. Then each log is applied to the restored database, oldest to newest, up to the point you want to get to,...
-- You can't be late until you show up.
November 6, 2008 at 8:59 am
drop database??? No seriously, add disk or archive data are really your only viable options (maybe cleanup any unneeded "temporary" work tables?). Obviously, archiving data is going to require some...
-- You can't be late until you show up.
November 5, 2008 at 1:57 pm
Speaking from a SQL 2000 perspective (I know which forum this is), I saw this once before. We had two clients at different version levels of the client tool (ODBC...
-- You can't be late until you show up.
November 3, 2008 at 6:23 am
Viewing 15 posts - 856 through 870 (of 1,319 total)