You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement to hardest.
2019-07-12
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
1,297 reads
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
1,919 reads
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,929 reads
I have a lot of co-workers who use sp_who and sp_who2 to see who’s...
By Kamil
Another week passed. Look what did I find during that time. Press British Airways...
By HamishWatson
This blog post is around the changing landscape of both SQL Server and the...
I have a table used for staging during ETL. It is empty most of...
Hello, I have set up and configured xp_cmdshell using a proxy account and I...
Ask SSC