Viewing 15 posts - 19,771 through 19,785 (of 22,219 total)
Are you sure it's not being caused by the read committed vs read uncommitted? I don't recommend it's use, because you can get some really bad data, but read uncommitted...
"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 12, 2008 at 6:45 am
You're trying to uinstall SQL Server while people are connected to it? That might cause a few issues with the uninstall and the people working.
Like Steve says, a bit more...
"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 12, 2008 at 6:43 am
Like Gail said, they can be problematic. It's the multi-statement table valued functions that will really chew on you. The single statement ones generally will create a good execution plan...
"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 12, 2008 at 6:37 am
You left out triggers...
Good editorial. I agree with it. I also take, a very slight, exception to it. The problems that people who post here every day see are not...
"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 12, 2008 at 6:35 am
GSquared (8/11/2008)
Jimbo (8/11/2008)
GSquared:European nobility were worse than hillbillies.
Take it easy on my relatives there! Just because a few branches of the family tree curl back on themselves...
Soccer officiating sounds worse...
"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 12, 2008 at 6:07 am
Sorry I haven't been taking part in the discussion. Rhode Island celebrates VJ Day so I had the day off... Whatever.
Adding in reporting or views would be a good idea,...
"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 12, 2008 at 5:54 am
Assuming the query plans are the same, I'd tend to go with the second one as well.
"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 8, 2008 at 12:45 pm
Are you working from the execution plan? You need to understand how SQL Server is accessing the data. The execution plan will tell you what's going on. It's less accurate,...
"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 8, 2008 at 11:26 am
Yeah, that's pretty common. We have a Microsoft consultant who comes in on site to help us with OM issues. I showed him what I was doing and he started...
"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 8, 2008 at 10:35 am
timothyawiseman (8/8/2008)
Several people have mentioned martial arts, which...
"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 8, 2008 at 9:12 am
I do agree. Most of what you're doing in 2005 and most of the way you do it, should remain the same. The one area that I think might bite...
"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 8, 2008 at 8:59 am
An execution plan would sure make a difference.
"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 8, 2008 at 8:57 am
163 rows can, depending on the table, fit on one or two pages. That's just not going to be an issue if it goes to three or four. You'll want...
"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 8, 2008 at 8:52 am
GilaMonster (8/8/2008)
Steve Jones - Editor (8/8/2008)
"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 8, 2008 at 8:46 am
GilaMonster (8/8/2008)
Grant Fritchey (8/8/2008)
[Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by deletes.
Shrinking the database or the data file.
Oh yeah, good one....
"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 8, 2008 at 8:25 am
Viewing 15 posts - 19,771 through 19,785 (of 22,219 total)