Eitan BluminMar 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 ... FROM dbo.LotsOf...
Eitan BluminMar 2, 20182 minUse Filtered Statistics to Improve Performance on Very Large TablesLet’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality estimator and no partitioning. The table ha...
Eitan BluminFeb 27, 20184 minPlanning to Increase Cost Threshold for Parallelism – Like a Smart Person!Planning to Increase Cost Threshold for Parallelism When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see ...
Eitan BluminJan 8, 20183 minWhat Do You Do When Performance Sucks?So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time. Users constantly complain about poor performance, and the d...
Eitan BluminMay 10, 20172 minMy Session about SQL Server ParameterizationLast month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Param...
Eitan BluminMay 3, 20171 minVideo: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query ExecutionIn this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution flow for running queries, and how to watch the live ex...
Eitan BluminMay 2, 20171 minSQL Server 2016 for Performance Tuning LoversLast week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of fun and actually felt more like a...
Eitan BluminJan 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 those is the use of th...
Eitan BluminDec 12, 20169 minSQL Server DBA Tips that Can Save Your AssOn November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA Tips that Can Save Yo...
Eitan BluminJul 21, 20151 minSpeaking about Columnstore Indexes at PASS Performance PaloozaThe PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great s...
Eitan BluminJan 28, 20141 minKnow When it’s Good EnoughHere’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even mo...
Eitan BluminDec 10, 20133 minT-SQL Tuesday #49: Using CXPacket Waits to Detect Query BottlenecksThis post is for T-SQL Tuesday #49, the monthly blog party of the community. This tradition was started by Adam Machanic (blog | @AdamMachanic), and this mon...
Eitan BluminJun 11, 20134 minNested Loops, Parallelism and ConfusionI’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in love with T-SQL and SQL Server, got to a poi...
Eitan BluminMar 20, 20134 minThe Axis Of EvilViews, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey trap: They don’t sc...
Eitan BluminSep 8, 20122 min5 Performance Killers When Working With Linked ServersIt’s important to write the right code on the right server, since each mistake can be very expensive in this area. Below are a few common mistakes when worki...
Eitan BluminJul 27, 20121 minmax data types performanceOn some occasions, migrating from text, ntext or image to varchar(max), nvarchar(max) or varbinary(max) can hurt performance. How is that possible? Well, whe...
Eitan BluminMay 7, 201210 minService Broker Sample: Multi-ThreadingIntroduction Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in reality, many DBAs ...
Eitan BluminJan 5, 20128 minLOOP, HASH and MERGE Join TypesToday I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences, best practices and complexity....
Eitan BluminNov 28, 20113 minCollations vs. PerformanceRecently I’ve stumbled upon an apparently little known fact about SQL Server – specifically SQL Server collations and how they affect performance. During a n...
