Page File usage is something which you should monitor to find out if your instance is running out of memory. You can use the below query.

SELECT (total_page_file_kb /...

Wonderful thought Steve.

I guess if Organization is not serious about DR or they feel they can live with the downtime caused due to unavailability of DR then DBA's can't do...

I suspect there is some issue with encryption. Although you can see encryption_state as 3 but I feel it's not encrypted. If you can share the trace/log of messages written...

I would recommend you to review the certificates/keys used for TDE once.

Backup files of databases that have TDE enabled are also encrypted by using the database encryption key. As a...

I have a database with no compression on the tables(source).  I want to create a blank database(destination) where I can create the tables with "data_compression = Page" and then...

I suspect your server is running out of memory and you may have to increase the RAM.

You have to find out the Page File Size and find out 70% of...

Thanks Mike for sharing your valuable feedback ! I agree with both of your feedback - Reset Identity and Checkpoint.

Will soon publish the revised version of the script with your...

I propose you to have a table for storing all the Batch Serial No along with Batch No.

Batch Serial No will be running number and Batch No will be your...

Links are not accessible 🙂

Links are not accessible 🙂 I'm quite interested in reading it.

Kindly share the schema script with us if you have already defined it. We shall make necessary suggestions inline with your schema.

Kindly help us to understand how are you storing these letter and numbers that you want to use to generate the batch? What is the schema of the table storing...

Try below query and see if it serves your purpose. Also attaching the output of the query for your review. The output is based on the insert script you have...

Sharing here the T-SQL script to copy data from one database to another database. It will copy data from one database to another database between the tables having exact same...

I would recommend to use the Stored Procedure as that restricts caller to use it as is without giving them opportunity to mess with the filter clause that can end...

• This reply was modified 5 years, 1 month ago by  Brahmanand Shukla.