As of today, after a one year and a half long process of writing and preparing, the book that gives you the solid basics in Transact-SQL Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics is now on Amazon in Kindle format. Select your market: USA Canada Great Britain Australia […]
There is a great news today for SQL Server community – SQL Sentry (RSS: SQLPerformance.COM) Plan Explorer is FREE for everyone. Download User Guide Thank you, SQL Sentry! Keep it simple :-)
In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]
A FREE webinar that will present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics book and will teach you how to: create tables, insert, update and delete data into them select data from existing tables aggregate data will take place Sat, Aug 13, 2016 10:00 AM – 11:00 AM Eastern Daylight Time […]
When we create dynamic SQL code, we can add the parameters in two ways: Concatenate them into the dynamic code with + Use sp_executesql
In some situations a scheduled shrink of the log files is needed to release disk space. The script bellow can be scheduled in SQL Server Agent Job.
Let’s say that we have a SP with predefined parameters, i.e. @Parameter1 can hold values 1, 2 or 3; @Parameter2 can hold values of A, B, C or D and so on. This script creates all the possible combinations for the parameters of the SP and executes the SP as many times […]