Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

0
votes
2answers
484 views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
3
votes
1answer
106 views

Windows 7 WMI ODBC driver installation?

I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
0
votes
0answers
24 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
0
votes
0answers
43 views

Any other option than HTTPS + Basic auth for reverse proxied IIS site that uses double hop authentication to SQL server

We've been struggling for a while to get, what I had assumed would be a relatively common scenario to work and would appreciate any pointers. We have 2 x Windows 2012 Servers running IIS Server SQL ...
0
votes
1answer
150 views

Do manual backups of SQL Server databases interfere with the automated backup process?

I was once told that running manual backups of SQL server databases from Managament Studio was a big no-no on production databases as it can interfere with the automated backup jobs on the server. ...
1
vote
1answer
113 views

Remove permissions on sysobjects table for db user sql 2012 like in ms sql 2000

In a bygone age in ms sql 2000, if I wanted to remove a db users ability to view the sysobjects table in Ent. Manager I'd find the user in the database, right click him, select properties and then ...
0
votes
0answers
34 views

SQL Server Table Partitioning and my data lifetime management

My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one ...
0
votes
1answer
100 views

PORT 1433 in use by LSASS.EXE, therefore cannot start SQL Server Service

Sysinternals's TCPView shows that port 1433 is used by this OpSys process, both local and remote addresses contain my FQDN, which is a Win Server 2008-R2 fully patched, has someone faced such a ...
0
votes
1answer
43 views

DBVis SQL Query - Using Date Variables

Firstly it's been a very long time since I did any SQL and even then it wasn't at a high level. I have created a SQL query which works but I want it so the date range changes automatically, for ...
1
vote
0answers
166 views

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an ...
1
vote
1answer
69 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
4
votes
2answers
515 views

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V ...
1
vote
2answers
2k views

How do I troubleshoot root cause of a hung windows (2003) server?

I have a pair of Windows (2003 Server) servers both running MS SQL Server (2008 EE) that each hang every few months. This has been occurring intermittently :( for the past 15 months pretty much since ...
0
votes
1answer
50 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
-3
votes
6answers
1k views

How to make a huge ram drive?

At my old job when a report was needed I could sit down with someone and pull up results and get immediate feedback, and then refine my queries and ultimately have the data we needed, in the format we ...
-4
votes
2answers
87 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
0
votes
2answers
148 views

SQL server 2008 Enterprise Edition - Dual X5670 Processors Support

Would SQL server 2008 Enterprise Edition fully support Dual X5670 Processors which is equal to 24 core at total. thank you.
-1
votes
6answers
922 views

Running many databases under one instance

Is it best to have one single instance with many database or to spread the databases across a few instances?
2
votes
4answers
2k views

iSeries DB2 - SQL GUI Tool

Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.
0
votes
0answers
29 views

SQL server HA when running with PCI Flash device

I want to purchase a PCI based Flash storage device for our ESXi server hosting our SQL Server machine. We use SQL Server 2008 standard edition. storage is on Netapp via NFS. It is a VM (ESXi 5.1) ...
0
votes
0answers
60 views

What's the effective way to compact sqlite3 db?

After a few delete and insert, our sqlite3 (3.7.x) was inflated from 300K to over 4MB. In firefox sqlite3 manager, we open the db and compact it. There is no size change. Then we move the db file to a ...
0
votes
1answer
73 views

Resell SQL Server 2008 Volume Licenses [duplicate]

This may sound like a strange question, but it's incredibly relevant to my company. If it's legit to purchase previously used VL keys for SQL Server 2008 and have them legally transferred over to us ...
0
votes
0answers
53 views

Securing and loadbalancing front-end back-end with sql inspection proxy

I am working on designing a secure way for our network to allow front-end application servers in our DMZ to communicate securely with our databases, and I can see quite clearly that normal firewalling ...
2
votes
5answers
2k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...
0
votes
1answer
125 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
-4
votes
1answer
30 views

Does Nginx support ssh connections? [closed]

I want to build a site with nginx as HTTP server and MariaDB as SQL server. I'm searching in Google if nginx support (or its included) the ssh support to execute ssh_connect thru PHP files, but I ...
0
votes
1answer
80 views

How to execute multiple SQL statements in virtualmin / mysql

Using the "Execute SQL" feature of the mysql addin for virtualmin, what is the syntax for executing multiple statements? For example if I want to do: delete from Table1; delete from Table2; I get ...
0
votes
2answers
607 views

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL ...
-3
votes
2answers
51 views

How do i set the default instance of Microsoft SQL Server? [closed]

I have Sql Server 2000 and Sql server 2005 installed on the Server. How do i set the default instance to 2005? On Running this script Select @@Version i get: Microsoft SQL Server 2000 - 8.00.194 ...
4
votes
4answers
3k views

SQL Server 2008 R2 Error 15401 when trying to add a domain user

I am trying to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type ...
4
votes
6answers
13k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
-1
votes
1answer
64 views

Very Slow SQL Performance on VM rinning 2003 through 2012 r2 host [closed]

I have an OLD HP proliant ML350 used as HYBERv Host (win server 2012 - 16 GB RAM , 3x146 GB SAS , one processor). i have a VM (win-server 2003 32bit + sql server 2000) , every thing is working fine ...
0
votes
1answer
50 views

Cannot create MS MDT Database on SQL 2012 Express

I am trying to create a new SQL Server 2012 Express database via MDT 2013. When I did that I got the error above. I have completely rebuilt the server yet this error persists. Now when right-click on ...
0
votes
0answers
39 views

OpenLDAP SQL backend failing

I'm running OpenLDAP with a SQL (Oracle) backend. This works fine with OpenLDAP 2.3 but after upgrading to 2.4.38 it fails with an error that is not helpful at all: 52d3ec0c ...
1
vote
5answers
388 views

Sharepoint High Disk I/O - WSS_Search_SBS2011.mdf

Have a low specced server I've been troubleshooting (it is above MS's minimum specifications for SBS2011) One of my next steps is disabling what I can of Sharepoint as it is not used. Here are ...
0
votes
0answers
147 views

Disabling locked page allocations in SQL Server 2012

Locked page allocations are enabled in my instance of SQL server 2012 even though I have no accounts with the "lock pages in memory" user right. This article by Microsoft - ...
0
votes
2answers
810 views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
24 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
0
votes
0answers
35 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
2
votes
1answer
84 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
1
vote
1answer
130 views

SQL error log can't create/write to file

I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :) I'm running WordPress on a developer ...
1
vote
1answer
33 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
1
vote
1answer
54 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
1
vote
1answer
230 views

Why I can't execute SQL query on Amazon Redshift from VPC private instance?

I have an instance in a private subnet in an Amazon VPC. This instance uses a NAT to access the Internet. I use the Redshift JDBC driver to connect to a cluster hosted in the same region as my VPC ...
0
votes
1answer
96 views

IIS logparser - Count distinct from cs-uri-query?

I need to count how many DIFFERENT MAC´s that have accessed my IIS webserver and have a state value of 1. The "MAC" adress and the "state" value are in the actual query (cs-uri-query) So the log can ...
1
vote
1answer
289 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
0
votes
1answer
476 views

Sending Email from SQL Server Agent scheduled job

I've scheduled a job in SQL Server Agent that sends the result of a query in an email. If I execute the stored procedure from SSMS, it works fine. But the SQL Server Agent is not able to send emails. ...
9
votes
2answers
5k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
2answers
51 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
1
vote
1answer
36 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...