2003-11-20
260 reads
Truncate all tables in a database
This script creates a temp table of all the tables in a database and loops through a cursor to truncate them.
2003-11-20
265 reads
Blogs
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Forums
Update parent row from child row that has partial data.
On the same table I have table rows that are broken from the import...
Space issue on a table
All, I am working on implementing table partitioning on a existing table. The...
SSIS compoenents
For SSIS to pickup any dll componenet where do we need to deploy? some...
Ask SSC