Viewing 15 posts - 3,571 through 3,585 (of 22,227 total)
Piling on a little. Yes, if the first three columns make the data unique, then you can duplicate the data in DEF as long as ABC is different each time....
"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
November 6, 2017 at 4:12 pm
"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
November 6, 2017 at 6:22 am
You're working in Azure. That's great. Just shift your brain a little and think differently about the solutions. The old style methods of having all the servers in a common...
"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
November 6, 2017 at 6:11 am
sys.dm_exec_query_stats stores aggregate information about queries currently in cache. It won't show executions for any given moment in time. It's only ever aggregate information. It's not historical. Further, anything 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
October 28, 2017 at 7:52 am
TLDR Answer: Nope.
Long Answer: On SQL Cruise back in August, we had Bob Ward. Fantastic experience getting to hang out with the driving force behind a lot of...
"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
October 28, 2017 at 7:43 am
"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
October 28, 2017 at 7:31 am
"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
October 28, 2017 at 5:15 am
"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
October 27, 2017 at 11:16 am
I just got news of a new modeling tool. I haven't looked at it. If any of you feel like being a sacrificial anode, here's the link.
"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
October 27, 2017 at 10:35 am
Lynn Pettis - Friday, October 27, 2017 9:54 AMAnyone remember what last Version of Visio that supported reverse engineering of databases?
It was 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
October 27, 2017 at 10:34 am
"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
October 27, 2017 at 10:31 am
Normalize the data structure, first. Use primary keys and enforced constraints through foreign keys. Next, put an index on the na_id column. Without it, you're scanning the entire table 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
October 27, 2017 at 10:29 am
Huge topic.
I polled a room of data professionals this week while speaking at a paid event, 56 people. All of them are using virtualization in one capacity 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
October 27, 2017 at 10:26 am
The execution plans are neither good or bad, they just are. They resolve as needed to make the query work.
Yes, the query, when correctly written of course, will...
"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
October 27, 2017 at 10:15 am
"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
October 27, 2017 at 10:11 am
Viewing 15 posts - 3,571 through 3,585 (of 22,227 total)