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.
ALTER PROC [dbo].[spNC_BookingWizard] @StartDate varchar(10) = '1/1/1900', @EndDate varchar(10) = '1/1/2010', @Employee varchar(200) = '', @Facility varchar(200) = '', @Status varchar(200) = '', @test bit = 0 AS SET NOCOUNT ON DECLARE @dtStart datetime DECLARE @dtEnd datetime SET @dtStart = CONVERT(datetime, @StartDate) SET @dtEnd = DATEADD(dd, 1, DATEADD(dd, 0, CONVERT(datetime, @EndDate))) ........... SELECT * FROM #tmpBook WHERE StartDate_date >= @dtStart AND StartDate_date <= @dtEnd AND Facility = @Facility AND EmpName = @Employee AND BookingStatus = @Status
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.