List all tables and their respective information.
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,479 reads
List Jobs and their respective programming.
List all active Jobs in SQL Server with the details of the schedule.
2013-02-25 (first published: 2013-02-07)
1,293 reads
Blogs
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query...
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Forums
TOP with Order By alternative, performance results look mixed
Hi I have a situation where I am testing two versions of the same...
Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019
I'm looking for best practice here and these are Azure VMs by the way....
Azure availability groups requirements question
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Ask SSC