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

Cool AI sites

By

As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...

A Quick Test Data Manager Eval with My Database Backup

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Take over Ownership in Microsoft Fabric

By

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...

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...

Change all occurances of one field in DB

By water490

Hi everyone I am doing some clean up of my DB.  There is one...

locks in sql database 2019

By yfiguero

please help. Do they know if the use of try and catch for error...

Visit the forum

Question of the Day

Dates and Languages

The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?

DECLARE @yourInputDate  NVARCHAR(32) = '28 listopad 2018';

SET LANGUAGE Polish;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish];

SET LANGUAGE Croatian;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian];

SET LANGUAGE English;

See possible answers