Viewing 15 posts - 41,911 through 41,925 (of 49,562 total)
Grant Fritchey (1/7/2009)
Too much information in the Estimated execution plan? I don't understand.
I'm guessing too many plans.
January 7, 2009 at 7:16 am
Is there a trigger on the table?
Maybe it's just a phrasing issue, but an update statement is not going to insert anything into the database. It's going to modify an...
January 7, 2009 at 6:34 am
Run profiler and capture the SP_Completed event. That will get you the stats for every proc run.
You could run the proc with the execution plan on and see which queries...
January 7, 2009 at 6:33 am
It's created by the optimiser when running queries so that it can get info about the distribution of data in the column, to get a better execution plan.
See this post...
January 7, 2009 at 6:24 am
venkatg86 (1/7/2009)
Can i know the Exact cause of this Error. so, i may aware of this and not repeat the same error in future
No idea. The message you posted doesn't...
January 7, 2009 at 6:20 am
SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may be what you're...
January 7, 2009 at 5:39 am
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
Viewing 15 posts - 41,911 through 41,925 (of 49,562 total)