Viewing 15 posts - 15,226 through 15,240 (of 22,219 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 30, 2010 at 5:22 am
noeld (4/29/2010)
Lynn Pettis (4/29/2010)
Anyone seen the OP since this morning?
Forget it ... we know the answer is that it is probably in GB .... or who knows if it was...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 1:15 pm
Then I'm stumped. It doesn't make any sense. To do an index rebuild, a full scan of the data is required and all new statistics based on the full scan...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 1:14 pm
ankitwaitshere (4/29/2010)
The primary database is a heavily transactional OLTP database for a Shipping-System. Currently, the database is serving 2 major purposes: 1- routine shippping/scanning etc, and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 12:45 pm
No, not knowing more, I wouldn't call it a bug. It's probably something to do with statistics after the rebuild, but I'm just a bit surprised by it because an...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 12:45 pm
Ah I get it. Performance goes down after the indexes are rebuilt and comes back up after the statistics are updated. Got it.
Well, it's hard to say precisely what the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 12:20 pm
It has to be unique to add a unique constraint. So you either modify the data to make it unique, or you modify the structure, adding, for example, an identity...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 11:56 am
If I understand what you said, statistics updates are taking 12 hours? That's a pretty serious problem. How big is the database in question?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 11:54 am
Viewing 15 posts - 15,226 through 15,240 (of 22,219 total)