Regain database Space

Aha! something new has been published on Technodivine .com: Regain database Space

The last two articles help you identify where the issue is? this one will take you through step by step process of what one may do to regain the space occupied by the databases. Hence freeing some resources on the SQL server and improving the performance too. Identify and clean Log/Temp Tables Truncate/Delete the log […]

Read Full article @ https://is.gd/RkI0uF

Logo3-vSmall
Bharat Kakkar
Mail: Bharat.Kakkar@technodivine.com
www.Technodivine.com | For Automation Geeks
@ For latest updates follow us

Display DB Table information – what’s eating up DB’s space?

Aha! something new has been published on Technodivine .com: Display DB Table information – what’s eating up DB’s space?

In continuation with the previous article, this will help to identify which tables in your database are eating up space, maybe it’s just a log table or a temp table, that you may wipe off to save the space and optimize the performance of your DB. Here is how you would do this based on […]

Read Full article @ https://is.gd/AHKdRI

Logo3-vSmall
Bharat Kakkar
Mail: Bharat.Kakkar@technodivine.com
www.Technodivine.com | For Automation Geeks
@ For latest updates follow us

Display data and log space information for each database – what’s eating up space?

Aha! something new has been published on Technodivine .com: Display data and log space information for each database – what’s eating up space?

This thread outlines how to display data and log space information for all the databases in SQL Server. This will give you an insight into which database needs to be maintained or dropped to save space on your server. Connect to the Database Engine. From the Standard bar, click New Query. Copy and paste the following example into the query window and click Execute. one may uncomment a […]

Read Full article @ https://is.gd/xpMgyB

Logo3-vSmall
Bharat Kakkar
Mail: Bharat.Kakkar@technodivine.com
www.Technodivine.com | For Automation Geeks
@ For latest updates follow us

Install Just “OSQL” command line utility

Aha! something new has been published on Technodivine .com: Install Just “OSQL” command line utility

This is an obsolete, yet a powerful tool to test access to a given database server or to do some more complex stuff like building or populating a database.  
It’s a fast, easy way to access the database while working with SQL Server without needing SQL Server Management Studio to install.

Read Full article @ https://is.gd/Bj8Qzb

Logo3-vSmall
Bharat Kakkar
Mail: Bharat.Kakkar@technodivine.com
www.Technodivine.com | For Automation Geeks
@ For latest updates follow us

MS SQL Database Default Location

Aha! something new has been published on Technodivine .com: MS SQL Database Default Location

View or change the default locations for database files In Object Explorer, right-click on your server and click Properties. In the left panel on that Properties page, click the Database settings tab. In Database default locations, view the current default locations for new data files and new log files. To change a default location, enter […]

Read Full article @ https://is.gd/aGGO6n

Logo3-vSmall
Bharat Kakkar
Mail: Bharat.Kakkar@technodivine.com
www.Technodivine.com | For Automation Geeks
@ For latest updates follow us