Lab Sql

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

I'm looking for help on how to optimize (if possible) the performance of a SQL query used for r… Read more How To Improve Wind Data Sql Query Performance

I have database table contains around 3 millions records. When I delete large number of rows, aroun… Read more Delete Large Number Of Rows Is Very Slow - Sql Server

I've a table which I need to give unique constraint to multiple columns. But instead of creatin… Read more Using Multi Column Unique Indexes Vs Single Hashed Column

I want to select to retrieve person and also further make some inserts, deletes and updates. If I w… Read more Which Database Design Gives Better Performance?

Is this condition sargable? AND DATEDIFF(month,p.PlayerStatusLastTransitionDate,@now) BETWEEN 1 AN… Read more Is This Date Comparison Condition Sarg-able In Sql?

I've a table which I need to give unique constraint to multiple columns. But instead of creatin… Read more Using Multi Column Unique Indexes Vs Single Hashed Column