Vinay Kumar

Shrink databases

This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]

3 (1)


777 reads


Social: Going Along to Get Along


It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020


I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux


No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs


Daily Coping 3 Jul 2020

By Steve Jones - SSC Editor

Today’s tip is to thank a friend for the joy they bring into your...

Connecting To Quickbooks via SSIS

By stricknyn

Hello everyone, Been doing some googling trying to find some info on connecting to...

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers