pacreely questions

pacreely answers

• SQL Server - Sum time display issue
• Is there an alternative to SET STATISTICS TIME which also shows the statements?
• Combining two queries together to form month count
• Entity Framework Core connect to MSSQL database over SSH tunnel
• Why query optimizer selects completely different query plans?
• How to avoid UPDATE statement locking out the entire table when updating large number of records
• Sort order of an SQL Server 2008+ clustered index
• Calculate Total Working Days of month