PrepAway - Latest Free Exam Questions & Answers

Tag: sql server order by advanced

Which Transact-SQL script must you run on all three servers?

You are the SQL administrator for your company. You have three SQL Server 2008 computers named SQL1 , SQL2 , and SQL3 . Each server supports a single instance.
You have been asked to configure SQL1 to connect to remote data sources that use OLE DB. You have alsobeen asked to configure SQL2 to control CPU usage and to configure SQL3 to provide access to physicalmemory. Which Transact-SQL script must you run on all three servers?