Viewing 15 posts - 7,471 through 7,485 (of 22,221 total)
SQL DJ (9/13/2014)
I have made the modification as below. It gives me duplicates...how can I remove these ?
isnull((select distinct (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) ) from #MainAccount a1
LEFT OUTER JOIN
#BudgetAccount bb ON...
"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 13, 2014 at 9:19 am
Well done! Just keep coming back and slogging away. You'll get to the next level too. Congratulations!
"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 13, 2014 at 6:17 am
freddyism00 (9/12/2014)
I read part of the whitepaper, it said the data columns are stored...
"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 13, 2014 at 6:11 am
SQL DJ (9/13/2014)
Grant,What do you mean by execution plan ?
Gail's answer is good. You can also follow the links in my signature to my books on query tuning and execution...
"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 13, 2014 at 6:09 am
Really, really, really need the execution plan to understand how things are behaving within your environment. Without that, it's all guesses. But, all these correlated sub-queries:
select (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) )...
"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, 2014 at 8:56 am
Yeah, you pretty much have to use it. Equality and Inequality columns are the columns being used within the queries in the WHERE, JOIN and HAVING clauses. They would make...
"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, 2014 at 8:41 am
You need to look to your execution plan to understand how it's using the indexes you've created.
From the looks of things, you have an index on a bit column, IsActive....
"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, 2014 at 8:38 am
I'm sorry, I'm not quite understanding what you're referring to here. Do you mean a table variable or temporary table?
"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, 2014 at 8:34 am
You can also use DBCC FREEPROCCACHE and pass it the plan handle of the plan you want removed from cache.
NOTE: If you don't pass it a plan handle, 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
September 12, 2014 at 8:32 am
There's not much on the detailed internals of the in-memory indexes yet. The non-clustered index is still a b-tree, sort of. They also call it a bw-tree. The bw stands...
"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, 2014 at 8:28 am
Lempster (9/10/2014)
polkadot (9/5/2014)
"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 11, 2014 at 2:06 pm
GilaMonster (9/10/2014)
Grant Fritchey (9/10/2014)
I'd love to present with Gail again, regardless of the harm we would inflict on others. We had way too much fun.
Shall we try for Bits next...
"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 11, 2014 at 2:04 pm
tjaybelt (9/10/2014)
I have seen them together, and Grant is nowhere as good looking as Gail is. nor as tough and smart.
I agree with everything but the tough part.
"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, 2014 at 1:49 pm
Don't listen to Gail. We're actually just one person and you are the first to notice.
Thanks for the kind words. I'm glad the session was helpful.
I'd love to present...
"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, 2014 at 1:47 pm
Or, implement full recovery. Depending on the type of data, that might be a good idea anyway. It sure makes disaster recovery easier. Well, not easier really, but more effective.
"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, 2014 at 7:31 am
Viewing 15 posts - 7,471 through 7,485 (of 22,221 total)