T-SQL

Technical Article

Copying Data from one Database to Another

  • Script

This script will be helpful to only those people who arehaving identical database with different names.This script can be used to copy single or multiple tables from one database to anotherThe parameters @tname , source database and target database are important for the script to work. In the script below I have considered two databases […]

5 (1)

You rated this post out of 5. Change rating

2002-04-16

1,604 reads

Technical Article

Detection of Broken Forign Key Relationship

  • Script

Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]

5 (1)

You rated this post out of 5. Change rating

2002-03-27

213 reads

Technical Article

Rows count for each and every table in a DB 

  • Script

       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

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

A Small LLM Fail

By

Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...

SQL Server Versions: Out With the Old, In With the Supported

By

If your production SQL Servers are still running 2016 (or older) you’re basically banking...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)

By Eric M Russell

We have an issue where SSIS packages are failing with a status of "ended...

SQL Newbie HELP: The query references an object that is not supported in distr..

By WBenning

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers