Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
2
votes
3answers
3k views
What's a good (free) client for Informix on Windows? [closed]
I'm looking for a GUI client for Informix on Windows (mainly to view data and execute queries), free would obviously be nice but I know Informix is used mostly in corporate environments and free may ...
4
votes
1answer
66 views
Internals of Windows-to-Windows SQL Server data transfer
This is a sort of generic question and I don't require a very specific answer, but let me ask it by describing a scenario.
You connect to a remote db in SQL Server Studio 08, and run a select * ...
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 ...
3
votes
1answer
699 views
oracle failsafe - how to start instance in nomount
Using Oracle Failsafe, how can a instance be started up in nomount mode?
If the instance is shutdown via sqlplus, the windows cluster manager just starts it up again. If the instance is shutdown via ...
3
votes
2answers
410 views
How much RAM I should assign to SQL Server 2008 running on W2K3
I'm planning an installation for SQL 2008 over Windows 2003. The server has 16g RAM. How much RAM I should assign to SQL server?
3
votes
2answers
340 views
Testing Query Speed
When I'm running a query for the first time, it takes x miliseconds to be executed. When I run it the second time it takes a lot less time. I assume that it is some caching involved in this mechanism, ...
3
votes
2answers
306 views
Windows Storage Server, SQL Server, regular files — means to protect from insider threats?
This is my first post here, and I am by no means qualified as a Windows Server or Storage Server 2008 or SQL Server 2008 administrator. I am mostly a Unix guy, however tasked with a job to investigate ...
14
votes
3answers
19k views
Recommended page file size for SQL 2008R2 on Windows 2008R2
This Microsoft article - How to determine the appropriate page file size for 64-bit versions of Windows Server 2008 and or Windows 2008 R2 provides guidance for calculating the page file size for 64 ...
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 ...
3
votes
1answer
573 views
Login problem to SQL Server
I attempt to connect to SQL Server 2008,I receive the following error.
Login failed for user <>. Reason: Failed to open the explicitly specified database.
By the way, I have a SQL Server 2008 ...
1
vote
2answers
1k views
Oracle Forms 6i on Windows 7
Given I have a system of Oracle Forms 6i (legacy software), how could I make it work on Windows 7. We have serious problems with apps like PLUS80.exe crashing ("Oracle SQL*Plus has stopped working").
...
5
votes
1answer
547 views
Is there a way to edit the System Database Directory for DB2?
We have a case where we want to try to get rid of a database. The database still exists on disk and when we catalog it, it re-appears in the Database Manager. But when we try to do a DROP on it, it ...
2
votes
2answers
348 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 ...
4
votes
2answers
12k views
How to connect to a remote Oracle server from Windows machine using PL/SQL Developer?
I understand that I need to configure database address in the TNSNAMES.ORA file but where should I put this file?
UPDATE
I defined the $TNS_ADMIN variable, created the TNSNAMES.ORA file, added new ...
5
votes
4answers
7k views
Why does MySQL say I'm out of memory?
I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception:
Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes)
...
6
votes
3answers
3k views
Installing default MySQL Tables in Windows (mysql_install_db)
In Linux, the default MySQL grant tables can be created with the mysql_install_db script, but that does not work on Windows.
How can the default grant tables be installed on Windows?
(No, I’m not ...
7
votes
3answers
1k views
What Mechanism does MySQL use to schedule Backups on Windows Server 2008?
When scheduling database backups on MySQL Server (v5.1.45-community) running on Windows Server 2008, what mechanism is used to trigger the backups to run? I think it's using the Windows Task ...
3
votes
2answers
110 views
I'm performing a post-mortem on an Oracle database that's crashed its' host. Where should I begin?
I have an Oracle database (10.2.0.1.0 I believe) on a Windows 2003 server that I believe has successfully crashed the OS itself twice. Debates on platforms and stability aside, the evidence suggests ...
9
votes
5answers
1k views
SQL Server command line usage? Is it possible?
I've been trying to use the SQL Server Management Studio 2008's built in "Solution Explorer" to manage a project and after 2 weeks of struggling with it, I've decided I don't really care for it. It's ...
1
vote
1answer
5k views
Asynch Descriptor Resize explanation
What do asynch descriptor resize wait events mean on an Oracle 11g database running on Windows 2008 R2? According to My Oracle Support, this event applies to any platform, but the description ...
2
votes
1answer
641 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 ...
5
votes
1answer
578 views
Case Behavior Changed Between 11.2.0.1 and 11.2.0.2
I have a case open with Oracle and they say they can't reproduce this. Running the following in 11.2.0.1 or lower produces two rows from both of these queries, but in 11.2.0.2 the second query ...
25
votes
3answers
2k views
On a dedicated database server, how much memory to reserve for the OS?
Assuming you have a dedicated server explicitly for database functions -- how much memory should you reserve for the operating system?
I realize this will probably vary somewhat depending on the ...
1
vote
1answer
2k views
How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
Yesterday I installed PostgreSQL 9.0 on Windows XP, and after the installation the DB was running. After booting the system this morning, the data base server did not start automatically.
How do I ...
5
votes
3answers
661 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
6
votes
2answers
223 views
Can Oracle be installed on Windows without being an administrator?
Can the oracle software be installed on windows without having administrator privileges?
