April 9, 2014 at 9:23 am
I have query which populates a table.
I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that I can pull reports from that single table?
Could you advice me the best approach for this?
April 9, 2014 at 10:46 am
Sarwan (4/9/2014)
I have query which populates a table.I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that I can pull reports from that single table?
Could you advice me the best approach for this?
Choose which server is going to host your table. Then execute that query against each server and store the results in the table on the server you chose.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 10, 2014 at 1:54 am
Sarwan (4/9/2014)
I have query which populates a table.I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that I can pull reports from that single table?
Could you advice me the best approach for this?
The easiest way to implement this - in my opinion - is to build a small ETL process with SSIS that gathers the data from all the servers and stores it in a single server. That way you won't have to use linked servers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply