Viewing 15 posts - 2,521 through 2,535 (of 22,224 total)
I'd need to see more specifics around this. There's nothing magically or uniquely bad or dangerous about a LEFT JOIN when manipulating data, so there's got to be more 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
June 10, 2019 at 1:09 pm
Defining "used" may lead you to different ways of checking this. I would first get this definition so that you can understand what you then need to do to ensure...
"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
June 10, 2019 at 1:07 pm
Oh, god. It's really Dynamics. People were cracking jokes about this on Twitter.
Yeah, there is literally no easy way around this. Microsoft purchased this horrible piece of software and then...
"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
June 7, 2019 at 10:19 am
The only one of those that offers the slimmest of hopes is the log explorer. However, you better not have the log on simple recovery or that's a lost hope...
"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
June 6, 2019 at 7:40 pm
I will talk with developers to understand how the integrity of the data is maintained through the code without foreign keys. thank you for all the responses.
It won't...
"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
June 6, 2019 at 7:36 pm
You're missing Availability Groups and then all the third party solutions through software and hardware. Also not mentioned, just backing up the database on one server and restoring to another....
"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
June 5, 2019 at 12:45 pm
You are in a world of pain. There is literally no easy way out. At all. So very sorry.
If, and it's probably a huge "IF", you are lucky and they...
"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
June 5, 2019 at 12:41 pm
Query said:
...WHERE 1=0...
Comment in front of the query said:
-- WHERE 1 = 0
No explanation for it at all.
"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
June 5, 2019 at 12:23 pm
I have a bit of bittersweet news. After more than a decade of coaching youth soccer I am finally hanging up the whistle (although I never actually use one...
"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
June 3, 2019 at 5:55 pm
Just saw a joke.
Coach calls over little 8 yo player:
Coach: You know that I substitute everyone so you call get some time to play right?
Player: Yes
Coach: And you know we're...
"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
June 3, 2019 at 5:52 pm
sys.dm_db_index_usage_stats would be a good way to generally understand how data is accessed. It's not perfect. Here's a good article on it.
"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 31, 2019 at 12:43 pm
This is a resource I trust very much talking about this topic. His suggestion is to change the keys every two years. Read the article for more details.
"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 30, 2019 at 12:40 pm
SQL Server will grab the amount of memory it has available and continue to grab more of that to the max. It does this completely automatically, stopping only at the...
"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 30, 2019 at 12:37 pm
Yeah, agreed. In fact, it's a great practice to have a different account administering SQL Server instances on the box and one administering the operating system. It's the right kind...
"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 30, 2019 at 12:30 pm
So, memory is different. What else? Number of processors? Max Degree of Parallelism? Cost Threshold for Parallelism? ANSI connection settings? These are just the top server settings that lead 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
May 30, 2019 at 12:29 pm
Viewing 15 posts - 2,521 through 2,535 (of 22,224 total)