Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
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, ...
0
votes
1answer
775 views
Is there an easy way to debug and find out why a query runs slow?
I'm running onto a weird issue.
We've got two db servers, one is development and the other one is production.
Both have same specs.
VMs (Hyper-V)
Windows Server 2008 R2 64 Bit
SQL Server 2008 R2 64 ...
3
votes
1answer
2k views
WAMP server performance tuning for MySQL
We have a Drupal site with nearly 2000 pages running on WAMP server. The pages also contain images, and flash videos embedded into them. So, they are taking some time to load under normal settings.
...
1
vote
1answer
337 views
Enterprise Manager Database Control on host with an underscore in it's name
I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name:
C:\>emca -deconfig dbcontrol db -repos drop
STARTED EMCA um 30.05.2012 ...
1
vote
1answer
258 views
Failure to detach database
I used sp_detach_db to detach SQL Server 2005 databases. This works properly in Windows XP and Windows 7.
However, the same fails in Windows Server 2008.
The error message states:
The process ...
3
votes
1answer
478 views
MySQL Server Backup
I was wondering if there was any way of making a backup of an entire MySQL Server at regular intervals to a specific location. (If the version is required I can get it easily).
If there is, I must ...
3
votes
1answer
769 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 ...
2
votes
1answer
201 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 ...
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 ...
2
votes
2answers
403 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 ...
1
vote
1answer
473 views
Very Large Log Files
I'm running Windows Server 2008 R2 and executed a large query by accident. Next, the sever ran out of hard drive space.
I now have a file in my administrtor documents (log.log) that is over 18GB. I ...
2
votes
1answer
226 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 ...
1
vote
1answer
246 views
Change root password of mysql database
This could be a Rookie problem , but it seems that i am not able to solve it.
I have MySQL server installed on my windows machine(MySQL 5.5) under the Admin username root.
Some How i lost the ...
4
votes
1answer
602 views
Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required.
The application is a Java Swing heavy-weight GUI ...
1
vote
1answer
65 views
Log Custom SQL Results During Maintenance Plan
I would like the last step of my Maintenance Plan to execute a simple custom SQL script (SELECT * FROM <SomeTable> WHERE <Condition>), and save the results to a file (Text, CSV, etc).
Is ...
2
votes
0answers
73 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
1answer
379 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 ...
3
votes
1answer
91 views
migrating from SQL server 2005 to 2008
I had SQL server 2005 installed on my windows server 2008 R2.
Recently i installed SQL server 2008 and SQL server management studio 2008 r2 (SSMS) on my virtual server and i configured the instance ...
2
votes
0answers
527 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 ...
4
votes
2answers
1k views
Import Oracle full dump file to fresh Oracle installation
I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64.
I want to import the file to a clean ...
1
vote
1answer
363 views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
http://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on ...
0
votes
1answer
74 views
can I copy-paste SQL Server 2005 Express on XP Pro or Vista machine and make it work without installer?
I am having installer problems on several machines trying to install SQL Server Express 2005 Express as well as later versions (but I would be happy with 2005 anyway). However, I do have one machine ...
10
votes
1answer
275 views
What does a SQL Server DBA need to know about Windows Server?
Analogous to my previous question What does a DBA have to know about SSAS?, which generated a really wonderful answer (thank you, @ConcernedOfTunbridgeWells!), I now ask a similiar question:
What ...
1
vote
2answers
415 views
MySQL Database and Table Loss
I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
3
votes
2answers
751 views
ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)
I am receiving this error in a development database.
It happens on some specific queries (simple inserts and deletes via .NET application).
The database is used by one user, and error happens ...
6
votes
2answers
733 views
securely exposing sql server 2008 for windows authentication
My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet.
We have sql ...
1
vote
3answers
666 views
MySQL SSL disabled on Windows
I want to enable an SSL connection to my database. I've created SSL certificates and so on, however SSL remains disabled:
mysql> show variables like '%ssl%';
...
4
votes
2answers
644 views
Does the PCI standard forbid the use of Windows Authentication?
We currently use Mixed Mode for our SQL Server Authentication. I've tried to convince our DBA to allow us to use Windows Authentication so we can use Team Foundation Server, however he absolutely ...
2
votes
2answers
607 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 ...
3
votes
1answer
978 views
Converting Microsoft SQL Server collation to UTF 8
I've a Rails-Application, which reads data from a Microsoft SQL Server 2008 R2 Database.
All umlauts are represented by a '?', so I checked the encoding of the database. The encoding is 'Latin 1'. ...
6
votes
3answers
4k views
PostgreSQL: The database cluster initialization failed
Both C:\PostgreSQL and C:\PostgreSQL\data have postgres user with full access and admin rights.
I ran postgresql-9.1.2-1-windows.exe from postgres user as admin. Target C:\PostgreSQL
Every way I ...
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 ...
1
vote
2answers
566 views
Which oracle should I download for windows 7 x64?
My os is: windows 7 x64
I tried to download oracle and install it in my computer, but I have downloaded 3 different oracle releases(including oracle 11G), they can't be installed.
They reported ...
4
votes
1answer
374 views
Not all members in a Windows group have permissions
I ran into a bit of an odd situation. Let's say I have a domain group [DMN\Group] which has been created as a login on my server and a user in the database. One of the members in that group is not ...
1
vote
1answer
1k views
64 bit Postgres 9.1 Limitions on Windows 2008 R2?
When Deploying Postgres on Windows Server 2008 R2:
Are there any limitations on windows that don't exist on Linux?
Does the postgres scale in the same way on windows as it does on Linux?
Is ...
2
votes
2answers
236 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 ...
3
votes
1answer
748 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, ...
1
vote
2answers
2k views
How is localhost resolved by Oracle listener?
When I o an Oracle test installation on a Windows server accepting mostly the defaults, I end up with a listener.ora like
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = ...
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 ...
4
votes
1answer
1k views
Windows Authentication for a non-local non-domain Login
I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.
Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...
3
votes
1answer
11k 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 ...
0
votes
1answer
2k views
High PageIOLatch_SH Waits with High Drive Idle times
We are experiencing high volume of PageIOLatch_SH waits on our database (row counts in the Billions). However it seems that our drive Idle time Percentage hovers around 50-60 percent. CPU usage is ...
2
votes
1answer
287 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
289 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 ...
1
vote
1answer
157 views
Appropriate Windows version for Mysql
I have a HP ProLiant DL380 G5 server and I would like to install mysql on it .
My questions are:
Which MySQL version should I install from this link for better performance, 32 bit or 64 bit?
Which ...
1
vote
1answer
2k views
How to upgrade MySQL to newer version on existing database
I am having data of 20 GB with MySQL version 5.0.24.
Now I want to update MySQL to newer version 5.5.16.
We can do it by taking complete database backup and uninstall old MySQL and install new MySQL ...
1
vote
1answer
463 views
How to Prevent an Ever-Growing index file (MyISAM engine) From Causing Disk Fragmentation in Windows (NTFS partition)?
We have a keep-growing table which using MYISAM storage engine.
Almost every half year, this table will crash, and need to be repaired.
I checked the defragment result reported by windows ...
4
votes
1answer
465 views
How to restore a SQL Server 2008 R2 database
Here's my issue.
I have a server created from a windows image that includes SQL Server 2008 and two specific windows users, these windows users are a part of the sysadmin role and are users for the ...
2
votes
1answer
2k 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
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:
...
