T-SQL Script to backup all databases
Database backup is a must know task for a DBA. In this blog we’ll look at T-SQL script to backup all databases at once. The logic is to iterate through all …
Read MoreTag: Dynamic SQL
SQL Server Integration Services : Creating Dynamic SQL/MDX using Script Task
Of late I have been working on creating a lot of SQL Server Integration Services packages and a new trick that I have come up with is to use a Script Task …
Read Moresp_executesql help in plan reuse in SQL Server
Hi Friends, In one of my recent assignments, I was demonstrating Plan Caching & Recompilation and someone talked about dynamic SQL helping in plan reuse. That triggered me to show this …
Read More