Category: System Objects

Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, System Objects, Transact-SQL, tSQL

TSQL Query to List Tables in a Database with Row Counts

Justin Cooney
Row Counts
Row Counts

In a previous post I talked about how to find highly populated tables in a database. I’m going to expand on that in this post to show how to catalog a database into data-holding tables and supporting details tables. Continue reading “TSQL Query to List Tables in a Database with Row Counts” →

Advertisement
Programming, Software, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, System Objects, Transact-SQL, tSQL

Steps Restore a SQL Server Database into a New Database and Rename it

Justin Cooney
If you want to create a working backup of one of your production databases that you can use without jeopardizing the production data, you’ll need to copy the database in its entirety to a new name. In this article I’ll review the steps you need to use to do this (in SQL Server Management Studio 2014).
Also, if you find this article helpful, feel free to check out the other articles on my site covering various SQL examples at: https://jwcooney.com/category/sql/

Continue reading “Steps Restore a SQL Server Database into a New Database and Rename it” →

Database, Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, System Objects, Transact-SQL, tSQL

T-SQL Find Highly Populated Tables in a Database

Justin Cooney

When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS).

If you are interested in this topic, then I’d suggest also reading my article on batch searching your SQL Server database to find out in which tables the information is being stored.

Continue reading “T-SQL Find Highly Populated Tables in a Database” →