I had a requirement today to delete all data from a sqlser ver database. This database has about 350 tables with a lot constraints. I manually started identifying the order of deletion absed on the constraints and realsied that this can't be done in a day. So I hit the good old google for help.
Here I found a very detailed explanation of how to easily achieve this by Susan Sales Harkins. Read More
Subscribe to:
Post Comments (Atom)
OneLake: The Heart of Your Data Universe in Microsoft Fabric
Imagine a single, unified data lake for your entire organization, accessible to every workload, without data duplication. That's the pow...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
No comments:
Post a Comment