Viewing 15 posts - 14,356 through 14,370 (of 22,219 total)
GilaMonster (9/12/2010)
"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
September 12, 2010 at 10:42 am
Steve Jones - Editor (9/10/2010)
Holy Smoke - Be prepared to laugh out loud http://is.gd/f4cHh (Facebook)
Can't get to Facebook from work and my phone won't let me watch Flash (damn Verizon...
"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
September 10, 2010 at 9:24 am
Stefan Krzywicki (9/10/2010)
Grant Fritchey (9/10/2010)
Jack Corbett (9/10/2010)
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane 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
September 10, 2010 at 8:16 am
GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.Title? Author?
Here you go. First in a trilogy. Ancient stuff.
"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
September 10, 2010 at 8:04 am
Jack Corbett (9/10/2010)
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane with a break from this...
"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
September 10, 2010 at 8:02 am
Yeah, I like using trace events to see what's being run against the database and then determine where to spend my time tuning.
"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
September 10, 2010 at 7:57 am
In addition to Gail's advice, try some of the classic deadlock resolutions. Check the code to ensure that everything is accessing the tables involved in the same order, stuff like...
"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
September 10, 2010 at 7:47 am
I'd suggest reading through this article[/url] from Jeff Moden. He really lays down some great methods for going through comma seperated fields like 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
September 10, 2010 at 7:46 am
First, the positives:
Way to go on pointing out that you need to validate data during the tuning process. This is something that it's far too easy to assume and doesn'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
September 10, 2010 at 6:30 am
Instrumentation into the TSQL code itself? Heck no. But we do use trace events to monitor our apps & databases & servers in development, qa and production, in order 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
September 10, 2010 at 6:11 am
Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
Alvin Ramard (9/9/2010)
Trey Staker (9/9/2010)
Steve Jones - Editor (9/9/2010)
You can sign up 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
September 10, 2010 at 5:42 am
The best way to do this would be to have two queries, one that just selects everything, without a WHERE clause, and one that selects based on the WHERE clause....
"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
September 9, 2010 at 7:56 am
GilaMonster (9/8/2010)
Now here's an interesting question...Which is going to reach 20 000 posts first, me or the Thread?
Looking at the counts.... I'd put my money on you pulling away.
"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
September 8, 2010 at 8:17 am
For detailed answers, please do as Gail requested.
For a quick answer, I'd look at this:
and so_ref not like '% VS'
That will lead to serious slow performance since the only...
"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
September 8, 2010 at 7:04 am
Not knowing exactly what you need, this might be off, but what about loading the update into a MySql instance and then using SSIS to migrate the data?
If it's structures...
"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
September 8, 2010 at 7:00 am
Viewing 15 posts - 14,356 through 14,370 (of 22,219 total)