Tag Archives: T-SQL

Script to get row count for all tables in a SQL Server database

Script to get row count for all tables in a SQL Server database This post helps you in writing a Script to get row count for all tables in a SQL Server database. For any database developer or administrator the … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , | 5 Comments

SP_SPACEUSED is giving wrong counts

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment

How to generate script for multiple objects in a database – SQL Server

Generating script for Stored procedures and views in SQL Server 2012 Today I have got a question from one of the beginner DBA. He was actually asked to get “CREATE SCRIPT” for 35 stored procedures and 15 views from one … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment