2017-06-16
1,864 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
817 reads
SQL Server Cluster Automatic Memory Management
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
1,719 reads
2017-01-30 (first published: 2017-01-26)
9,476 reads
Get Table Sizes and Percent of Database Size
This script uses two undocumented stored procedures that retrieve all tables in the database in which it is run and lists the data and index sizes, the sum of these sizes, and the table's size percentage of the entire database. The results are presented in descending order of the sum of the data and index […]
2004-11-24 (first published: 2004-10-25)
1,773 reads
Find Instances of a Column Name
This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
152 reads
Blogs
Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
Power BI and a Star Schema
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
A New Git Default Branch
By Steve Jones
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...
Forums
How to write update query to check exist column by value 1 where it exist on tab
How to update check exist column by value 1 where partid exist on table...
User unable to see Logins after recreation of permissions in new instance
Hello All I was tasked with setting up a new instance on the same...
Monitor SQL Server Error Logs with PowerShell
Comments posted to this topic are about the item Monitor SQL Server Error Logs...
Ask SSC