2022 Developer Survey is open! Take survey.

Hot answers tagged

21 votes

SQL Server is started but didn't listen on any port

What made my SQL server listen for TCP connections on port 1433 was the following... Configuration Tools / SQL Server Configuration Manager click the instance name in SQL Server Network Configuration ...
user avatar
  • 311
20 votes

How to disable starting MySQL service on Windows7 startup?

In Control panel open Administrative tools then double click Services. Scroll down to MySQL and double click to open the properties. Change the Startup type to Manual.
user avatar
  • 301
18 votes
Accepted

Where is my ORACLE_HOME Windows directory?

Open up a command prompt Start -> Run -> "cmd.exe" Start sqlplus as administrator sqlplus / as sysdba There's a system stored procedure called get_env for retrieving the value for ...
user avatar
15 votes

Limit max CPU usage SQL SERVER with WSRM

Is there any reason NOT to use the approach you've defined? Absolutely. Imagine you had bought a car - a car that when you hit 50MPH the engine starts to overheat. Would your reaction to this ...
user avatar
14 votes

Cannot open table mysql/innodb_index_stats

this bug is reported in MySQL Forums (67179) and the solution is mentioned here. please note that you should do clean-up, before creating tables /* temporary fix for problem with windows installer ...
user avatar
14 votes

Where is my ORACLE_HOME Windows directory?

On Windows platform you can find oracle_home path in the registry. Run regedit, then navigate to: hkey local machine/software/oracle Under oracle folder in the registry you will find something ...
user avatar
  • 381
14 votes
Accepted

How do I translate a Windows SID to an SQL Server server_user_sid?

SIDs in the form of 0x01020000000000052000000021020000 are not "SQL Server" SIDs. That is simply the underlying binary value of the SID. Another form it can take (and still be the same value) is the "...
user avatar
12 votes

How to disable annoying MySql update console

I may be running a more recent version of MySQL, but what I had to do to disable this was: Run the MySQL Installer (located at C:\Program Files (x86)\MySQL\MySQL Installer for Windows) Click the ...
user avatar
12 votes

Limit max CPU usage SQL SERVER with WSRM

Erik Darling mentioned the biggest practical reason for not using WSRM in a comment on your question: ...there's no reciprocal limiting of CPU use in other processes. SQL Server may not use those ...
user avatar
  • 27.1k
11 votes
Accepted

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

On your Windows client, you need to specify the TNS alias @ORCL, or else it assumes you're trying to connect to a local database running on your Windows client, which there isn't one. Also, system as ...
user avatar
  • 1,755
10 votes
Accepted

How to disable starting MySQL service on Windows7 startup?

You can disable MySQL service from the Command Line (make sure you Run it as Administrator). To disable service start on Windows startup (this will not stop the service if it is currently running): ...
user avatar
  • 843
10 votes

mysql replication on windows server

Replication setup on a windows server is equivalent to doing it in other systems: The official manual provides you a detailed guide. In short: Configure on both servers a different server-id, and ...
user avatar
  • 14k
10 votes

Changing Data Directory on MySQL DB Server

Open Windows CLI as Administrator and Shutdown MySQL net stop mysql Copy the Data to D:\ProgramData\Data xcopy /s C:\ProgramData\MySQL\MySQL Server 5.6\data D:\ProgramData\Data Create or edit C:\...
user avatar
10 votes
Accepted

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

So in this step of that PuTTY SSH tunnel tutorial: I used instead 5432 as the Source port and my.tunnel.domain:5432 as the Destination. Then in the connection details: In the Host Name I placed the ...
user avatar
  • 309
10 votes
Accepted

How to prevent asking for password when creating new database in PostgreSQL 10?

use the PGPASSWORD environment variable, @SET PGPASSWORD=something_secret psql -c "CREATE DATABASE mydb" -U postgres postgres or just use a connection string psql -c "CREATE DATABASE mydb" "user=...
user avatar
  • 2,380
9 votes

Why is database ownership by groups not allowed? Which user should own a database?

Honestly, sa or a disabled SQL Server account with absolutely minimum permissions is the best choice. As to why? Well, I could write out three or four paragraphs on that, or I can share my favorite ...
user avatar
8 votes
Accepted

How to apply a patch in PostgreSQL on Windows?

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter ...
user avatar
  • 51.8k
8 votes
Accepted

How to make SQL Server order fields by 'Id' (which in this case is an Identity column)

Now, when you say: I need the id column to be arranged in order of increasing number because I use a data table in C# to go through these values one at a time, therefore jumping from 7 to 9 to 11 ...
user avatar
8 votes

Why is database ownership by groups not allowed? Which user should own a database?

Is there an underlying reason why databases cannot be owned by a secondary principal? I'm not 100% certain of the reason for this restriction, though I suspect it has to do with the ability to ...
user avatar
7 votes
Accepted

How do I use an Ispell dictionary with Postgres text search?

I've written the following script to install an en_us dictionary on Ubuntu 14.04 running PostgreSQL 9.4. It should be fairly easy to modify for most situations. #!/bin/bash cd /usr/share/postgresql/9....
user avatar
  • 186
7 votes

Restart the active node services without failover

Use the Failover Cluster Manager application to manually stop the services. This tells the cluster you are intentionally shutting down the service, so it won't attempt to bring it back up on another ...
user avatar
  • 67.1k
7 votes
Accepted

How I compact WAL files?

Going by your other questions, it sounds like you have a short archive_timeout so your WAL archives are mostly empty, but are still the full pre-allocated 16MB file. On most platforms you just gzip ...
user avatar
  • 51.8k
7 votes
Accepted

Install MySQL for Windows from .zip and reset root password

Since you started mysqld with --skip-grant-tables, you cannot execute any standard GRANT, REVOKE, or SET PASSWORD commands. Notwithstanding, you can change the password of root@localhost as follows: ...
user avatar
7 votes
Accepted

How can I check the path of my.ini, through the command line?

mysqld.exe does not report the location of the my.ini it is using. I learned over the years that the my.ini file is supposed to be in the parent folder of the data and bin directories: Feb 06, 2012 : ...
user avatar
7 votes

Is there a Portable MySQL

Yes you can have MySQL as independent ZIP archive and it is also available for download in MySQL download page for windows, do the following steps Download ZIP archive Extract/UN-zip the archive ...
user avatar
  • 1,360
7 votes

Set TERMOUT OFF is not working when I am using sqlplus in command prompt?

12.41.61 SET TERM[OUT] {ON | OFF} Controls the display of output generated by commands in a script that is executed with @, @@ or START. OFF suppresses the display so that you can spool output ...
user avatar
  • 37.9k
7 votes
Accepted

Why putting SQL Agent offline caused WSFC to fail over on passive node?

If you look in Failover Cluster Manager, if you select the role for the Failover Cluster Instance (FCI) Role, then select the "Resources" tab at the bottom you'll see that the role is ...
user avatar
  • 14.4k
6 votes
Accepted

How to take physical backup of MYSQL database

You literally do not need a third party tool. STEP 01 Find out the path to the data by running mysql> SHOW GLOBAL VARIABLES LIKE 'datadir'; For this example, let's suppose it is C:\Program ...
user avatar
6 votes
Accepted

How to create a tablespace on Windows 7 for Postgresql 9.2?

For PostgreSQL 9.2 and above there is no postgres system user (by default). It runs as NETWORK SERVICE. Create d:\tablespaces and give the NETWORK SERVICE (SERVICE RÉSEAU in french) "Full control" ...
user avatar
  • 51.8k

Only top scored, non community-wiki answers of a minimum length are eligible