Viewing 15 posts - 4,381 through 4,395 (of 22,227 total)
I don't completely understand what you're asking? Can you expand on what it is that you expect to return? What's the data structure you're pulling information from?
"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 28, 2016 at 11:43 am
There's no way logically that can work because you would be joining all three columns on all three columns. The syntax doesn't support it and the language doesn't either.
Can 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 28, 2016 at 11:42 am
You would have to poll all the tables in the database, one-by-one, to determine if there are changes. That's a poor approach. You could read the log using DBCC LOG...
"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 28, 2016 at 11:39 am
Going to a heap in the hopes that you get improved compression is not the way to tune queries. If that clustered index is in use, it needs to stay...
"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 28, 2016 at 11:32 am
A view doesn't have statistics.
A materialized view does, because a materialized view is an index. You can't drop statistics from an index.
"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 28, 2016 at 7:16 am
I think I'd add another table in there. Instead of having a direct link between ProductPropertyType and ProductPropertyValue, I would define the values, the properties, and then have a 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 28, 2016 at 7:14 am
Eric M Russell (9/27/2016)
Talib123 (9/27/2016)
I'm a production DBA and have been for a good while.
I can query, join filters but how do I get my T-sql skills 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 27, 2016 at 8:54 pm
There has to be something else causing the issue. If you're seeing different execution plans, it's because the mechanisms used to generate those plans have different inputs.
"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 27, 2016 at 8:52 pm
psred (9/27/2016)
"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 27, 2016 at 1:57 pm
psred (9/27/2016)
"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 27, 2016 at 1:55 pm
shanegair (9/27/2016)
Sorry I am not relaying clear information. I want all records with UOM_Control = 'S' and only UOM = 'LBS' where UOM_control = 'C'
Then logically, you have an...
"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 27, 2016 at 10:15 am
If you're getting wildly different plans between servers, there has to be differences. The differences can be in the statistics on the data in the database. The differences can be...
"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 27, 2016 at 10:13 am
Rich Mechaber (9/27/2016)
"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 27, 2016 at 8:33 am
Yeah, Columnstore is a good thing is you're doing lots of aggregates in the reports. If we're doing point lookups & just general data retrieval though, it falls down badly....
"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 27, 2016 at 8:28 am
Also, what is the Recovery Point Objective, the amount of data that the company is willing to lose during the log shipping operation. The answer is always zero, but zero...
"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 27, 2016 at 7:58 am
Viewing 15 posts - 4,381 through 4,395 (of 22,227 total)