(Pinal Dave) Earlier this week, I blogged about Database Performance Analyzer – Table Tuning Advisors and I received quite a lots of request to elaborate more on the topic of Table Tuning Advisors.
Tag: sql server
Faceted Search and Filtering in Power BI Reports
(Siddharth Mehta) Data search is a very common requirement and filters in reports is one way of letting users search the data and adjust the scope of data as desired. When reporting with large datasets, reports tend to have a substantial number of records on a single screen and even filters can have
SQL SERVER – Database Performance Analyzer – Table Tuning Advisors
(Pinal Dave) I am a SQL Server Performance Tuning Expert who acts as a consultant for many organizations across the world who have performance tuning issues.
Adaptive Joins and Join Hints
(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?”
Auto-Scaling Azure SQL DB
(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.
Applicant Tracking System Resume Tips to Get Noticed
(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.
Escaping strings
(Kenneth Fisher) No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom.
A Function To Generate The M Code For A Table Type
(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 […]
Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server
(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.
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
(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.