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
4
votes
2 answers

Why does MySQL replication break on missing row, then continue after "START SLAVE"?

The title is a bit confusing, but I can't think of a better one. What I have is a simple vanilla MySQL replication, with the slave occasionally failing, with this error: Error 'Can't find record in 'my_tbl'' on query. Default database: 'my_db'.…
shlomoid
  • 289
  • 3
  • 14
4
votes
1 answer

Attempt to access SQL Server with the user SA

Possible Duplicate: Attempt to access SQL Server with the user SA I'm suffering an attempted invasion by brute force. A bot is trying to figure out the sa password. How do I restrict logins 3 attempts in SQL Server? Moreover, I would like to…
ridermansb
  • 215
  • 3
  • 9
4
votes
1 answer

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast)

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast) Or can this have impact on the data? Corruption? The table has GBs of data and the server crashed so, now its checking, and its taking a long time. So if the table is in…
Minus
  • 51
  • 1
4
votes
0 answers

What does it mean when Twitter says their entire database is in RAM?

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I am not sure if by RAM they mean only memcached,…
Lance
  • 233
  • 2
  • 8
4
votes
5 answers

What does it mean when Twitter says their entire database is in RAM?

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I am not sure if by RAM they mean only memcached,…
Lance
  • 233
  • 2
  • 8
4
votes
1 answer

Backup database at certain intervals?

My client would like to have the database backed up several times per day, as well as the ability to backup the database manually. I've created a page to backup the database manually, it just calls a stored procedure that backs up the database. But…
Steven
  • 223
  • 1
  • 3
  • 5
4
votes
4 answers

How to shape size of SQL server resorces (RAM, CPU, and others)

It is standard story, there is fight between developers and administrators. One denunciation that database design and queries are bad while others says It is lack of hardware and amount of data. So I am asking You is my IBM x3400 with 2 xenons…
adopilot
  • 1,521
  • 6
  • 25
  • 41
4
votes
1 answer

what does the "n'dbname" what does the 'n' stand for and

USE [master] GO /****** Object: Database [assist] Script Date: 11/13/2010 20:17:49 ******/ CREATE DATABASE [assist] ON PRIMARY ( NAME = N'assist', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.THIRD\MSSQL\DATA\assist.mdf' ,…
user48642
  • 289
  • 2
  • 4
  • 10
4
votes
9 answers

How can I prevent attacks on my SQL Server installation?

In the past month I've noticed in my event viewer on a sql server a lot of failure audits. Seems like a brute force attack from an ip in china trying to log in to the sa account which i have disabled. I've blocked it on my network firewall but then…
Romeo
4
votes
2 answers

SQL Server: explicit rights to schema?

When giving permissions to certain Schema in SQL Server, I want to deny some operations from certain users. Do I have to explicitly deny these, or is it so that when user gets a permission to this schema, rights for this schema is automagically…
atricapilla
  • 615
  • 6
  • 12
  • 15
4
votes
3 answers

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days backup folder, delete all other backup…
Dhiva
4
votes
2 answers

Sharepoint 2010 slow

Possible Duplicate: Slow Sharepoint Server 2010 I have a sharepoint 2010 installation that is running really slowly. The installation is set up as follows, I have a domain controller (Server 2008 64 bit) with active directory and DNS set up I…
Anthony Gledhill
4
votes
1 answer

Can MSSQL run alongside MySQL?

I'm currently evaluating Expression Engine for our company but need to install MySQL onto a DB server that already has MSSQL2005 running on it. Should I expect any compatibility problems or any other issues from running both SQLs alongside each…
Brett
  • 143
  • 1
  • 4
4
votes
5 answers

Use SQL varchar(max) or text?

I'm using SQL Server 2005 and I have a column where I need to store large amounts of text (sometimes over 8000 characters, the varchar limit). Is there a disadvantage to using the "text" data type? I also read about using varchar(MAX) -- would…
Austin
  • 205
  • 3
  • 5
4
votes
3 answers

ODBC: trouble removing system DSN

I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32 Anybody encountered this before?
Nick
  • 155
  • 2
  • 5
1 2 3
…
85 86