Tagged Questions

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 ...

learn more… | top users | synonyms

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. ...

1 2 3 4 5 13