Viewing 15 posts - 691 through 705 (of 22,227 total)
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
Ordering by a function is just going to kill you more and more as the data grows. Best suggestion I can make is to not do that. Nothing will make...
"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:22 pm
Nothing marks a table as being "used" by queries. You can look at sys.dm_db_index_usage_stats, assuming the table in question has indexes. That will tell you something of the access...
"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:18 pm
Create a file group in a different location and move those indexes to that file group.
"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:14 pm
Your best bet to see missed connections is setting up an Extended Event session and capturing the even connectivity_ring_buffer_recorded. That's the one mechanism I know that captures stuff like timeouts....
"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 12:47 pm
Does Red Gate SQL Monitor use Profiler traces or Extended Event traces?
By default, neither. It supports both. Extended Events is first though. We have several metrics that are taking...
"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 14, 2022 at 7:22 pm
OOps. Sorry. And yeah, that's really odd.
"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 14, 2022 at 7:11 pm
Another one?
Test
"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 14, 2022 at 1:43 pm
Post 16 in test
"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 14, 2022 at 1:43 pm
Sounds like you have encrypted connections enabled, but haven't set up certificates for those connections. How do you resolve it after the reboot currently?
"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 14, 2022 at 1:43 pm
Not one I've personally hit, but it looks like it's likely to be a permissions issue based on this article from Microsoft.
"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 14, 2022 at 1:42 pm
Latency?
I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.
It 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 13, 2022 at 3:31 pm
First time I've hit. Just a little test, since I'm only running on a local machine with a container for a database, turning off Encrypt and you don't need 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
December 13, 2022 at 2:15 pm
Viewing 15 posts - 691 through 705 (of 22,227 total)