Guy GlantserMar 9, 20182 minWhich One is Better? IN or BETWEEN?I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something like this: SELECT...
Eitan BluminFeb 27, 20183 minPlanning to Increase Cost Threshold for Parallelism – Like a Smart Person!When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see SQL Server creating and...
Madeira TeamFeb 15, 20181 minExtremely easy tricks to list table columns’ names and replace SELECT *Everyone knows the simple T-SQL “SELECT * ” is bad practice. It can: Effects the execution plan (Table / Index Scan); Returns too much...
Madeira TeamJan 23, 20172 minDatediff: We’ve Been Doing It WrongOne of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of...
Madeira TeamSep 29, 20161 minPerformance-Oriented T-SQL Development in BelgiumOn October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s...
Madeira TeamJan 19, 20165 minHow to Solve the Tail Insert ProblemIn the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s problematic. In a...