Want to dramatically accelerate your data processes?
As an experienced SQL Server specialist, I deliver proven results:
from 7.5 hours down to 13 seconds, from 8.5 hours down to 6 seconds.
I provide ready-to-deploy solutions for script optimization, database development, process automation, and reporting.
Clearly documented, robustly built, production-ready.
-- Legacy code, takes forever to run
SELECT {Many_Fields} FROM [Huge_Tables] H WHERE H.Name LIKE '%John%'
-- Get the same data 2000 times faster
WITH [OptimizedCTE] AS (
SELECT /* optimized script */
)
CREATE PROCEDURE [dbdev].[procCreateSchema] (@SchemaName NVARCHAR(128))
AS
BEGIN
DECLARE @SQL NVARCHAR(200) = 'CREATE SCHEMA ' + @SchemaName + ' AUTHORIZATION [dbo];'
IF NOT EXISTS (
SELECT 1
FROM INFORMATION_SCHEMA.SCHEMATA S WITH(NOLOCK)
WHERE S.SCHEMA_NAME = @SchemaName
)
BEGIN
EXEC (@SQL)
END
END
GO
