All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
64 views

Setting up SQL Server Developer Edition

I just installed SQL Server Developer Edition and SQL Server Management Studio, how can I configure the server? I want to configure it to have server name localhost-sql-server, with a login/password. ...
0
votes
0answers
26 views

Why is Vertica Management Console reporting my TZ is not set

I am experimenting with setting up a Vertica Community Edition (9.2.0-0) cluster using three virtual machines. In the Vertica Management Console, when I enter my IP addresses and ask to "Validate Host"...
4
votes
1answer
741 views

Turn off telemetry in SQL Server install config file

I'm creating a SQL Server 2017 Image Completion config file, and the automatically generated one has a bunch of stuff about "telemetry". I clicked no to the prompts, but it still put several user ...
1
vote
0answers
287 views

MongoDB Warning impossible to clear

I'm using Ubuntu 16.04 and MongoDB 4.0.1. When I use mongo shell I got this : I STORAGE [initandlisten] I STORAGE [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with ...
1
vote
2answers
2k views

Error when executing “create pfile from spfile”

I just installed Oracle database 12cR2 and am trying to startup a database. I am trying to create a pfile from spfile using following query. create pfile from spfile; Then I get the following ...
1
vote
1answer
338 views

64k AU size - master, model, msdb

Should master, model and msdb reside on drives with 64k AU size? Is it necessary? Recommended? All of our SQL servers are on VMware. If necessary, I would like to be able to recover a VM from a ...
1
vote
0answers
84 views

Specific install of MySQL 5.6

I'm download this version mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz. I would like to make a specific install for example : basedir = /sgbd/mysql/5.6/mysql datadir = /data/mysql/MYSDTESTP02 socket = /...
0
votes
1answer
120 views

SQL Server Partition - File Placement

According to Microsoft best practices you can optimize SQL and take a lot of benefits by using this technique, my only question is how to correctly install the SQL Server to match the drives/paths ...
5
votes
5answers
20k views

SQL Server Agent won't start

When I'm trying to start SQL Server Agent, I got this error: TITLE: Microsoft SQL Server Management Studio Unable to start service SQLAGENT$SQL_NAGA on server NAGA. (mscorlib) ADDITIONAL ...
-2
votes
1answer
2k views

SQL Server 2014 is not showing

I have installed SQL Server 2014 in my machine (OS Windows 10). I already have SQL Server 2008 R2. Now I have 2 server instances and I also have 2 Management Studios. My problem is that I can not ...
2
votes
2answers
2k views

can't install citext extension: could not access file “$libdir/citext”: No such file or directory

I'm trying to get citext available as a type in a specific database. The Postgres database server is 9.4. I see it on the server in the pg_catalog's pg_available_extensions view. From the psql ...
1
vote
1answer
82 views

What does Oracle XE perform during installation?

I have oracle11g2 installed on my noteobook. I then installed the Oracle Database 11g XE. Now a .dll which uses the oracle11g2 client does not work anymore. First I recogniced that I had now two ...
0
votes
0answers
194 views

SQL Server Configuration.ini File. SSIS Data Required?

I am planning a new SQL Server installation based of the settings from a previous installation on another server. I am using the Configuration.ini file. Since SSIS is not required can I exclude the ...
0
votes
0answers
548 views

Unable to install mysql 5.6.17and configure mysql on Win 7 -64 bit Os

Already seen this post but not my type of question as iam stuck in the installation itself I am trying to install MySQL 5.6.17 on Windows 7 64-bit Operating System. Everytime I try I am stuck in this ...
0
votes
1answer
73 views

What are the compelling resons to update SQL Server name to a real one after its changing?

Took the job of monitoring and tuning a few dozens SQL Server 2012 Enterprise Ed. SP1 (64 bit) on Windows Server 2008 R2 Standard Ed. running inside virtual machines. All of them on running ...
0
votes
1answer
124 views

How can I run a PostgreSQL outside the standard directories on Linux, ie outside /var/run/postgresql etc?

I need to be able to run PostgreSQL databases outside the standard installation directories, ie run the existing postgres or pg_ctl process pointing to the alternative ports, configuration and data ...
1
vote
2answers
2k views

what's the optimal partition setup for a linux db server?

My host wants to know how I want to partition my server before installing CentOS. I need to be able to do use xtrabackup to create quick backups from 20-50GB databases. I know I need to use a LVM, but ...
1
vote
1answer
451 views

Installing Sphinx on Mac OS with XAMPP

We have: Sphinx 2.0.3 Mac OS 10.6.8 XAMPP 1.7.3 (with MySQL 5.1.44) Here is PATH: user:sphinx-2.0.3-release user$ echo $PATH /Applications/xampp/xamppfiles/bin:/opt/local/bin:/opt/local/sbin:/...