Viewing 15 posts - 12,466 through 12,480 (of 22,224 total)
Abrar Ahmad_ (5/26/2011)
Waiting ... ![/font]
I'm sorry, normally I let this stuff go, but, seriously, Waiting? I'm in here helping out because I want to be, not because you're paying me....
"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
May 26, 2011 at 5:57 am
Yeah, it's just logical processing. You can see that none of the salaries fall within the >500 < 1000 range, so how did the first two queries return data? Because...
"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
May 26, 2011 at 5:28 am
Wow! Well done. I usually run about 1/5 of 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
May 26, 2011 at 5:23 am
Not so much a how to, but I recently posted this article on how to prepare[/url] for being the on call person.
For what it's worth, there is no average on-call...
"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
May 26, 2011 at 5:22 am
GilaMonster (5/26/2011)
Grant Fritchey (5/25/2011)
Steve Jones - SSC Editor (5/25/2011)
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
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
May 26, 2011 at 5:15 am
I'm not a fan of intellisense, when it works, it doesn't do enough.
That said, instead of sp_who2, take a look at sys.dm_exec_requests and see if you see an active connection...
"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
May 26, 2011 at 5:10 am
I don't know that I'd say there is a "best" strategy. However, there is one fundamental truth. Your backups are only good if you can restore them. So you run...
"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
May 26, 2011 at 5:07 am
That's a good idea to know exactly how long it was there. To just get an idea of how long it's been there at a moment in time, take a...
"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
May 26, 2011 at 5:00 am
When you create temporary tables, you get a recompile. When you add a row to temporary tables, you get a recompile because of the stats updates. Then, statistics can get...
"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
May 26, 2011 at 4:58 am
Another person just recently had an issue where someone posted millions of rows and was doing sorts on unindexed columns while they did so, smacked tempdb good and hard. It's...
"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
May 26, 2011 at 4:53 am
Steve Jones - SSC Editor (5/25/2011)
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
Is that for sure?...
"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
May 25, 2011 at 4:28 pm
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
WHOOP!
I'll be there.
"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
May 25, 2011 at 3:43 pm
My initial take, based on the column name, was that you have clustered GUIDs, which are absolutely prone to fragmentation, but based on what you're telling us so far, it's...
"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
May 25, 2011 at 10:29 am
river1 (5/25/2011)
Liquidacao.DESCPERIODO, Liquidacao.CODTLIQ1, Liquidacao.IMPTRIB, Liquidacao.CODDLIORIG, Liquidacao.TIPODLI, Liquidacao.CODCRORIG,
ISNULL(dbo.IMPOSTODESD.NUMIMPDESD, Imposto.NUMIMP) AS NUMIMP, Contribuinte.NOMECTB, Contribuinte.NIFCTB,
CCCredito.VALORCCCREDITO, SGTALiqData.NUMDU, SGTALiqData2.OrdemNotas, SGTALiqData.CODCR, SGTALiqData.DATAEXPIRACAO,
Liquidacao.CODANULA,...
"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
May 25, 2011 at 7:39 am
GilaMonster (5/25/2011)
river1 (5/25/2011)
I undestarnd but still in 2000 that didn't happen and lthe table has only a few more rows...
SQL 2000 to SQL 2005 was a major change. not a...
"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
May 25, 2011 at 7:36 am
Viewing 15 posts - 12,466 through 12,480 (of 22,224 total)