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.
SELECT employee_nbr, date_hire, term_date FROM lawson_temp
;WITH Tally AS (SELECT TOP 366 n = ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 FROM sys.columns) SELECT Mondays = AllDays FROM Tally CROSS APPLY (SELECT DATEADD(day, n, 2013)) x(AllDays) WHERE (DATEPART(Quarter, AllDays) = 1) AND (DATENAME(Weekday, AllDays) = 'Monday') AND (DATEPART(YEAR, AllDays) = 2013)
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.