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 ...
0
votes
0answers
4 views
IIS 7.5 ApplicationPoolidentity when SQL Server is on another server
Could someone advise on best practice for setting up the Application Pool Identity for the web service under the following scenario
IIS7.5
Web Service requires read/write permission to SQL database
...
1
vote
2answers
30 views
Is it a good idea to back up SQL database to an External USB Hard Drive?
I will be installing a Database System on an Offshore Oil Platform (rack Servers). They have very limited hardware and space therefore sending up a backup infrastructure is not possible. Sending ...
0
votes
3answers
195 views
What database server will benefit from 4 CPUs
I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow.
What ...
0
votes
2answers
25 views
How to dump a part of a table from PostgreSQL?
I have a PostgreSQL database with a multi-Gb table (which contains a log of certain events). I need to pass the latest events to an analyst - let's say he only needs events from the last month.
How ...
0
votes
1answer
12 views
Why ALTERDB reports “No checkpoints available to delete” even though I have them on the filesystem?
This morning I was greeted by Ingres 10.0.0 with the following:
[ingres@denux ~]$ alterdb dejandb -keep=60
Mon May 28 08:54:17 2012 ALTERDB: No checkpoints available to delete.
[ingres@denux ~]$ ls ...
1
vote
2answers
67 views
Ridiculously slow queries on Microsoft SQL Server 2008 R2
I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
0
votes
2answers
36 views
SQL Server 2005: Move account from one server to another while maintaining unknown password
There is a user account that someone set up on one of our database servers long ago, that no-one any longer knows the password for. However some apps have the password (for various reasons we cannot ...
2
votes
3answers
69 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 ...
0
votes
0answers
45 views
SQL Server Management Studio 2008 won't open
I'm trying to open SQL Management Studio 2008 to attempt to work with a server I have just set up, and to import an .sql file, but for some reason when I attempt to install and run the software it ...
1
vote
0answers
36 views
Save Images from MS SQL SERVER to a file on hard disk
I'm wondering if anyone knows of a free tool, or the actual SQL command that will save a binary image stored in a SQL SERVER 2008 R2 database to a file on my hard disk.
I use Heidi SQL which works ...
1
vote
1answer
36 views
“distinct” query returning me multiple records [closed]
On executing the following query I am getting multiple records as result with each having id=10. If I am using distinct keyword, then I should get just one record. What could be the cause?
"select ...
-1
votes
0answers
9 views
Where condition not working in Declare table variable sql 2005, 2008, r2 [closed]
i'm wrtting a compelx algorithm , which ncludes manipulations
how ever i cannot put where condition in my declared table ,
Please suggests
2
votes
1answer
47 views
Are Previous Microsoft SQL Installations Needed After SQL 2012 Upgrade?
Are the older installations of Microsoft SQL Server needed after you installed Server 2012?
I've been doing some cleaning and noticed I've a whole list of SQL Server installation.
When I installed ...
6
votes
1answer
116 views
Are vCPU the same as 1 Socket, or a single Core?
Currently I have a Hyper-v VPS with 2 (vCPU) processor. I would like to install SQL Server Express 2012 that has a limitation of 1 Socket or 4 Cores, whichever the lesser.
My Question: Are vCPU's ...
0
votes
1answer
22 views
SQL Server Expensive Select Queries from unknown source
When viewing Queries by CPU usage with Performance Dasboard, I notice a great deal of queries like "Select * from dbo.sometable". What is the best way to go about tracking the source of these queries? ...
0
votes
1answer
11 views
SQL server 2005 installation SP1
I have got problem with installation SP1 and SP2 to SQL server 2005 I get this text -> Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of ...
0
votes
0answers
43 views
Add a SQL user similar to a current user via PowerShell?
I'm slowly but surely perfecting a new user script. As it is, my script will do everything to add a new user to our domain, except one thing. We have an in-house program, webpage front end that ...
-1
votes
1answer
44 views
Windows Server 2008 R2 Cluster with just two nodes
May be this question was already made, but I dont find an exact answer to my dilema.
I have a consulting IT job, my client have only 2 servers (16GB RAM, 2 Xeon 5160 and 500GB HDD) and him want to do ...
0
votes
1answer
39 views
How is the SQL Server Folder “C:\Program Files\Microsoft SQL Server\” is organized?
In C:\Program Files\Microsoft SQL Server\, I'm seeing many sub folders such as
80
90
100
MSAS10_50.MSSQLSERVER
MSRS10_50.MSSQLSERVER
MSSQL10.50.MSSQLSERVER
What are these sub directories for? Are ...
0
votes
0answers
32 views
Re-Ask - why would adding a crossover private nic cause IP address resource fail? [closed]
Possible Duplicate:
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 ...
0
votes
2answers
71 views
MSSQL Server Express: How to reclaim unused space
At our company we are using a proprietary third party custom application that uses SQL Server Express as its backend. As you are aware SQL Server Express 2008 has a hard 10GB limit. For the “old” data ...
1
vote
1answer
30 views
SQL Server Log Databases Starting Up Every Hour
I have been doing an audit of my SQL Server log, as I 'thought' it was locked down but appeared to be open and we were getting a lot of password attempts on the SA account.
After sorting that, I have ...
0
votes
1answer
39 views
Database server migration and SQL Server 2008 licensing [closed]
Possible Duplicate:
Can you help me with my software licensing issue?
We currently have a dedicated server that hosts a number of websites and also has SQL Server 2008 Enterprise running on ...
2
votes
2answers
94 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 ...
5
votes
2answers
47 views
My table half-exists. Can't drop it
I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist.
It shows up in ...
1
vote
1answer
41 views
Manaul SQL cluster failover on 2008R2
I need to do a restart of the clustered SQL instance to fix a problem with tempDB and i am not sure of the easiest way to do this. We have just upgraded our servers to Windows 2008R2 running SQL ...
0
votes
2answers
53 views
Creating a SQL Template for VMware
Are there tools and/or scipts available to create a 'Golden' VMware SQL template? We are gearing up to create a number of SQL servers running in our virtual farm and have yet to figure out how to ...
1
vote
2answers
64 views
How to leave only e.g. TOP 100 records in ALL TABLES in database (SQL SERVER 2005)
I'm having a huge database over 100GBs and I need to burn an application (for demonstration purposes) on CD or DVD which uses this huge database... is there a way how to leave for example only first ...
0
votes
1answer
29 views
SQL server 2008R2 - how is it connected to a .NET application? [closed]
I would like to understand in simple English, how do .NET applications and how do websites get (fetch) information from SQL server.
So there is the SQL server on one side, the front end application ...
2
votes
3answers
42 views
How do I secure Sql Server 2008 R2
I have both a dedicated and a VPS (from Fasthosts) virtual server - the web sites/applications I run on these, access Sql Server stored on the same web server.
Until now, I have logged onto Sql ...
1
vote
1answer
84 views
MAX Connection Pool Setting SQL Server 2008
We are expecting a large number of users to hit a Website built with IIS/.Net 4.0 that our SQL Server 2008 database server is providing data for. The database is around 2GB in size. We are ...
0
votes
0answers
18 views
SBS 2003-2011 backups and sql
This may be a stupid question but does ntbackup and new windows backup backup live SQL databases? for example they are all set to backup the whole C and D partitions, if the server explodes will I get ...
2
votes
2answers
86 views
Memory Usage of SQL Server
SQL Server instance on my server is using almost full memory available in my Physical Server.
Say if i am having 8GB of RAM than SQL Server is using 7.8 GB of RAM from system.
I also have read ...
-1
votes
5answers
256 views
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 ...
0
votes
1answer
59 views
Manual backups of Production SQL Server Databases
I was once told that running manual backups of SQL server databases from Managament Studio was a big no-no on production databases as it can interfere with the automated backup jobs on the server. ...
-3
votes
1answer
58 views
How much server memory do I need for a 2TB Database SQL Server? [closed]
We have calculated the initial database size for this implementation to be 2TB, rising by 1TB per year. How much memory would you recommend for the server?
Its a business application, reads and ...
0
votes
1answer
58 views
SQL Server doesn't allow to execute subquery as dynamic SQL
I tried to make a dynamic SQL which gets all tasks for some users
The procedure [GetAllSubExecutorsByUserId] returns IDs of all subalterns of curent user I write these IDs into a temporary table, and ...
0
votes
1answer
47 views
using command line to extract large db file
I have a large database file (1.5GB) named file.sql, I use "source" command to extract it into mysql databse but I receive lots of error messages. It used to work fine.
Here is a snapshot of part of ...
1
vote
2answers
67 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 ...
0
votes
1answer
20 views
Website and DB Backup - Windows Dedicated Servers and SQL Express
I have inherited a number of dedicated windows web servers running websites and local SQL Express Databases.
We want to backup both the sites and the databases remotely - maybe to some cloud storage ...
0
votes
1answer
35 views
Undo SQL Server Management Studio Restore
I accidentally did a restore on the database and now I want to undo it to the state it was in before restore. The version I used to restore was a week ago and that's the latest backup I have. All the ...
-1
votes
2answers
42 views
MSSQLSERVICE 2008 R2
I have Microsoft SQL Server 2008 installed and running but I can't seem to see COMPUTERNAME/MSSQLSERVICE at all.
I have COMPUTERNAME/SQLEXPRESS but that's not the right one.
Ideas?
0
votes
5answers
112 views
Move MySQL DB to another server
I have server with very big mysql database (160GB).
How easy way to move this DB to another server?
-1
votes
1answer
57 views
Big SQL database platform that performs well [closed]
I would like to know your opinion on which DBMS (probably SQL) can perform fairly well and not stress the server too much from the CPU / RAM point of view.
I'm used to MySQL but I found (maybe it was ...
1
vote
1answer
21 views
check which SQL server jobs run between 5AM - 11PM [closed]
Possible Duplicate:
Get a list of SQL Server Agent Jobs
is there a way to query the job schedule DB, and list out the jobs names, their schedules, frequency, and filter them, such that if I ...
0
votes
2answers
68 views
Any way to allow local computer login to access domain network remotely?
I am setting up a laptop for a customer (Windows 7). He needs to be able to access SQL server on his office network while on the road.
What we are trying to do:
Since he will be out of the office, he ...
0
votes
1answer
43 views
dotnet framework 2.0 sp2 breaks CLR integration in SQL server
It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr.
Msg 6510, Level 16, State 11, Line 1
...
0
votes
2answers
42 views
Is it possible to check a date in SQL?
I'm trying to write a Microsoft SQL Server stored procedure which takes an account ID, and returns an authentication ticket and whether the ticket is expired.
Something like this:
SELECT ...
1
vote
1answer
43 views
Seeking Opinions - Is it a good idea to rely SQL backup 100% on transaction logs?
I'm in the midst of changing my company's SQL Server backup practice. We use to create full backups weekly and daily differential backups overnight. The issue is that as these full backups grow, it ...
1
vote
2answers
33 views
Is it possible to get a list of all jobs that access a database in SQL server?
Is it possible to get a list of all jobs that access a database in SQL? I can't figure a way to do this. I can get a list of all jobs but not what dbs they access.
Thanks
