Does it matter ?

• by administrator

• SQL Server Carpenter

A series of articles that will talk about most important but least focused areas in Database Design and Development.

2019-10-31

T-SQL query to copy data from one database to another database

• by administrator

• SQL Server Carpenter

T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...

2019-10-30

T-SQL query to copy data from one database to another database

• by administrator

• SQL Server Carpenter

T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...

2019-10-30

2 reads

T-SQL query to get the latest available backup chain

• by administrator

• SQL Server Carpenter

T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.

2019-10-30

T-SQL query to get the latest available backup chain

• by administrator

• SQL Server Carpenter

T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.

2019-10-30

T-SQL script to purge all the tables including foreign key references

• by administrator

• SQL Server Carpenter

T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...

2019-10-30

T-SQL script to purge all the tables including foreign key references

• by administrator

• SQL Server Carpenter

T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...

2019-10-30

Pseudo Code for batch processing using WHILE LOOP

• by administrator

• SQL Server Carpenter

  Leveraging WHILE LOOP

2019-10-10

Pseudo Code for batch processing using WHILE LOOP

• by administrator

• SQL Server Carpenter

  Leveraging WHILE LOOP

2019-10-10

Split data into N equal groups

• by administrator

• SQL Server Carpenter

In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...

2019-10-10