New answers tagged sql-server-2008-r2
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 ...
- 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....
- 3,676
Top 50 recent answers are included