Viewing 15 posts - 41,926 through 41,940 (of 49,571 total)
There's no way to move a database while it's online.
The two ways to move a DB are the detach/attach method you have, or to do an ALTER DATABASE ......
January 7, 2009 at 4:56 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 7, 2009 at 4:55 am
Post the exact error message, and read this blog post. http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx
For what it's worth, you should never detach a suspect or corrupt database, because it will not reattach.
Do you have...
January 7, 2009 at 4:52 am
Why are you truncating the transaction log? If you don't want to backup the log and point-in-time recovery is not required, put the DB into simple recovery and leave it...
January 7, 2009 at 3:57 am
Michael Baas (1/7/2009)
January 7, 2009 at 3:45 am
There should be an entry in the SQL error log saying why the database has been marked suspect. Can you look through the error log and see if there's anything...
January 7, 2009 at 3:22 am
matsinopoulos (1/7/2009)
However, I realized that it does not contain the line breaks. The whole value of definition is one line string. How should I recover the body of the...
January 7, 2009 at 3:00 am
Thought so.
Those aren't indexes. They're automatically created system statistics and they can be safely dropped if they're causing problems (as they are here). The optimiser will recreate any that it...
January 7, 2009 at 1:33 am
How many indexes do you have?
Are you sure there are no redundant indexes?
Are they all been used?
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If...
January 7, 2009 at 1:00 am
ALZDBA (1/7/2009)
However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.
With one caveat:
From the kb...
January 7, 2009 at 12:56 am
You should leave those on unless you know exactly what turning them off will do, you're happy with the risks and you have some manual stats update job in place.
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
I...
January 7, 2009 at 12:14 am
Continued here - http://www.sqlservercentral.com/Forums/Topic631160-150-1.aspx
January 7, 2009 at 12:11 am
Bookmark lookups happen when SQL uses a nonclustered index to fetch rows and all of the columns that the query needs are not contained in the nonclustered index.
That clustering key...
January 7, 2009 at 12:05 am
tfifield (1/6/2009)
If all the data being fetched was in a covering index, would that guarantee the order?Todd Fifield
Once more with feeling...
The only way to absolutely guarantee an order is to...
January 7, 2009 at 12:02 am
Replication does not create indexes.
Please run the following for the table in question. What does it return?
SELECT object_name(id), name, INDEXPROPERTY(id, name, 'IsStatistics') FROM sysindexes
WHERE id = object_ID('Table Name')
January 7, 2009 at 12:01 am
Viewing 15 posts - 41,926 through 41,940 (of 49,571 total)