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,656 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,148 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

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Test Data Manager in Under 10 Minutes

By

Test Data Manager (TDM) is a suite of products from Redgate that make it...

T-SQL Tuesday #176 One piece of advice that you wish Past you had

By

This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...

Read the latest Blogs

Forums

Add custom toolbar to SSMS

By richardmgreen1

Hi all   I'm fairly certain I've done this before but can't figure it...

Add custom toolbar to SSMS

By richardmgreen1

Hi all   I'm fairly certain I've done this before but can't figure it...

Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream

By Koen Verbeeck

Comments posted to this topic are about the item Streaming Event Data through RabbitMQ...

Visit the forum

Question of the Day

What's Wrong with this Table?

What's wrong with this code and causes an error?

CREATE TABLE Customer
(
    CustomerID INT NULL,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NULL,
    Email NVARCHAR(100) NOT NULL,
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID, LastName)
);


See possible answers