Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

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. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
3
votes
1 answer

Are Previous Microsoft SQL Installations Needed After SQL 2012 Upgrade?

Are the older installations of Microsoft SQL Server needed after you installed Server 2012? I've been doing some cleaning and noticed I've a whole list of SQL Server installation. When I installed Server 2012, I clicked the upgrading option but…
reaper_unique
  • 133
  • 3
3
votes
2 answers

vCenter database selection

I am in the planning process of building a new vCenter 5 server. Currently, as a SMB, my host requirements are within range of using the SQL Express install, but my VM count has grown into the lower triple digits. In my current vCenter I have been…
Chadddada
  • 1,680
  • 1
  • 19
  • 26
3
votes
1 answer

Getting false-positive SQL Injection reports

We have installed a new Juniper SRX firewall with IDP, so the firewall is inspecting the traffic for suspicious activity. I've encountered 3 "false-positive" reports for SQL injection attacks that are just genuine usage: Using mDaemon's webmail,…
Dan
  • 783
  • 1
  • 13
  • 21
3
votes
1 answer

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an x64 version of SSMS to no avail. I've tried…
Landon
  • 31
  • 2
3
votes
2 answers

Windows Cluster - Can I failover without disturbing SQL?

I have a 3 node cluster. All of the nodes are part of Cluster01 in what should be A/A/P mode. Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows cluster resources would reside on NodeA and NodeC…
LeedsDBA
3
votes
3 answers

Problem with WSUS database

On server which I'm using for WSUS 3, one day i found this: The WSUS administration console was unable to connect to the WSUS Server Database. Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting…
Boris Vezmar
  • 163
  • 2
  • 2
  • 8
3
votes
3 answers

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to growth unrestricted by 10%. I have lots of disk…
aSkywalker
  • 555
  • 3
  • 9
  • 15
3
votes
1 answer

sql server 2005 encoding problem

Ive got text file with utf-8 encoding with more then 2k lines of insert command. Now I would like to execute it as a sql script to insert data into database. There is greek text with which there are problems. After inserting there are only ?…
potatoMan
  • 153
  • 1
  • 1
  • 5
3
votes
2 answers

Cannot resolve the collation conflict between "SQL_Latin1_General_CP437_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

I'm trying to copy over a schema from one server to another, and I keep getting the following error and I have no clue where to start from to debug this issue... Error 2 SQL01268: .Net SqlClient Data Provider: Msg 468, Level 16, State 9,…
RyanTaylor2
3
votes
1 answer

MySQL table does not exist

I am getting following error in err file. 110803 6:51:26 InnoDB: Error: table `ims`.`temp_discoveryjobdetails` already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used…
Phanindra
  • 203
  • 1
  • 4
  • 11
3
votes
4 answers

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.
jax
  • 207
  • 1
  • 5
  • 12
3
votes
1 answer

MySQL think 'außer' equals to 'auser'

I tried to migrate some tables from one MySQL database to the other, but I encountered an error: ERROR 1062 (23000) at line 108: Duplicate entry 'außer' for key 'PRIMARY' And I tried to find why, in the target database, i ran mysql> select 'außer'…
Fang-Pen Lin
  • 282
  • 1
  • 3
  • 12
3
votes
2 answers

Store TIME in SQL

What is the correct way to store the TIME of day in SQL? Have a field that cares only when an action took place. Example values will be 2:30 PM or 14:30, it doesn't matter to me which. This value will NEVER (ha, ha) be added, subtracted,…
csi
  • 1,555
  • 7
  • 23
  • 42
3
votes
2 answers

What is more important to SQL 2008, RAM or CPU power?

I currently have a server which runs SSIS 2008 and SQL 2008. I want to improve the performance of the server and keep the performance of the server steady when SSIS is running. I have an SSIS package that runs once per hour on the server and it…
Chris Lomax
  • 173
  • 1
  • 2
  • 8
3
votes
3 answers

Is there a way to communicate DBMS with raw memory block or binaries

I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS. Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them (it will be something like: The Outside library…
edgarmtze
  • 219
  • 1
  • 6
1 2 3
…
85 86