A developer's diary

#query-tuning

Articles tagged with #query-tuning

Dec 18, 2024
Dec 18, 20243 min read82 views
Optimizing LINQ Queries for SQL Server Bit Fields
Introduction In SQL Server, the bit data type is used to store boolean values (0 for false, 1 for true). However, when working with SQL Server in a .NET application using Entity Framework or LINQ to SQL, the bit field is automatically converted to a ...
3 min read82 views
Oct 21, 2022
Oct 21, 20221 min read49 views
How to get rid of Sort Cost ?
Place the name of the column you use with order by at the end of the index. Query : select ExceptionMessage, CreateDate from TableName where MethodName = 'ERROR' order by TerminalNo First index : CREATE NONCLUSTERED INDEX [IX_TableName_MethodName] ...
1 min read49 views

#query-tuning - A developer's diary