General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008 R2
Likes (1)
Naomi Nosonovsky
Hi Kevin,
Sorry for delay getting back. The view was using a linked SQL server and a queried a number of views on different servers. Problem has been resolved by writing a stored proc that is run in an overnight job to create a results table. The query on the results table from the 3rd party app returns results instantly which has kept the end users happy.
Thanks for your input (and the Tips of the Day)
Andy
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only