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

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete installation is happening in Administrative…
Sudheer Muthusamy
  • 61
  • 1
  • 6
3
votes
0 answers

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is filling up memory, not releasing it, and then…
Tony
  • 457
  • 3
  • 11
  • 23
3
votes
2 answers

Performance azure disks, high average queue length

I'm having a classic developer-system admin battle where I am stating that there is an IO problem on the disk of the shared sql server while the system admin tells me that the capacity hasn't been reached at all. 1 thing I was able to point out is…
MichaelD
  • 545
  • 1
  • 5
  • 7
3
votes
0 answers

SQL & BITS Errors on prereq for SCCM 2012

Hey anyone that can help, I've been stumped by this problem for a while now and I've no idea what to do. I've installed SQL 2008 to run with SCCM '12. I've set Log On As a domain account with administrator privileges. I've set SQL browser to run as…
CMarble
  • 31
  • 2
3
votes
1 answer

where to see SQL Server start/stop logs?

I want to know where to see SQL Server start/stop logs for each instances and SQL Server agent/job start/stop logs? I am developing some tools to monitor SQL Server status. I am using SQL Server 2008 Enterprise. thanks in advance, George
George2
  • 1,137
  • 6
  • 22
  • 41
3
votes
2 answers

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but that's not achievable in a direct attempt. I was…
serverstackqns
  • 764
  • 3
  • 16
  • 42
3
votes
2 answers

how to separate IIS event logs by application in event viewer

Just to start with, I would like to advise I am VERY new to IIS so apologies for any obvious questions in advance. I have done some research around this topic and my findings have been inconclusive. Here is my scenario; I am currently running IIS 6…
JPM
  • 141
  • 1
  • 7
3
votes
1 answer

How can postfix hash: databases be replaced by static: or inline:?

What is the syntax to replace a postfix hash-Database, for example domain.tld PREPEND my-header: foobar with a static map? docs define it as Example: "inline:{ key=value, { key = text with whitespace or comma }}". Several ways to replace it seemed…
allo
  • 1,620
  • 2
  • 22
  • 39
3
votes
1 answer

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers suggest different domain account for each sql…
jM2.me
  • 311
  • 2
  • 7
  • 15
3
votes
1 answer

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our setup, what I investigated, our workaround, and will…
CWilliams
  • 31
  • 2
3
votes
2 answers

How do I control temporary file growth in SQL Anywhere?

We are currently experiencing a growing temporary file problem. Watching one of our sites we can see a growth of 100 - 200 MB a day at one site we are watching. At this site a failure occured when the temp file reached 20Gb and a free space issue…
Breck Carter
  • 181
  • 2
  • 9
3
votes
1 answer

How to rebuild MS Agent Jobs from MSDB table?

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the tables used to create MS Agent Jobs are held added to…
MonkeyMagix
  • 131
  • 1
  • 3
3
votes
1 answer

How to Explain a query in PostgreSQL 8.3 that has bind variables

I need to explain an application generated SQL statement in PostgreSQL 8.3. I captured the SQL statement in the log but it has a lot of bind variables. Is their any way that I can explain this SQL statement? When I tried it with the bind variables…
user7286
  • 135
  • 3
  • 7
3
votes
1 answer

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 would like to install the WMI ODBC driver on Windows…
brandeded
  • 1,845
  • 8
  • 32
  • 50
3
votes
1 answer

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 Express. I've written an application that connects to…
Vivian River
  • 359
  • 4
  • 10
1 2 3
…
85 86