Viewing 15 posts - 7,471 through 7,485 (of 22,219 total)
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
Other choices include using SQL Server Integration Services (SSIS), bulk insert, linked servers and regular t-sql, or just use a programming or scripting language to connect to both servers. 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 8, 2014 at 6:39 am
A trigger is probably a good choice (depending on what the job does). Another approach would be to have the job run on a regular basis, once a minute or...
"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 6:36 am
Viewing 15 posts - 7,471 through 7,485 (of 22,219 total)