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

SQL PowerShell Snapin Problems

I am hoping this is an easy fix and oversight on my part. I need to be able to run the SQL cmdlets from remote machines. I have installed Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2 (along with the other requirements), however…
jrob24
  • 161
  • 1
  • 1
  • 2
3
votes
1 answer

Windows Server 2012 Forest and Domain functional levels compatibility

I'm using a Windows 2003 domain, and a currently planning for a Windows Server 2012 upgrade, so I'm looking at all software which could be hurted by a Domain (and Forest) functional level raise to Windows Server 2012 level. Could you please tell me…
Sebzzz
  • 31
  • 2
3
votes
1 answer

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my forum. What do I need to do to start investigating?…
libertaire
  • 133
  • 1
  • 3
3
votes
2 answers

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple collations per instance.
PnP
  • 1,684
  • 8
  • 39
  • 65
3
votes
1 answer

Why does a mysql query, that requires copying to tmp table, randomly sometimes consume 100% CPU during several seconds?

I have some crazy SQL queries in my PHP scripts which badly need some optimization. However the question is NOT about how to optimize them. These queries have a lot of "join"s and some bizarre "order by", and are done against tables with several…
matteo
  • 731
  • 2
  • 9
  • 21
3
votes
3 answers

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked…
Alex Gordon
  • 455
  • 3
  • 14
  • 31
3
votes
1 answer

Missing MSSQL10.SQLEXPRESS folder

I seem to be missing my C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it. Any ideas?
Eric Hickman
  • 33
  • 3
3
votes
2 answers

SharePoint database login failure for the computer account

Once an hour I am getting a login failure on the database server for a SharePoint 2003 server. The account(s) that are failing is the domain computer account for each of the web servers and the index server. It happens around the clock and each time…
jt.
  • 341
  • 3
  • 6
3
votes
2 answers

Connecting to SQL server over the internet

One of my clients has a db that contains their data (this server also host an ASP.NET webshop) and they had me write a program for their client which with they can query their db. My problem is that i was advised not to make the SQL server…
Qqbt
  • 133
  • 3
3
votes
9 answers

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 (42000): Incorrect database name Thank you for helping.
Rafał Kamiński
  • 187
  • 2
  • 5
  • 15
3
votes
1 answer

yum: Difference between mysql, mysql-server and mysql-devel

What are the differences between the packages here? mysql, mysql-server and mysql-devel I am installing a SQL server to use with PHP, but I found these three packages and am not sure which to use.
hexacyanide
  • 211
  • 3
  • 10
3
votes
2 answers

automatically restart sql server after job completes

I'm looking for a way to automatically restart the SQL service after an agent job has completed or as the last step of an agent job. It occurs to me that the agent service is dependent on the server service, is this even possible? Microsoft SQL…
Pete
  • 271
  • 1
  • 4
  • 19
3
votes
1 answer

Blind SQL Injection PCI failure

I am working on a client's PCI compliance. One of the failing items is: 3.1.4. Blind SQL Injection (httpgenericscriptblindsqlinjection) The offered solutions is simply: "Ensure that the Web application validates and encodes user input before using…
Aegyptus
  • 47
  • 1
  • 5
3
votes
2 answers

SQL Server 2008 R2 + Create new instance

I have a SQL Server 2008 R2 that's running as default instance. This instance has been patched with SP1 earlier this year. I would like to create a new instance for a new application. Once the installation for the new instance is completed, do I…
Gostan Balik
  • 33
  • 2
3
votes
2 answers

SQL 2008 R2: Data\Log partions

I have a SQL Server setup that a previous IT person set up with a 2TB data partition and a 1TB log partition. The OS partition is 244GB and SQL is installed on a separate 1TB partition. We have an additional 8TB of storage that I would like the…
Reese Hirth
  • 31
  • 1
1 2 3
…
85 86