Viewing 15 posts - 856 through 870 (of 22,232 total)
I've seen no types of standard degradation between 2017 and 2019. So, I'd suggest examining all the server settings, cost threshold, the things already suggested here.
"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 30, 2022 at 2:59 pm
Are you looking at servers, VMs, or are you looking at Azure SQL Database? How big are the VMs you're looking at, memory, cpu, disk, etc? For such a small...
"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 29, 2022 at 12:26 pm
IF your login and the service account are different (and oh, I hope they are), then your login may not have the same access to the underlying OS as 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
June 29, 2022 at 12:25 pm
Homework?
A company can have many workers. So, you already have two tables. Company has many workers. Probably the company is the parent, the worker is the child. So, the PK...
"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 29, 2022 at 12:19 pm
Up front, not an expert in your programming language, Macs or MySQL.
Sounds like you're building a cloud-based app. I'd say you need to have a cloud-based database. I'd look 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 29, 2022 at 12:16 pm
Are you trying to get up to the moment recovery, or do you just want a copy of the database and transactions that may, or may not, be in flight...
"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 28, 2022 at 12:18 pm
So, the logs in log shipping can be used as point in time recovery. Therefore, secondary log backups seem redundant, and yeah, they could lead to a truncation 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
June 28, 2022 at 12:15 pm
I get it. Dealing with NULL is a pain. However, it's a unique value and has unique functions. Follow Phil's advice. Use IS NULL and IS NOT NULL instead 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
June 28, 2022 at 12:06 pm
For introductory stuff, I always asked these questions. Obviously, a few would need to be updated, it being 2022 & all. However, I'd still say these were pretty basic,...
"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 27, 2022 at 1:51 pm
The easy way is to look in the SQL Server error log. It'll tell you. You can also see it in the Windows event log. Pretty sure you automatically 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
June 17, 2022 at 1:56 pm
I would not recommend pursuing replication. It's very old technology that gets almost no love from Microsoft at all. You honestly sound like a perfect candidate for Availability Groups. Yes,...
"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 17, 2022 at 1:52 pm
Not a Data Factory person, but I do a lot of work in Azure.
Strong recommendation, look for videos or blogs. There are exceedingly few books written on Azure because 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
June 17, 2022 at 1:46 pm
Thank you for your response. I will research on your three suggestions.
Given that the primary key is included in the non-clustered index I have the following questions.
Just to clarify...
"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 15, 2022 at 2:21 pm
Well, AI, believe it or not, Microsoft Azure is where I'd go to look. There's some amazing stuff going on there.
I'm absolutely NOT an AI expert of any kind. However,...
"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 15, 2022 at 2:13 pm
You want to look at date functions like EOMONTH. Here are some samples that are pretty much what you're looking for.
"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 15, 2022 at 2:09 pm
Viewing 15 posts - 856 through 870 (of 22,232 total)