473,395 Members | 1,649 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Do i need to shrink database

3
My database properties show Space Available 0.00 MB.
And users complain the application is very slow. Do i need to do a database shrink? Also can i schedule db shrink on a weekly basis is that advisable?
Dec 15 '10 #1
1 1906
ck9663
2,878 Expert 2GB
There a lot of factors including your T-SQL, your design, your table and db structure, etc...

Shrinking database is not always OK, sou you have to assess everything first.

Good Luck!!!

~~ CK
Dec 15 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Google Mike | last post by:
I just found out from someone named Frank M. Kromann in one of the other PHP forum websites that I don't have to recompile PHP on Linux in order to add a database connector. I've been pulling my...
4
by: Tommy.Vincent | last post by:
hi all, This will be a easy question for all out here. I have a database of 28GB. having 3 Data Files 22 GB, 3.58 Gb and 2.70 GB respectively. and a Transaction Log file of 156 mb. When i...
5
by: nbbrindisi | last post by:
First, I work with a small church (about 100 people). We need a database to handle basic information like name, address, family members, joined church birthdate and etc. We really don't need to...
1
by: David | last post by:
Hello, I have the Visual Studio .NET installed under Windows XP Pro, in my laptop. Right now I learn C#, and I need an access to any available database, just for practice. It seems that I can...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
0
by: cutecatcher | last post by:
good day! is there anyone that can help to know how to view the data on your database on a msflexgrid? thanks!
5
by: Jozo | last post by:
Where can I download GeoIP database. I need to get country name of user on my asp.net site. So I need geoip database in access format or sql server, excel, text... I don't need software, only...
6
PhpLover1984
by: PhpLover1984 | last post by:
Hello, Which dbms (compact and free) do you advice me to use with my first Java desktop single user database application, with supporting standard SQL, and which I can install with my exe...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.