2017-06-16
1,847 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
755 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,134 reads
2017-01-30 (first published: 2017-01-26)
4,179 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,588 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
150 reads
Blogs
Getting Started with SQL Prompt 10
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Learn from the Troubles of Others
Comments posted to this topic are about the item Learn from the Troubles of...
Line breaks issue during import from excel file
Hi all, Newbie to sql management studio. I import data from excel and some...
Ask SSC