Viewing 15 posts - 676 through 690 (of 22,224 total)
Well said Grant, Happy New Year!
Cheers!
"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
January 2, 2023 at 2:05 pm
"fuel save pro compatibility to ethernet in addition to Wi-Fi, and for that reason enable completely wireless operations and data ment. The consumer can switch the retrieved information by...
"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
January 2, 2023 at 2:04 pm
Happy New Year to you, too, Grant.
I only ever made one New Year's resolution (many years ago), and that was not to make any New Year's resolutions in 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
January 2, 2023 at 2:03 pm
There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.
Other...
"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
December 29, 2022 at 1:31 pm
There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.
Other...
"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
December 29, 2022 at 1:30 pm
There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.
Other...
"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
December 29, 2022 at 1:30 pm
Hourly log backups may not be frequent enough. Think of it like this. If the server crashed, you may lose up to an hour of data if you couldn't get...
"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
December 23, 2022 at 12:38 pm
You might try looking at the connectivity_error_ring_buffer_recorded Extended Event. It's one mechanism to track timeouts on connections. I think it might, possibly, maybe (did I put enough weasel words in?)...
"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
December 22, 2022 at 2:55 pm
Here are a few pointers for this common problem. Chances are very high that your databases are in FULL recovery mode, but that you don't have log backups set...
"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
December 22, 2022 at 1:08 pm
I am bringing in some help on this one. I may be horribly wrong in what I've been saying.
"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
December 21, 2022 at 1:25 pm
Are you letting constraint names or similar be automatically generated? That could lead to the issue. Stuff like that is likely the cause.
"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
December 21, 2022 at 12:30 pm
I work for Redgate, so take what I say with a grain of salt...
You want to go and get a copy of Redgate SQL Monitor. You can check it 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
December 20, 2022 at 1:12 pm
So, you should be able to merge changes from two different tables, just fine. Nothing SQL Source Control does this. It's all in the source control system. The issue 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
December 20, 2022 at 1:09 pm
Yeah, hard coding isn't perfection, but, that's the situation. Work within it.
The negative is, that index probably won't be used for a lot of SELECT queries since it doesn't eliminate...
"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
December 16, 2022 at 3:32 pm
Yeah, it should work as described.
"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
December 16, 2022 at 1:23 pm
Viewing 15 posts - 676 through 690 (of 22,224 total)