by: Brad Tobin |
last post by:
On a production database, there is a 2GB database, when I run
sp_spaceused it indicates a very high quanity of unused space. The
database has been shrunk & free space sent to the OS. Why is this...
|
by: spilich |
last post by:
I have a large table that I recently purged a year of data from.
However, the table size in sp_spaceused hasn't decreased as much as I
would expect. (there are no text or large object columns on...
|
by: kalpesh.shah |
last post by:
kalpesh.s...@gmail.com Feb 1, 6:50 am show options
Newsgroups: comp.databases.informix
From: kalpesh.s...@gmail.com - Find messages by this author
Date: 1 Feb 2005 06:50:21 -0800
Local:...
|
by: UnixSlaxer |
last post by:
Hello, I am using DB2-UDB 8.2, when running the design advisor, It
exists tells me that "catalog simulation requires that the server be at
level V8.0 or newer", although the DB2 version is 8.2...
|
by: romicva |
last post by:
I've recently upgraded from 8.1.4 to 8.2.3. System slowed down
noticably. Explain shows that indexes are not used. I did reorgs on
indexes and tables, collected stats on key fields with detail...
|
by: PamelaDV |
last post by:
HELP! I have a rather large - production level database (2 tier -
front end and back end) and it was starting to run slow so we decided
to do a repair and compact on the back end (data). On the...
|
by: SB |
last post by:
Hi,
Is anyone aware of any freeware/shareware tools that can assist in
identifying unused objects in a database? I have inhertited a database from
a previous developer, and there seems to be a...
|
by: Brian Maguire |
last post by:
Can too many btree indexes cause page level locking?
I read this...
http://www.postgresql.org/docs/7.4/static/locking-indexes.html
|
by: JAW |
last post by:
I have some indexes that I don't believe is being used.
What is the best way to determne if this is the case.
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
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,...
|
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...
|