Viewing 15 posts - 11,971 through 11,985 (of 22,224 total)
Automatic update of statistics occurs as the data changes. After an update the stats will update as the indexes are accessed. If you're not seeing updated statistcs, those indexes haven'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
August 25, 2011 at 7:07 am
Did you start a transaction on the client side and is it committed?
"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
August 25, 2011 at 6:49 am
You have to monitor the server to identify what is running slow. As a quick and dirty start point, take a look at the wait states to see what things...
"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
August 25, 2011 at 6:48 am
Parallelism is not something that simply occurs in SQL Server. It's based on two things, the cost threshold you have set for parallelism. By default this value is 5. Personally,...
"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
August 25, 2011 at 6:45 am
Basically that's generating a "SELECT *" statement for every table that you define. Which means it selects everything, every time. It's just going to get slower and slower as your...
"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
August 25, 2011 at 6:39 am
There is something in 2008R2 called Master Data Services, but the strictures for using it were so severe we couldn't get it to fly within our environment. We went 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
August 24, 2011 at 11:43 am
Welsh Corgi (8/24/2011)
I did not mean to offend you.I did not mean it that way.
No offence at all. I was joking. Sorry that came off harsh. It sure wasn't meant...
"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
August 24, 2011 at 11:42 am
Welsh Corgi (8/24/2011)
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
If they thought you...
"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
August 24, 2011 at 10:57 am
Oh yeah, it's going to block.
It's all about choices. You want to get rows back and not fall into the crack between a delete and an insert... gotta have 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
August 24, 2011 at 10:56 am
You're trying to build an index off of a field or fields that is too large. You have to use less or smaller fields to build the index. There is...
"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
August 24, 2011 at 9:55 am
Robert Heynen-454800 (8/24/2011)
You mentioned a transaction earlier. To...
"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
August 24, 2011 at 9:50 am
It's not at all unheard of to modify data, a lot, and query it at the same time. It's pretty standard in fact. But, you have set expectations and spend...
"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
August 24, 2011 at 8:42 am
Make sure that the delete and insert (it's not an update) are within a single transaction. That will prevent missing data during a query and should help, a bit, with...
"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
August 24, 2011 at 5:55 am
In addition to the good advice given by Lutz, assuming these are lookup tables, we built a database that held the standard values for all lookup data. We only ever...
"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
August 24, 2011 at 5:49 am
Roy Ernest (8/23/2011)
Grant Fritchey (8/23/2011)
Roy Ernest (8/23/2011)
"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
August 23, 2011 at 10:39 am
Viewing 15 posts - 11,971 through 11,985 (of 22,224 total)