Technical Article

Know all Database sizes in a server.

We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use  and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every […]

3 (2)

You rated this post out of 5. Change rating

2003-09-16

1,657 reads

Technical Article

Get BCP out for all tables in a DB

           The script mentioned below will export data in all tables into textfiles to a physical path on your system using BCP utility from a Database. The sql commands used in this stored procedure are BCP utility,Identity function and temporary tables.    Here you required to give 4 input parameters, they […]

You rated this post out of 5. Change rating

2002-03-15

2,189 reads

Technical Article

Rows count for each and every table in a DB 

       By using this script one can find number of rows for each and every table in a database. Just cut and past this script in your DB and excute. A stored procedure will be created as 'Get_rowcounts_for_eachtable'. If U excuted this stored procedure, U can get all tablenames and rowcounts for respected […]

You rated this post out of 5. Change rating

2002-03-07

584 reads

Blogs

Using T-SQL Snapshot Backup - Multi-Array Database Snapshots

By

In this post, the fourth in our series, I want to share an example...

AIs Struggle with Family

By

This post looks at a logic problem asked to an AI, and which is...

Advice I Like: Why am I doing this?

By

You are never too young to wonder “Why am I still doing this?” You...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Building SSIS Custom Task

By bodempudi111

Hi Everyone, Greetings of the day! I am working on building SSIS Custom task...

Visit the forum

Question of the Day

Precision and Scale I

I have this number: 456.23 What is the scale of this number?

See possible answers