#querytuning

[simple-logic]

#PollTime

What improves database performance?

A) Indexing 📌

B) Sharding 🔀

C) Caching ⚡

D) Query Tuning 🎯

Comments your answer below👇

💻 Explore insights on the latest in #technology on our Blog Page 👉 https://simplelogic-it.com/blogs/

🚀 Ready for your next career move? Check out our #careers page for exciting opportunities 👉 https://simplelogic-it.com/careers/

[ethanbiden2023]

Welcome. We are a team of specialists on SQL Server. We specialize in SQL Server Health Check & Performance Tuning. Our popular learning solutions include Video Courses, Master Classes, Lab Kits & Hands-On-Labs. And sometimes we do free online trainings too. Take a glance at our corporate services, you might find something that you are looking for.

We have a comprehensive video library with short SQL Tutorials and full-length sessions. You can become a member (free) and download tons of free resources.

[techskills-blog1]

Correlate SQL Profiler and Performance Monitor data

http://bit.ly/2HnX2im

[scarydba]

So often I get asked how to improve performance within SQL Server. I make a set of suggestions only to be told that no changes can be introduced. Well, without changes, you can't improve performance. In this video I review exactly what you need to do in order to improve performance within SQL Server. There are only two choices and you have to pick one. #sqlserver #performancetuning #querytuning

[dbareactions]

When the end user comes in and says, "Who can I talk to about a slow query?"

[dboting]

To MERGE or not to MERGE

[scarydba]

I'll be presenting a regular session, a Redgate session, and most important of all, a full day of training at SQLBits 2019 in Manchester in the UK. In this video I talk about some of the details of what I'm going to present during that all day event. Follow this link for all the details: http://bit.ly/2TlvKjy #sqlbits #querytuning #performance

[dbareactions]

When I'm reading a long query with no line breaks

[dbareactions]

When I show the user group the query I had to tune today

[dbareactions]

When the developer keeps shooting down my suggestions for fixing the query

[dbareactions]

After I told the developer that it would take a Microsoft Certified Master for his query to go fast