Forum Replies Created
Viewing 15 posts - 2,596 through 2,610 (of 22,224 total)
-
Reply To: Can using a scalar UDF actually improve performance?
Jeff Moden wrote:p.s. I'm not 100% sure but I don't believe they've disabled the ability to turn ANSI NULLs off yet in 2017. It has been an advisory for many years,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Trying to see all records
pk400i wrote:So this should be fine? select a.*, b.full_name from alt_id_view a left outer join all_clients_view b on a.people_id = b.people_id It's only bringing in the matched so it could...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: How to unsubscribe from an Author?
I'm seeing an Unfollow link. I just followed you. Below your name, it says Unfollow on the left:
Does that work?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Are the posted questions getting worse?
Thom A wrote:In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into it,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Are the posted questions getting worse?
Thom A wrote:Luis Cazares wrote:I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative votes...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Connect to SQL Database in Visual studio 2017 via Active directory
Sounds like you're not logging in correctly to Azure then. You can only use Azure Active Directory, not the regular kind, or, a SQL login, which you say you don't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Connect to SQL Database in Visual studio 2017 via Active directory
Connections should be exactly the same. What's the error?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Help in SQL server
Also, look up Ola Hollengren's scripts for backups. They'll serve you well.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Are the posted questions getting worse?
Luis Cazares wrote:Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: SQL VIEW works on its own but not when combined
Matt Miller (4) wrote:Since you're not at liberty to share the queries - the only input I would have is - eat the elephant one bite a t a time. The one...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: How to restore an on-premise database to an existing Azure SQL Database?
Wait. Managed instance is different. They want that to be a lift & shift location. You can run a restore there. That's different than Azure SQL Database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: SQL VIEW works on its own but not when combined
Reading execution plans is fairly complicated. Follow the link below, or look it up online to find a free book I wrote on the topic. Work tables aren't bad (or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Certification advice help
There's going to be work for data professionals for a VERY long time to come. That work will shift and change, as it already has. So yeah, it's a fine...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: How do i get around this "parameter has already been defined" error?
Can you post the rest of the code? If it says parameter has been defined, that means you're defining a parameter, but we can't see that in what you posted.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: How to restore an on-premise database to an existing Azure SQL Database?
You can't.
You can use migration to replace it. You can use Azure Sync, but you have to set that up and program it. You can use something like Redgate Data...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 2,596 through 2,610 (of 22,224 total)