Skip to content Skip to sidebar Skip to footer
Showing posts with the label Performance
Sqlserver Case Expressions - Short Circuit Evaluation?

Sqlserver Case Expressions - Short Circuit Evaluation?

Post a Comment
I am trying to optimize a query that does something like this: SELECT ... CASE WHEN (conditio… Read more Sqlserver Case Expressions - Short Circuit Evaluation?
Convert Select-endselect In For All Entries With More Table

Convert Select-endselect In For All Entries With More Table

Post a Comment
I would like to convert this SELECT-ENDSELECT into FOR ALL ENTRIES to have better performance. LOOP… Read more Convert Select-endselect In For All Entries With More Table
Find Out Which Query Increasing Dtu In Sql Azure

Find Out Which Query Increasing Dtu In Sql Azure

Post a Comment
I am using SQL Azure SQL Server for my App. The DB tier, which my app was in was working perfectly … Read more Find Out Which Query Increasing Dtu In Sql Azure
Is Bit Field Faster Than Int Field In Sql Server?

Is Bit Field Faster Than Int Field In Sql Server?

Post a Comment
I have table with some fields that the value will be 1 0. This tables will be extremely large overt… Read more Is Bit Field Faster Than Int Field In Sql Server?
Sql: Speed Improvement - Left Join On Cond1 Or Cond2

Sql: Speed Improvement - Left Join On Cond1 Or Cond2

Post a Comment
SELECT DISTINCT a.*, b.* FROM current_tbl a LEFT JOIN import_tbl b … Read more Sql: Speed Improvement - Left Join On Cond1 Or Cond2
Sql Query Performance Question (multiple Sub-queries)

Sql Query Performance Question (multiple Sub-queries)

Post a Comment
I have this query: SELECT p.id, r.status, r.title FROM page AS p INNER JOIN page_revision as r … Read more Sql Query Performance Question (multiple Sub-queries)