In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
DECLARE @variable varchar(20) SET @variable = '"SEARCH CRITERIA"' SELECT 'Starting a query based on the criteria of: ' + @variable + '. This may take a while.' AS 'Intro that allows double check of criteria. ______________________________________' --GO WAITFOR DELAY '00:00:05.000' --just to simulate the time required to run the query. Often 10 minutes or more. SELECT 'This is a long running query based on ' + @variable + '.' AS 'Main Query ________________________________________'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.