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
-2
votes
1 answer

TCP ports duplication

I need to communicate server1 to server2. Server1 should have to fetch some records from Server2 when we execute program.exe will make server1 to fetch server2 When I gave netstat -an | find "server2" I Could see that some of the TCP ports are…
Niveditha
  • 1
-2
votes
1 answer

Multiple attacks - what can I do

I experience multiple attacks on my server recently (for past several days). Types of these attacks are e.g.: Several SQL Injection methods (select/union/where/null, etc.) Brute force attacks (e.g. for root access via SSH, multiple authentication…
Xeon
  • 97
  • 3
-2
votes
1 answer

0.5 TB SQL Server Database, is it possible to store in a standalone server?

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a lot of group bys, inner joins, etc) but the…
X.Otano
  • 103
  • 5
-2
votes
1 answer

do all type of sql server license have SA account?

We are trying to upgrade our sql server from 2005 to 2012. we got some offers for different type of license from some resellers. the only thing I'm not sure now is, there's one type core license with software assurance (more expensive), and another…
Zhenyu
  • 263
  • 1
  • 3
  • 10
-2
votes
1 answer

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it possible to upgrade my normal sql2008 express with…
Bradley
  • 3
  • 4
-2
votes
6 answers

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 needed within 30-90 minutes. I just started…
Brandon Moore
  • 456
  • 2
  • 6
  • 17
-2
votes
3 answers

True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query?

True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query? That is, if I have a SELECT ... WHERE...query in SQL that operates on a table that has many fields, and hence lots of big data…
PaulDecember
  • 5
  • 1
  • 1
  • 4
-2
votes
2 answers

My MediaWiki wiki_text table is too big. How to compact/vacuum/purge

I run a MediaWiki wiki page. It uses MySQL. I have just 20 wiki pages and yet the wiki_text table is 45 MB big. I had security holes and spam bots were posting spam wiki pages. I have manually deleted all spam messages and closed the security…
Gad D Lord
  • 1
-2
votes
2 answers

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.
soumial
-2
votes
1 answer

SQL server slows down

We have a java application running on Tomcat and we are using SQL 2008 and 2005 as database. Our databases sometimes slows down really significantly and we don't see any blocking, deadlock, etc. I came across with this web page and the similar…
Eray Yuksek
  • 1
-2
votes
1 answer

Why SQL query does not work with subquery but works with comma seperated list?

I have query: SELECT p.[id], p.[page_file], p.[page_header], p.[page_icon] FROM [dbo].[setup_pages] AS p WHERE CONVERT(nvarchar(100),p.[id]) IN ( SELECT l.[access] FROM [dbo].[licenses] AS l ) It does not return error and no data are returned.…
Ingus
  • 59
  • 8
-3
votes
1 answer

MySQL replication not working

I have been trying everything I could find and my servers are not replicating! Can someone look at my config files and offer some guidance? My,ini master on Windows: # Other default tuning values # MySQL Server Instance Configuration File #…
DMonty
  • 1
-3
votes
2 answers

Don't know Server Name

I just installed SQL management studio to my computer. It opened up with window Connect to Server. What I shall write in Server Name part? I have just started to study SQL. Where i can find Server Name?
programmer0
  • 101
-3
votes
1 answer

How to insert values into point array in postgreSQL?

How to insert values into array of point in postgreSQL ?
Thirumal
  • 103
  • 5
-3
votes
1 answer

Does Nginx support ssh connections?

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 can't find absolutely nothing Does anyone know if ssh…
Alex Deiwor
  • 13
  • 2
1 2 3
…
85
86