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

learn more… | top users | synonyms

2
votes
4answers
210 views

Why upgrade from SQL 2005 to SQL 2008 R2? [duplicate]

Possible Duplicate: Why upgrade from SQL 2005 to SQL 2008 R2? I have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI ...
2
votes
2answers
127 views

Legalities of freelance security consultant (SQLi) [closed]

Over the years I've gained a large amount of experience in Programming (my main occupation) and server admin, and as a result have a fairly decent backing in security practices. I'm also pretty good ...
2
votes
1answer
3k views

how to see SQL Server cache hit rate?

I am using SQL Server 2008 Enterprise. I will issue a lot of query to SQL Server. And I think SQL Server itself will use some optimization internally, like pre-fetching data into SQL Server internal ...
2
votes
3answers
1k views

SQL Server Transaction logs full, how to empty and delete them

My transaction log file is full, i have 5 log files , 2 in D: drive & 3 in E: drive. all the log file is full, each log file is 10GB in size. I need to delete all 5 transaction log file and need ...
2
votes
4answers
1k views

Cross MS SQL Database Engine Queries

Is it possible to have cross database queries that span databases on two different 2008 MS SQL Servers? If so, what configuration, if any, needs to be done in MS SQL? Also, could someone show me an ...
2
votes
5answers
2k views

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much faster:...
2
votes
2answers
450 views

downloading a large database

I tried to export a large sized database using phpmyadmin but later the downloaded file seems to be of incorrect size, many of the tables inside the database are eliminated during download. The file ...
2
votes
2answers
1k views

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

What response should be made to a continued web-app crack attempt?

I've issues with a continuous, concerted cracking attempt on a website (coded in php). The main problem is sql-injection attempts, running on a Debian server. A secondary effect of the problem is ...
2
votes
1answer
194 views

How to View the IP routing table

How can I see ip routes I've added with ip route add default via x.x.x.55 table test1 for example I added 199 test1 and 198 test2 and 197 test3 to /etc/iproute2/rt_tables then I run: ip route add ...
2
votes
1answer
980 views

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.
2
votes
2answers
879 views

why would adding a crossover private nic cause IP address resource fail?

2 node Win 2008 R2 quorum cluster Configured 192.168.0.0/24 "public network" Configured cluster MSDTC Installed SQL 2008 R2 cluster instance Manually failover groups - OK Reboot server w/o failing ...
2
votes
1answer
636 views

Active Directory + IIS + SQL + ASP.NET

I have sent the following question to stackoverflow website I have installed Windows server 2008 r2 on a virtual machine, Can I install Active directory with domain controller + IIS + SQL server ...
2
votes
1answer
403 views

Will repairing a MySQL table run the risk of data loss?

I recently had a table in my MySQL DB go haywire (part of my Invision Power Board install) which has never happened to me before. If I use the "Repair" tool in phpMyAdmin, will I run the risk of data ...
2
votes
3answers
1k views

Can SQL server and WSUS co-exist on same server?

Pardon me if this is a stupid question, but after reading responses from my previous question I'm looking into implementing WSUS on my network. The box I would likely implement it on runs a ...
2
votes
2answers
198 views

MS SQL differential backup strategies

We recently had a failure on one of our servers. The server was not accessible and we could get any data from it. We had a backup plan that took a full backup every second day and then then a diff ...
2
votes
1answer
450 views

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal ...
2
votes
1answer
404 views

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 ...
2
votes
3answers
1k views

MySQL Injection Attacks? Random URL's Causing Errors

We just started running our own web server a few months ago on Rackspace (they are great). I use NewRelic (also pretty cool) to monitor server usage and I am getting error alerts that appear to me to ...
2
votes
1answer
8k views

mysqldump ignore table with wildcard

I need to take a dump of a database containing 50 odd tables of which I want to exclude about 15 odd that have prefix exam_ I tried mysqldump --ignore-table=dbname.exam_* and even tried --ignore-...
2
votes
5answers
2k views

Backing up a SQL Server 2008 R2 Database without stored procedures

Is it possible to back up a SQL Server database, but only back up the Table structures and content (i.e. not include the stored procedures, views etc?) The scenario: We have a data centre hosted ...
2
votes
1answer
3k views

What is the best way to determine what's locking up SQL Server using a query?

Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so ...
2
votes
3answers
1k views

Can I restore a SQL server backup (.bak) without the password?

Is there any way to restore a SQL server backup (.bak) without the password? The file is not encrypted so I can see most of the data when I open it with notepad but I can't restore it to SQL Server.
2
votes
1answer
361 views

Programmatically add/delete users in Exchange

I've got the following set up: ASP.Net site that allows my internal employees to add in new hire information (no secure data, just stuff like name/address/phone) and when they submit this it goes ...
2
votes
3answers
18k views

Access is denied error installing SQL Server 2008 on Windows 7

Attempting to install SQL Server 2008 R2, Standard, Developer Edition, and/or Express on Windows 7 Enterprise, I keep getting 'Access is denied' at the very end of the installation. Contents of log: ...
2
votes
3answers
6k views

SQL Server 2008, not enough disk space

I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space. I have also C drive which has sth like 150 MB free (right now). While executing ...
2
votes
3answers
2k views

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I ...
2
votes
4answers
10k views

MySQL asking a user for SUPER privilege to perform a delete

When trying to do a delete operation on a table, mysql reports the following error: Error code 1227: Access denied; you need the SUPER privilege for this operation. However, my user has this ...
2
votes
4answers
269 views

SQL 2005 Standard Questions

I have a question about the tempdb files and hyperthreading. Here are the sw/hw specs. Server 2008 SP2 Standard X64 SQL 2005 Standard Sp3 x64 Dual Quad Core Xeon's E5540's (HT enabled) 12 GB Ram My ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
2
votes
1answer
1k views

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

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
2
votes
3answers
132 views

Server RAID and Partition Config for Small SQL Environment

I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management program....
2
votes
1answer
617 views

Do we really need to perform MS SQL database integrity check regularly?

What's the benefit of performing regular database integrity checks? Can't we just perform it when there's a problem?
2
votes
1answer
3k views

'Service does not respond in a timely fashion' error when restarting Sql Server

When I try to restart my SQL server, I get the following error: Why this error happens and how to solve this?
2
votes
3answers
665 views

Trying to upgrade SQL Server 2008 to R2 getting strange error

The error states: No mapping between account names and security IDs was done. This is during an upgrade of 2008 sql server with sp3 to r2. This results in the database engine not being installed :( ...
2
votes
1answer
71 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
1answer
285 views

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, ...
2
votes
5answers
264 views

sql server - shrink database size

I have a SQL Server 2008 DB. I store mainly text data in it, but also inserted some blobs in it. The size of the DB increased. Now I deleted the blobs, but it seems that the size of the DB stayed the ...
2
votes
1answer
838 views

Installing MS SQL Server 2008 R2 side by side with MS SQL 2008 R2 Express edition

I have to install full version of MS SQL 2008 R2 (it's Web edition) side by side with MS SQL 2008 Express (for a short period, before migrating all db's to full version). I guess that it can be ...
2
votes
3answers
795 views

SQL Server 2005 backups for previous 5 days on disk?

My goal is simple. I want to have SQL Server keep a nightly backup of a DB for a rolling 5 days. So each night at some time I want a new DB backup made and one deleted such that I have a rolling 5 ...
2
votes
2answers
177 views

SQL database testing: How to capture state of my database for rollback

I have a SQL server (MS SQL 2005) in my development environment. I have a suite of unit tests for some .net code that will connect to the database and perform some operations. If the code under test ...
2
votes
1answer
88 views

Role with owner privilege?

How can i create new role and provide owner privilege for specific database in SQL Server?
2
votes
3answers
2k views

SQL CE thread unsafe - alternatives?

I have discovered that SQL CE is not thread safe: SQL CE objects are not thread-safe and are not thread affinitive either. If an instance of SqlCeConnection or SqlCeTransaction is shared across ...
2
votes
5answers
977 views

Copy data from Access to SQL

I have a an access DB that is to be eventually be replaced by a SQL DB with a web front end. The web application is currently in development. I have copied the Access DB to SQL using the Migration ...
2
votes
4answers
3k views

SQL Server I/O Error 21

I am trying to take backup of one DB Which is showing Continuosly I/O Error 21 (The device is not ready) deteceted during read at offset 0x000000000000000040 in file e:\test.ndf Error 823. The Step ...
2
votes
1answer
173 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
6k views

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled ...
2
votes
1answer
655 views

How should I configure my Active Directory servers so that if one goes down, users are not kicked off SQL?

Today, we shut down one of our Active Directory servers during office hours to check the loading on a UPS. Since all the server did was provide Active Directory in a separate building incase the main ...