New answers tagged

0 votes

Why could query performance improve enormous after db restore on new server with worse hardware?

I had a similar situation, but in my case I was creating a copy of the database on the same server (using a different name for the database), so there were no hardware differences. A query that was ...
user avatar
  • 101
3 votes

How to Get all Dates Between Two Dates in SQL

The key point here, is to have an "utility" table with numbers from 0 to a number (like 1000 or 10000, look for tally table on google : 1 , 2 ) and use it to join base on DATEADD(DAY, y....
user avatar
  • 3,676

Top 50 recent answers are included