All Columns from user tables and views
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
758 reads
List all primary keys
Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!
2001-12-13
725 reads
Blogs
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Daily Coping 18 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Storage Field Day 23 – SIOS
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Forums
need some help in tweaking a query
Hi All, I am looking for some tsql help. I am from Oracle background....
SQL Server 2017 AlwaysON Secondary Replica use case
Hi All, I need some advice on Always on secondary replica usage. We are...
Ask SSC