Viewing 15 posts - 39,016 through 39,030 (of 49,571 total)
Gianluca Sartori (5/20/2009)
Can you help us with some ideas on the short circuit side?
Maybe.
I've seen SQL short circuit some expressions, emphasis on some. Mostly in cases of expressions based on...
May 20, 2009 at 9:28 am
Why all this hassle with OPENROWSET? What's wrong with SSIS or the import/export wizard? This is exactly what those tools are there for. Why don't you try using one of...
May 20, 2009 at 9:18 am
Gaby Abed (5/20/2009)
May 20, 2009 at 8:36 am
ip2host (5/20/2009)
ok what do you think i should do:
1) Read the article that I linked about managing transaction logs
2) Tell your boss that he's risking the business by having no...
May 20, 2009 at 8:29 am
Restore a full backup and any tran logs you need. You're not going to get the DB back into standby in a state that will allow logs to be applied...
May 20, 2009 at 8:28 am
too_sweeeeeeeet (5/12/2009)
I have a function that contains the following query which is always timimig out.select distinct @Result = sum( column1 )
from table (nolock)
where ((column2 = @param1) or (@param1 = 0))
What...
May 20, 2009 at 7:10 am
To bring a database from STANDBY to ONLINE, run the following
RESTORE DATABASE <Database Name> WITH RECOVERY
May 20, 2009 at 7:02 am
ip2host (5/20/2009)
I didnt correctly express myself.I truncated trans logs after full backup each base and trans log.
Are you running BACKUP LOG ... WITH TRUNCATE_ONLY at all? If so, please read...
May 20, 2009 at 6:56 am
guptaajay1985 (5/20/2009)
Will I ever get that deleted data..
No. The data that was on the pages that checkDB deallocated is gone, permanently.
May 20, 2009 at 3:32 am
guptaajay1985 (5/20/2009)
When I have run DBCC checkdb (postnet,repair_allow_data_loss) it gives in red color...
Good. It looks like everything's repaired. Run checkDB again (without any repair option, just as I gave it...
May 20, 2009 at 1:23 am
ip2host (5/20/2009)
Learned how to truncate trans log instead of deleting them.
That's something that you need to unlearn, I'm afraid. Transaction logs should not be truncated, they should be backed...
May 20, 2009 at 1:01 am
Try running restore with the CONTINUE_AFTER_ERROR option. If that doesn't work then the backup is not restorable.
May 20, 2009 at 12:57 am
SQL_Monster (5/20/2009)
Can any suggest and let me know that if CPU is in 100% utilization then the new processes will not be accepted.
No
CPU utilization 100% = Utilizing total memory of...
May 20, 2009 at 12:55 am
Glenn Dorling (5/19/2009)
May 20, 2009 at 12:52 am
Ok, you've got 4 pages that have been trashed somehow. Since you do not have a clean backup, you're going to have to run repair. Note that REPAIR_ALLOW_DATA_LOSS, as it's...
May 20, 2009 at 12:45 am
Viewing 15 posts - 39,016 through 39,030 (of 49,571 total)