Viewing 15 posts - 181 through 195 (of 22,219 total)
Trying doing it without compressing it. Backups are compressed by default ever since... 2014?... and zipping or tar or whatever, can affect the files.
"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 24, 2024 at 6:26 pm
I've worked on SQL Server databases for 30 years now. I've written multiple books on the topic of query tuning. I want to lead in with that because the 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 24, 2024 at 6:24 pm
If, and this is a big one, there are zero data types, indexes, settings on any of those, that are incompatible between versions, this will not work.
What you can try...
"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 24, 2024 at 6:16 pm
Thank you for the cautions, Grant.
I always develop xEvents related stuff on my local box, then on a dev box, then on a QA box and only then ....
As...
"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 24, 2024 at 12:51 pm
You beat me to to use of phone iconography. It's not just cell phones though. We have "desk phones" in the form of VOIP on our PCs. There's no...
"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 23, 2024 at 1:48 pm
Hey Johan! I don't think debug_channel is an event. There is a Debug Channel in Extended Events, but it's a grouping of the events that are undocumented, minimally documented, and...
"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 20, 2024 at 12:46 pm
Just to be clear, nothing in a derived table, in and of itself, is necessarily a problem for the optimizer, resulting in poor performance. It's the specific implementation of your...
"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
August 29, 2024 at 12:23 pm
To a very large degree, a VM is a VM. If it's running locally, Azure, AWS, Google Cloud, doesn't matter. Yes, there are SQL Server configured VMs to pull 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
August 29, 2024 at 12:21 pm
It does sound like your login doesn't have access. Might be time to reinstall. If you picked Windows auth only and didn't add your login appropriately, getting in to this...
"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
August 29, 2024 at 12:17 pm
Ah, I do miss those parties.
"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
August 28, 2024 at 12:29 pm
Also, if a lot of code is generated, then the process of literally learning how to write that code is also going to be curtailed. Getting from junior to senior,...
"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
August 26, 2024 at 5:23 pm
Grant is right about the benefits of having interests outside of work and family. I am a member of the Tadley Men's Shed, and enjoy a lot of 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
August 26, 2024 at 12:17 pm
Grant, how did you find out about your local maker's faire? Is there an organization that tracks that sort of thing?
There is an organization in town that runs a...
"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
August 26, 2024 at 12:16 pm
. In practice it is very rare that a copy of Prod, even when scrambled, will be adequate for the needs of Dev.
I find that prod data is...
"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
August 19, 2024 at 6:37 pm
I've never used it, especially not in anger, so I've got nothing. However, I've reached out to see if I can get someone over here to help out.
"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
August 13, 2024 at 12:07 pm
Viewing 15 posts - 181 through 195 (of 22,219 total)