Forum Replies Created
Viewing 15 posts - 4,366 through 4,380 (of 18,926 total)
-
RE: DBCC Errors -Migarting SQL 2000 database to SQL 2005
opc.three (7/27/2011)
Ninja's_RGR'us (7/27/2011)
Sqlsavy (7/27/2011)
Microsoft is looking into the issue nowOk, keep us posted. I'd love to hear a happy ending on this one, even if there's little hope left...
-
RE: sys.objects$ (with a Dollar sign)
Lowell (7/27/2011)
Thanks everyone;I've attached it successfully as a user database and will now make a huge mess of things.
Thanks!
Oh crap, my first feeling is that the baby had been...
-
RE: Consistency error all of a sudden
How did you delete the DB? IIRC when the db is in emergency, the log files don't get deleted.
That could be the problematic file.
-
RE: upgrade sql server standard to enterprise
Sounds like a good starting point.
-
RE: Are the posted questions getting worse?
Roy Ernest (7/27/2011)
Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂It can't hurt...
-
RE: Report access
durai nagarajan (7/27/2011)
thanksbut this report every employees will generate it when they need it(not every day or constant interval).
will try this and getback hope this doesnt need .net knowledge
It's...
-
RE: Consistency error all of a sudden
Only a guess but it looks like the first and last files might be clashing with the same name (if the extension is auto-added by sql server)
RESTORE database [db1] FROM... -
RE: upgrade sql server standard to enterprise
You answered your own question. If for any reason the upgrade fails then you lose your prod server which you seem to want to avoid like the plague.
If you...
-
RE: Subquery with wrong cardinality after statistics updated with fullscan
virgilrucsandescu (7/27/2011)
This is definitely a very good solution, THANK YOU!I was looking for a hint to force the execution of subquery first, but I suppose there isn't one, so your...
-
RE: Subquery with wrong cardinality after statistics updated with fullscan
GilaMonster (7/27/2011)
Full text indexes and fulltext predicates are very prone to poor estimation. They don't use the column statistics (can't, the statistics are for equality or range, not like).Then there's...
-
RE: Subquery with wrong cardinality after statistics updated with fullscan
can you post the actual execution plan plz?
-
RE: Computed Columns
BinaryDigit (7/27/2011)
can't have a single statement as there system has all there scripts and our security system has its scripts that access each of there own Email Address feilds. I... -
RE: Are the posted questions getting worse?
Ninja's_RGR'us (7/27/2011)
Roy Ernest (7/27/2011)
Change of topic, When will we know who won the Exceptional DBA of the Year Award? I just want to know if the Santa will be there... -
RE: Are the posted questions getting worse?
Stefan Krzywicki (7/27/2011)
Ninja's_RGR'us (7/27/2011)
bopeavy (7/27/2011)
Ninja's_RGR'us (7/27/2011)
Stefan Krzywicki (7/27/2011)
--------------------------------------------------------------------------------
Gianluca Sartori (7/27/2011)
--------------------------------------------------------------------------------
My dear friends, I finally have the definitive answer to the question that originated this thread.
NO!
They're not getting...
-
RE: Consistency error all of a sudden
Ratheesh.K.Nair (7/27/2011)
We restored the DB to different server and it created a duplicate file for one .ndf file.We tried our best but not able to delete that file.
Do i...
Viewing 15 posts - 4,366 through 4,380 (of 18,926 total)