Viewing 15 posts - 41,986 through 42,000 (of 49,562 total)
Michael Earl (1/5/2009)
I used to link to google now and then, but that link makes the point much better so I am going to have to use it.
Likewise. 😎 :hehe:
January 5, 2009 at 10:51 am
GermanDBA (1/5/2009)
January 5, 2009 at 10:41 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic629723-106-1.aspx
January 5, 2009 at 10:36 am
RBarryYoung (1/5/2009)
Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.
Wasn't that for the 'catch-all'...
January 5, 2009 at 10:22 am
RBarryYoung (1/5/2009)
January 5, 2009 at 10:01 am
Grant Fritchey (1/5/2009)
Since you're working in SQL Server 2005, you could simple add the index as an INCLUDE column.
From what I can tell from the exec plan, they're already include...
January 5, 2009 at 9:55 am
shahnawaz (1/5/2009)
infact i dont have a backup of the database.i was having only one copy of the database that is giving me this error.
Why no backup?
is there any way i...
January 5, 2009 at 1:32 am
Your only option to fix this is to restore a clean backup that was taken before the corruption. If the DB is in full recovery and there are tran log...
January 5, 2009 at 12:42 am
How are the two tables related?
What makes dd relate to ed and fr to gd?
If it's the order of the rows, then what column defines that order?
January 5, 2009 at 12:31 am
Oh, one other thought.
If you have a DB growing that fast with performance problems, you may want to consider getting a specialist in to analyse and make recommendations. Especially if...
January 5, 2009 at 12:18 am
DBADave (1/4/2009)
January 5, 2009 at 12:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic629584-323-1.aspx
January 5, 2009 at 12:05 am
Lester Policarpio (1/4/2009)
In situations like this can I take the database to offline mode then take it to online mode?
You can. It's not likely, by itself, to resolve anything though.
SQL...
January 4, 2009 at 11:40 pm
branovuk (1/3/2009)
Let me ask here, and not open new topic: what is best combination for backup: full+diff, or some combination with log backup as well.
Sorry, just noticed this...
January 4, 2009 at 11:32 pm
Viewing 15 posts - 41,986 through 42,000 (of 49,562 total)