Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
3
votes
1answer
1k views
MySQL Workbench Database Sizes
I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using.
Does anyone know of an easy way to figure this out?
If nothing else, the default location ...
3
votes
1answer
708 views
MySQL Server Performance
I have a few questions regarding MySQL server running under Windows Server 2008 R2:
How do I check the number of allowed connections?
How do I turn on query logging to see performance of queries ...
3
votes
1answer
3k views
SQL Server 2008 R2 on Windows 7 x64 Professional - what are the downsides?
I need to minimize the cost of the platform, that will run SQL Server 2008 R2 Standard Edition. I have a special licensed version of this SQL server to work with like 20 users (it's an 1C special ...
3
votes
1answer
700 views
How to find the detail cpu high process name which occupying most resource in the SQL Server database?
I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env.
DECLARE @ts_now bigint;
SELECT @ts_now = cpu_ticks / CONVERT(float, ...
3
votes
1answer
10k views
How do I grant all privileges to local db2admin with DB2 9.7 on Windows?
I have as my developer station a laptop with OS Windows XP Professional Edition, Service Pack 3.
I have downloaded and installed IBM DB2 UDB 9.7 fix pack 4, of the Express-C edition.
I have a local ...
3
votes
1answer
83 views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
3
votes
2answers
861 views
Problem installing DB2Express
I installed DB2 Express 10.1 on my Windows 7 (64bit) notebook. Now after the installation finished I cannot connect to the database. During the installation I specified "C:\Daten\db\db2" as the ...
2
votes
2answers
342 views
Use different Windows account in pl/sql
Is it possible to use/log in to a different account in pl/sql. For example, I would like to write to a file in a folder only a specific account has access to. Here's an example of what I mean:
Other ...
2
votes
2answers
64 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
2
votes
3answers
2k views
Can I specify a different disk for a specific MySQL table?
I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
2
votes
1answer
66 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
2
votes
1answer
923 views
How do we free up disk space from allocated namespace? / ORA-03297
We are running out of disk space.
The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g).
The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
2
votes
1answer
722 views
MySQL Workbench asking for password
I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench.
I have started mysql service by command
C:\> net start mysql
as suggested ...
2
votes
1answer
7k views
How to import a.csv file into a postgresql database using \copy?
I am trying to import a .csv file into a postgresql database. I am using pgadmin III for that on a win7 machine.
My query looks like that:
\COPY pop_grid(GRID_ID, POP_TOT, YEAR, METHD_CL, CNTR_CODE, ...
2
votes
2answers
230 views
Can I implement clustering with just 2 servers and one NAS?
I have the following architecture, it consists in only 2 servers, connected to a NAS.
I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do ...
2
votes
1answer
1k views
How do I create a database+tablespace+user in Oracle 11gR2?
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant ...
2
votes
1answer
73 views
Bad Windows Authentication sign on
I do not have install privileges on my machine.
Another user who has admin privileges installed it, but told the system to use Windows Authentication for the sign on.
Is there a way they can change ...
2
votes
2answers
431 views
Large files in wamp\bin\mysql\mysql5.5.24\data directory
I have discovered these files located in the wamp\bin\mysql\mysql5.5.24\data folder on my Windows 2008 server.
They are consuming about 22 GB on a 40 GB drive.
I am using a LMS called moodle, that ...
2
votes
1answer
174 views
Logging to a file in PostgreSQL windows service
I need an alternative for running the following command:
C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start.
This way the server starts and logs to C:\yyy\log\pgsql.log. ...
2
votes
1answer
40 views
How to restore IBM DB2 database from AIX to Windows?
I had made backup from remote IBM DB2 server in AIX using this command:
./db2 backup database DBEMP to /home/dbemp/backup
Then I grab the backup file using FTP Client from my Windows.
I run this ...
2
votes
1answer
76 views
How does MySQL resolve schema information?
I’ve used MySQL on windows7.
Recently my machine was infected by a virus.
After that SHOW TABLES and SHOW DATABASES statements don’t show any tables and databases but I can see data from tables ...
2
votes
1answer
202 views
Unknown option '--no-beep'
I installed a new version of MySQL server (previously 5.0, now 5.5) and I copied the data folder in to the new one. Now I should perform mysql_upgrade. I opened the command prompt (server is located ...
2
votes
2answers
219 views
Cannot start SQL SERVER SERVICE in Windows Server 2000
This morning this problem occurs when my co-worker says they cannot connect to database.
I've checked the server and found that the SQL SERVER SERVICE is currently stopped. The problem is I cannot ...
2
votes
2answers
197 views
Minimum/Maximum Server Memory in SQL Server 2005 with /3GB and /Userva switches
I have a 32-Bit Windows 2003 machine with 3.75GB RAM running one SQL Server 2005 instance. I am trying to optimize memory. If I use the switches in boot.ini like below,
/3GB /Userva=2490
should I ...
2
votes
1answer
872 views
Change existing datadir path in mysql
I want to change the datadir path in the my.ini file.
The existing datadir path is C:/ProgramData/MySQL/MySQL Server 5.1/Data/
The size of my C: drive is 30GB and the MySQL data folder is occupying ...
2
votes
1answer
732 views
Set-up MySQL Server on Windows 7 64-bit
I am trying to install MySQL Server on my Windows-7 64-bit machine. I have downloaded MySQL Server Community Edition and MySQL Workbench. I am trying to start a new Server Instance from Workbench. I ...
2
votes
1answer
57 views
Should Crystal Report be allowed for certain employees for production database?
I am talking about production database. There are couple of people who use crystal on daily basis for various types of reports. Some use it to just peak at the data, other generate reports of it. ...
2
votes
3answers
2k views
Physical memory usage approaching 100%(96%) [duplicate]
Possible Duplicate:
SQL Server 2008 R2 “Ghost Memory”?
Context:
Windows Server 2008 R2;
32GB RAM;
Application: SQL Server 2008 R2, several Connectors to Write Data into SQL ...
2
votes
2answers
4k views
How to start Oracle database's listener service after a change in the IP address?
I'm using Windows XP as my Oracle database server. Today there was a change in the IP address if the database server.
I want start my database instance's listener again. Windows XP prompst that:
...
2
votes
1answer
1k views
How do I install pgcrypto on Windows?
I would like to install pgcrypto in Windows. I have a file C:\Program\PostgreSQL\9.0\share\contrib\pgcrypto.sql but when I try to run it in psql I get an error:
C:: Permission denied
How do I solve ...
2
votes
1answer
622 views
How can I configure PostgreSQL 9.0 to start automatically under Windows XP, Part II?
Two weeks ago I asked "How do I configure Windows XP to start the postgresql demon after each boot/reboot?", and BenV helped me out with his answer:
Make sure the service is set to start ...
2
votes
1answer
175 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
2
votes
1answer
276 views
Remove sql server service from windows 7
I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
2
votes
1answer
91 views
Does having Default Database Engine MyISAM and keeping InnoDB tags in my.ini create any problem?
Recently I am getting table corruption issue very often and every time when I check the logs it says "Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL"
...
2
votes
1answer
936 views
DB2 Express on Windows 7 - Disable security?
I'm trying to install DB2 Express-C on my PC (Windows 7 pro), but no matter how I've installed or configured it, I can't grant the ability to create databases to my windows domain account. No matter ...
2
votes
1answer
91 views
Software for backing up SQL Server databases
Since using the new version of Symantec, I've experienced lots of problems doing incremental backups of clients' SQL databases.
Is Windows Server backup a good alternative to Symantec Backup Exec ...
2
votes
2answers
370 views
How to force Windows to support not supported LC_COLLATE and LC_TYPE in PostgreSQL?
I have fresh installation of PostgreSQL 9.1.x. Unfortunately, I discovered that OS doesn't support LC_COLLATE = 'pl_PL.utf8' and LC_CTYPE = 'pl_PL.utf8'. I read in PostgreSQL documentation that:
...
2
votes
2answers
846 views
How can I set up a read only odbc connection?
I have a user that needs to do queries on an SQL Server 2008 database that I administrate. They have rights to edit the data, but I'd rather they weren't able to do it directly against the table ...
2
votes
1answer
198 views
FLUSH TABLES stays in the processlist even after execution
Here is my code from Stored Procedures in Mysql
FLUSH TABLES;
TRUNCATE TABLE tbl_cdrload;
TRUNCATE TABLE tbl_cdrdetails_temp;
Then i execute a query to load a file in to database as below
LOAD ...
2
votes
2answers
392 views
What is the recommended Buffer Pool size on a 2GB RAM PC?
I installed DB2 Express-C on a PC with 2 GB RAM and running Windows Server 2008 R2 OS. While creating a new database, there is an option to set Buffer Pool size with default set to 4K.
How much is ...
2
votes
1answer
219 views
How can I restore a MySQL database after formatting my hard drive
I recently formatted my PC which had MySQL running on it. As a result, I lost the databases on my hard drive.
I tried to restore the databases by re-installing the MySQL Server and putting the ...
2
votes
1answer
354 views
PostgreSQL 9 'pgstats wait timeout' problem
I'm asking about this here because in the PostgreSQL mailing lists no one answered me.
In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the ...
2
votes
2answers
589 views
Separate tables or partition one huge table?
I'm building a rather large table that includes a particular column, my_column. There are a small-ish number of possible values for my_column, and each unique value of my_column should have the same ...
2
votes
1answer
279 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
2
votes
1answer
286 views
Can I choose which CPUs / Cores to be used by MySQL?
I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example).
With ASP.NET, in such situation, I usually set the app ...
2
votes
0answers
177 views
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
2
votes
0answers
600 views
oracle crash - not starting
We have a
Windows Server 2008 R2 Enterprise x64
Oracle 10.2.0.3
Adempiere - ERP
We had a power breakdown at 03.00 AM.
At 07.30 AM we started the server
At 08.00 our colleagues observed that the ...
2
votes
0answers
188 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
0answers
72 views
ProcessID Owner with third party app
I am having problems trying to audit a third party app with a SQLServer backend.
The app manages users and user access via a SQL table, using a single SQL login to access the databases.
I am trying ...
2
votes
0answers
503 views
Copy database wizard between servers results in Access Denied error. [closed]
I'm trying to copy a database from SQL Server 2008 R2 to another server, using the Copy Database Wizard in SQL Server Management Studio.
I get an error telling me to check the error log on the ...
