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 tsql for SQL Server & Sybase, plsql for Oracle and PostgreSQL and MySQL) it is a fractured language and ...
1
vote
1answer
28 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?
1
vote
2answers
36 views
Is it a good idea to compress a MS SQL database backup?
Quick question! I heard that we should never shrink our databases. However, does the same rules apply to compressing our SQL backup?
Thanks
0
votes
1answer
15 views
application response times grinding to a halt in .net - cant stop crashing
We have about 200 desktops across the US using our point of sale/website application on a daily basis. This application is considered mission critical and cannot go down for our retailers.
For the ...
2
votes
1answer
26 views
How to store text inputs of unknown & varying size?
I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
-1
votes
1answer
26 views
Redundant / partially duplicated data in a DB - how to structure?
I'm building a website for which a large amount of user generated data will be stored in a back end db and will be discoverable by all users.
By its nature, a portion of the user entries will be ...
1
vote
1answer
29 views
Does an Amazon EC2 Reserved Instance with SQL server include an SQL licence?
I was wondering if in the Amazon EC2 Reserved Instance with SQL server, the extra cost was just for the ability to run an SQL server. Or if this included a license and SQL.
It would be a real bummer ...
0
votes
1answer
29 views
Setting up a dedicated mysql server
I got a dedicated VPS and installed mysql on it(I am new at this).
Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when ...
0
votes
0answers
7 views
Uninstalling SQL Server 2008 R2 Setup Files
When I uninstall SQL Server 2008 R2, it wants to browse for this:
c:\b2fe4f480bc6ba1c7ba978\1033_ENU_LP\x86\setup\sqlsupport_msi\
What is this file and where can I find it?
1
vote
2answers
63 views
SQL Server 2008 R2 / 500queries a sec
I am running an application that query the database a lot, around 500 queuries (insert/update/select) each second. I want to buy a dedicated server to run that application, there are mainly 3 tables ...
1
vote
0answers
8 views
Executing Stored Procedure that accesses another SQL instance [migrated]
I apologize if this question repeats another already asked. I have searched for hours and have not found one that fits my situation.
Desired Outcome
A user using SQL authentication has execute ...
0
votes
0answers
6 views
securely exposing sql server 2008 for windows authentication [migrated]
we have an internal sql server 2008. currently we do not expose the IP to the outside.
we will have 100 users connecting to this database remotely, and now we will have to expose the IP to the ...
0
votes
1answer
20 views
Cannot connect to sql server from vpn client
I have a client that using openvpn is connecting to a remote lan where i have a openvpn server (zeroshell)
i can use any service without troubles.
Now i am trying to connect to a sql server sitting on ...
1
vote
0answers
21 views
SQL Server Management Studio Issue
I am trying to run a query on my hosting database. I can connect to the server just fine, but when I open the query window, the bottom says "Disconnected". When I right click on the query window and ...
3
votes
2answers
33 views
Impact of keeping 100+ Linked Server Objects open in MS SQL Server
I manage a large scale cloud based product that uses SQL Server as the database engine. The model is designed that each customer using the product has their own instance of MS SQL Server. I'm needing ...
0
votes
1answer
41 views
MSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time Restore
Current major problem with backup sizes - I have been through many questions but am finding conflicting scenarios. I have multiple databases with the same problem but using one as an example, here are ...
0
votes
0answers
6 views
Adding multiple invoices from row b in sql for all of each company name in Row A [migrated]
To put it simply, I have a table with multiple companies on Row A, and invoice amounts in Row B.
How would I write a query that will add and then show the total invoice amount for Company A, Company ...
0
votes
0answers
27 views
Oracle 11g production database copy to USB drive [migrated]
What is the correct commands for backing up a production Oracle 11g database (while still running) to an external USB drive or different directory.
I am new to Oracle and but have experience with SQL ...
0
votes
0answers
17 views
Adding new columns in SQL Server table through SQL adapter
We are getting data from an external website via BizTalk 2009. Several SQL Server tables are being updated with this data through a SQL adapter and SOAP. So the Visual Studio 2008 project that already ...
0
votes
1answer
13 views
sp_sqlagent_get_perf_counters sql 2005 running every 20 seconds
A little background info:
We are running SQL Server 2005 SP2 on a server with Microsoft Windows Server 2003 SP2.
When I run profiler I notice that EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters is ...
0
votes
2answers
59 views
oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist
I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
-1
votes
0answers
17 views
sql server 2008 R2 workgroup edition [closed]
Possible Duplicate:
Can you help me with my software licensing question?
I need to know how many CALs come by default with the sql server 2008 R2 workgroup edition.
i have heard 5 come as ...
0
votes
0answers
16 views
Sudden reduction in full backup size [migrated]
I recently repaired a single corrupt page in one of the tables in a 70gb database.
I had a backup which included the data contained in the page so I went about using DBCC CHECKDB with ...
1
vote
1answer
23 views
MySQL - Changing FT_MIN_WORD_LEN (my.ini)
I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4.
...
0
votes
1answer
98 views
Space availability issue
I am using SQlserver2005. My database are becomeing very large and space is becoming very sparse.
Please suggest what to do? (apart from buying space)
1
vote
3answers
69 views
Can we restart a SQL Server instance remotely?
I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled
I am connecting ...
0
votes
0answers
37 views
SQL based database is slow and periodically crashes
This seemed to have happened after a server restart and a server restart seems to temporarily solve the problem. Everyone's database does not crash at the same time. Mine may be working while someone ...
0
votes
1answer
21 views
Non Clustered Covering Index Column Selection Rules
I have a table with around 19 columns which contains reasonable large amount of data and is primarily being queried to retrieve data using select statements based on different where clause. Since this ...
0
votes
1answer
45 views
PC can't log into SQL Server on different peer network
I have a basic peer network (WORKGROUP) with PCs connected to sql server 2008 on a Windows 7 machine. I took one XP pc and the server home and connected to the server with no problems. When I plugged ...
-1
votes
0answers
41 views
Distributing Server on the Internet with guarantied security [closed]
Possible Duplicate:
Distributing SQL Server on Internet regarding security issue
Solutions for distributing Website on SQL SERVER
Subject:
We are going to put our servers in two places to ...
-2
votes
0answers
31 views
unable to delete data from database table [closed]
<?php
// connect to db
include ("../../config.php");
$db_server = $db_host;
$db_name = $database;
$db_username = $db_username;
...
0
votes
2answers
45 views
Howto enable remote login for a Oracle db user?
Stupid question:
I've successfully installed Oracle 11g on my Linux box.
I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
0
votes
0answers
21 views
Subdomain redirect via SQL database, PHP and .htaccess?
I'm having difficulties trying to set the following up:
Currently,
User shortens a URL via PHP script, and it outputs http://example.com/3701 where that redirects to the page they inputted, as it is ...
2
votes
1answer
48 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?
0
votes
1answer
91 views
Viewing history for Maintenance Plan causing out of memory exception
I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
1
vote
2answers
113 views
Distributing SQL Server on Internet regarding security issue
We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
1
vote
1answer
54 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 ...
1
vote
2answers
58 views
Cannot connect to a MySql Server using MySql Workbench with no apparent reason
I can't connect via TCP/IP to the MySQL server.
The server is installed in a Debian Linux and there's a PostGreSQL server running at the same time. (which is working fine and has tcp/ip connection ...
0
votes
3answers
127 views
VMWare SQL 2008 R2 Windows 7 High memory usage
I have a windows 7 64 bit installed in a VM which runs SQL Server 2008 R2 and IIS7.
The server itself has 12 gigs of memory and is equipped with a dual core intel xeon @ 2.50 GHz.
The problem (I am ...
0
votes
1answer
38 views
Change SQL Service Account
I just have the sa user to log into a sql 2005 express server. the service is running as networkservice. is there a way to change it to localsystem with sql server management studio or any other ...
-5
votes
2answers
44 views
Learning PostgreSQL after using MySQL
I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki ...
0
votes
2answers
43 views
Split large sql file by location of string OR start sql from last fail
I have a 15GB sql file which is a backup of a database. The problem I have is that half way through it, it failed. Luckily, I know which table to pick up from.
Is there a way I can split this SQL ...
1
vote
1answer
52 views
Remote connection to SQL Server 2008 in LAN
I try many ways, but still doesn't work.
MSSQLSERVER is running.
SQL Agent is running.
SQL Browser is running.
TCP/IP is enabled (something else inside it must I change?)
Named Pipes is enabled
...
1
vote
0answers
44 views
How to generate test data from an sql query and a result set?
I am using an oracle database and want to generate test data from a live database, but I do not want to
copy the whole database content.
Given a database DB(S, D) consisting of the database schema S ...
0
votes
6answers
63 views
Win7 vs WinServer for SQL installation
Is there any performanace/functional difference for using Windows 7 64 or Windows Server 2008R2 for SQL Server installation?
My server only has 8G Ram, Single CPU of 8 core and RAID 1 SAS.
0
votes
1answer
103 views
Connect to SQL Server 2005 In Different Network
I need a help on SQL Server Remote Connection Issue.
I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which ...
-2
votes
3answers
80 views
True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query? [closed]
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 ...
0
votes
0answers
69 views
can't login to new install of SQL 2008 x64 via SSMS
I have performed a fresh install of SQL 2008 x64 on a fresh install of Server 2008 R2 x64 in an AD environment. Upon install completion, I cannot login to the SQL Instance via SSMS, with the following ...
0
votes
0answers
24 views
ORDER BY in VIEW returns diffrent results SQL
This is my VIEW:
USE [STD_DATABASE]
--
-- Kill the procedure if it exists
--
IF (EXISTS (SELECT [name] FROM [sysobjects]
WHERE (([name] = 'view_TransInvoice') AND ([type] = 'V'))))
DROP ...
0
votes
3answers
63 views
How to warehouse data that is not needed from MS SQL server
I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed.
The question is, ...
4
votes
1answer
58 views
SQL Server Restore from Backup, Just primary File Group
Thankfully, this question is just a what-if, and I am not in an emergency right now.
But I have created a file group in my database (sql server 2008), and moved some massive data tables over to it. ...
