(Grant Fritchey) At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer to: “How do join hints affect adaptive joins?”
Tag: sql server
(blobeater) When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee) about auto scaling capabilities.
(Cate Murray) Most companies, over 90% from one recent study, currently use an ATS (Applicant Tracking System) to process resumes/applications submitted for posted jobs and prioritize (i.e. with a relevant match score) whom to interview.
(Kenneth Fisher) No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom.
(Chris Webb) This is going to sound obscure, and it is, but recently I’ve been using the #table() intrinsic function in M a lot – specifically the version that takes a table type as its first parameter (as I describe here) – and because it’s a bit of a pain to have to write the M code for a table […]
(Joseph.Pilov) SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans.
(Pinal Dave) I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server.
(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL.
(Allan Hirt) If you’ve been in hibernation, today you woke up to a world where Microsoft has embraced open source and Linux. What was once unthinkable is now happening. What is going on? Why am I even talking about this?
(Grant Fritchey) If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that Azure SQL Studio has been changed to Azure Data Studio. I’ve got an early release on some of the bits. Let’s explore what’s going on.