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 ...
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....
Top 50 recent answers are included
Related Tags
sql-server-2008-r2 × 3794sql-server × 2628
t-sql × 356
sql-server-2008 × 338
performance × 219
sql-server-2012 × 170
backup × 123
index × 112
replication × 111
permissions × 104
ssis × 96
ssms × 95
query-performance × 83
security × 74
transactional-replication × 71
sql-server-2014 × 70
restore × 70
sql-server-agent × 66
stored-procedures × 65
linked-server × 63
transaction-log × 61
mirroring × 56
sql-server-2005 × 52
database-design × 51
index-tuning × 50