Viewing 15 posts - 811 through 825 (of 22,220 total)
Please, no, don't start throwing hints all over it. Instead, focus on getting the execution plan and understanding what it is telling about how the query is behaving and how...
"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 9, 2022 at 7:07 pm
Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a bacpac, an...
"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 9, 2022 at 7:02 pm
I guess you need to ask yourself, how likely is it that you're going to go back to Week 17 of Year 6 in your 10 years of weekly backups?...
"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 9, 2022 at 6:57 pm
You can do exactly that for the databases. However, there will be the downtime of copying them over to the new server prior to attaching them.
However, the system stuff, logins,...
"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 7, 2022 at 4:25 pm
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀
Same...
"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 7, 2022 at 3:25 pm
Hey all!
Back from sabbatical. Happy to see we're still talking deadlocks. Ha!
"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 6, 2022 at 11:35 am
I was just troubleshooting a similar issue to find the difference was the default database assigned to the user accounts. After getting query execution plans for both logins (which...
"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 17, 2022 at 2:04 pm
...do you rely only on objects in LINQ to "join" tables?
Yes. You will be hard pressed to find join in any EF tutorials; other than just the places...
"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 16, 2022 at 2:14 pm
One more small thing: if we are dealing with poor database design, sometimes neither tuning nor hardware helps.
PREACH BROTHER!
Writing the final chapter of the book, and the first section...
"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, 2022 at 3:10 pm
Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...
"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 12, 2022 at 2:16 pm
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
@Grant ,
Awesome... I don't know...
"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 12, 2022 at 2:12 pm
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
@Grant ,
Awesome... I don't know how...
"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
July 26, 2022 at 11:27 am
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
"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
July 25, 2022 at 1:18 pm
Have fun with the baseball. Most fun I've had is going to the games with Allen White. I like watching him watch the game. Far more fun than the game...
"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
July 19, 2022 at 7:56 pm
Thanks Rick, but I'm not actually going to Gettysburg this trip. Sorry for the confusion. This time it's Pea Ridge and Vicksburg.
"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
July 19, 2022 at 7:55 pm
Viewing 15 posts - 811 through 825 (of 22,220 total)