Viewing 15 posts - 35,836 through 35,850 (of 49,558 total)
newbie2sql (11/15/2009)
One of our databases log file growing very huge. One of our team members recommended the following instead of dbcc shrinkdatabase (of course i would recommend...
November 16, 2009 at 1:17 am
Not according to the error message you aren't.
Directory lookup for the file "e:\as.mdf\as.mdf" failed
Check what you've got set for the directory and what you have for the filename....
November 16, 2009 at 1:10 am
obtllc (11/15/2009)
backup log database_name with truncate_only
Suggesting that with not mention of what it does, what the effects are and what you need to do afterwards? Bad advice.
November 16, 2009 at 1:07 am
This looks like spam. An near exact copy-paste of part of the previous post, with advertising junk at the bottom.
In case it's not. Get your windows admins to look into...
November 15, 2009 at 8:59 am
I can't remember the details, but I think it's a case where it's supposed to be accurate, but not 100% certain to be if there are ongoing changes and open...
November 15, 2009 at 8:55 am
Also check out the Plan cache miss and plan cache insert events (also in profiler)
I don't recall if the SP:Recompile and TSQL:StmtRecompile show compiles or just recompiles. Test them out.
November 15, 2009 at 4:32 am
Jeff Moden (11/14/2009)
November 15, 2009 at 4:25 am
chirag.vyas (11/13/2009)
in our application that need to create some tables in tempdb.
Why? That's generally a very bad idea
1. Is there any setting to ensure that the the db_owner role...
November 14, 2009 at 2:31 am
It's not an objectid, it's a partitionid. Query sys.partitions to get the objectid and indexid
November 14, 2009 at 2:27 am
SQLNewbster (11/13/2009)
Umm, sorry. I didn't realize this was the SQL 2k forum. I just joined when I posted this. Many apologies for that.
No worries. We just use...
November 14, 2009 at 2:25 am
CirquedeSQLeil (11/13/2009)
Keep in mind that an online Rebuild is available in SQL2K5 Enterprise.
Plus indexes with LOB columns can't be rebuilt online.
November 14, 2009 at 2:21 am
Francis Yee-483501 (11/13/2009)
Is there any other cases that if I use MAX(rows) for the same tablename I would not get the rowcount ?
Yes. Any partitioned table.
Consider a table with 2...
November 14, 2009 at 2:18 am
ryan.mcatee (11/13/2009)
November 14, 2009 at 2:15 am
You need to now go and restore all your log backups, starting with the one after the earliest of the filegroup backups and ending with the one you took right...
November 13, 2009 at 1:51 pm
espanolanthony (11/13/2009)
November 13, 2009 at 1:49 pm
Viewing 15 posts - 35,836 through 35,850 (of 49,558 total)