Count and display number of rows in all tables
This script can be used to display the number of rows of all the tables in a database.
2003-01-02
299 reads
Script to get tables which have primary key
There isn't a convenient sp or tool in sql server to find out all the tables in a database which have primary keys. This script can help you to list all the tables with primary keys.
2002-10-21
433 reads
Blogs
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...
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
Forums
COHESITY for Backup/Restore?
Any one have any experience with using Cohesity as the backup/restore platform instead of...
View runs slower
I have the following query SELECT DateADD(day,9-DATEPART(dw,cdata .call_datetime ),cast(cdata .call_datetime as date) ) as...
Parallel Load thousands csv Files
Hi, what is the fastest way to load thousands of csv files with the...
Ask SSC