Viewing 15 posts - 15,211 through 15,225 (of 22,211 total)
Cory E. (4/30/2010)
Perhaps I do not understand fully the situation, but, you can make no changes, but must add the constraint...WITH NOCHECK ?
Excellent notion. That may very well be what...
April 30, 2010 at 8:35 am
Can you post the query and the execution plan, and if possible sample data & structure.
It's hard to know what the precise problem is without seeing this information. I will...
April 30, 2010 at 8:26 am
I agree with Brandie.
I will add this though, if your index was truly covering, and the one used by the execution plan, you shouldn't get a key lookup. So it's...
April 30, 2010 at 8:19 am
There's little you're going to be able to do. You're selecting a sufficiently large number of rows for deletion that you need scans to retrieve them.
April 30, 2010 at 8:14 am
It's difficult to be sure about execution plans and the issues when looking at estimated plans. When possible, please post actual plans.
The OR (ID IN... part of the query might,...
April 30, 2010 at 8:12 am
That only occurs when a restore is run. It has to occur because after a database is restored, there is no way that SQL Server can be assured that...
April 30, 2010 at 7:54 am
No, don't create more files. The issue is the code and the indexes. That is almost always the issue. You can only temporarily solve most problems by throwing more hardware...
April 30, 2010 at 6:16 am
It could simply be a bitch session, but then again, a valued employee might have some valid issues that the company could address. Taking myself as an example, I'm, less...
April 30, 2010 at 6:13 am
I don't think so, no. The problem is, I'm having a hard time understanding the issue. If you want unique data.... you have to make the data unique. You can't...
April 30, 2010 at 6:08 am
Another person to contact is your local Microsoft... what's the word, it's not advocate, but somethign like that. Anyway, I'm not sure who yours is for your region. It might...
April 30, 2010 at 5:55 am
Lynn Pettis (4/29/2010)
dbowlin (4/29/2010)
Someone on LinkedIn referred me to Blythe a little earlier today. I sent her an email asking for details.
I am curious about...
April 30, 2010 at 5:53 am
dbowlin (4/29/2010)
Someone on LinkedIn referred me to Blythe a little earlier today. I sent her an email asking for details.
I am curious about the number...
April 30, 2010 at 5:50 am
Ah, a 100gb log is a VERY far cry from a 100tb log, and makes one heck of a lot more sense.
Personally, I was only ever managing 700gb and that...
April 30, 2010 at 5:34 am
Carl B. (4/29/2010)
We noticed that behavior two times.
Now that we have changed the schedule of these...
April 30, 2010 at 5:23 am
Jeffrey Williams-493691 (4/29/2010)
When you rebuild your indexes - do you by chance have the following setting?STATISTICS_NORECOMPUTE = ON
Oooh, good catch. That's entirely possible.
April 30, 2010 at 5:22 am
Viewing 15 posts - 15,211 through 15,225 (of 22,211 total)