The sql-server tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for Server Fault. SQL Server programming questions, however, will be generally be better suited for Stack Overflow. ...
0
votes
0answers
9 views
SQL Server Table Size Discrepancy [migrated]
Hopefully this has a simple answer and I've missed something obvious. I have a table where the number of rows * the row size is much smaller then the actual data space used by the table.
If I run the ...
2
votes
0answers
12 views
Using SharePoint to access and modify data in database
I have a situation where I currently have a huge spreadsheet that is used for tracking 40+ deliverables for projects. The spreadsheet solution is past cumbersome.
I have been thinking about how I can ...
1
vote
1answer
32 views
Connecting to SQL Server on EC2 | Elastic IP vs Elastic IP Public DNS
Based on this excellent article by @esh on using external Elastic IP DNS names internally within EC2, I am in the process of changing my connection strings for my web server to connect to a DB server ...
0
votes
0answers
7 views
How to quantify TEMPDB usage in relation to other databases hosted on same hardware? [migrated]
Working on a project to decide if configuration 1 or 2 is the best way to organise disks for my SAN:
Config1 (sql 2008)
8 disks @ raid 10 data
2 disks @ raid 1 logs
2 disks @ raid 1 tempdb
2 disks @ ...
3
votes
1answer
66 views
Unable to start SQL Server 2008 service
I am running SQL Server 2008 R2, and I am having an issue with my local server instance. At first, this only happened occasionally and seemingly completely randomly, but was fixed when I restarted my ...
2
votes
0answers
23 views
Query another cluster group from SQL server?
Is there a way to query from SQL Server in TSQL which node is active in another cluster group in the same cluster?
I have a cluster with two cluster groups, one with resources for SQL Server, one ...
2
votes
2answers
23 views
MSDE 2000 to MSSQL 2008 SQLExpress replication
I have an old database on MSDE which I need to replicate (one-time process) to a new MSSQL 2008 SQLExpress installation. What are my best options to replicate without involving messy sql scripting? ...
0
votes
2answers
26 views
Sql Server transaction log placement in AWS hosting
When running a server on amazon aws, is there any point to placing a sql server transaction log on a separate volume from the database? Of course if I had control of the physical environment I'd ...
3
votes
1answer
35 views
Windows Server 2008 or 2003 for SQL Server 2005
Is there a benefit of using Server 2008 over 2003 for SQL Server? Specifically 2005?
0
votes
1answer
38 views
Advanced SQL Setup
Got a major issue that I need some help with. Here is the situation.
The client has multiple web sites hosted on multiple web servers (virtual machines) running on multiple virtual hosts that ...
1
vote
0answers
33 views
Semi-Annual archiving of SQL Server database [migrated]
Twice a year we create a static, archived subset of our production database. The newly created database contains roughly half of the tables as the production db (log/audit tables, etc. are not copied ...
0
votes
2answers
42 views
How to temporarily stop time syncing with domain controller?
I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time).
...
2
votes
1answer
46 views
Do I need to back up the SQL Server Encryption Password and Symmetric Key?
I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN:
Create the Master Key with a strong password.
Create a ...
1
vote
0answers
29 views
Deadlocks in MS SQL [migrated]
We're currently encountering a problem with out ASP.NET Application that results in deadlocks on the MS SQL database. A bit of background infomation I can provide is that we rely heavy on AJAX ...
2
votes
1answer
34 views
Migrating from Sql Server 2000 to Sql Server 2008
There's a machine running Win7; SQL Server 2000. (Suppose) Remote connections to the machine aren't possible. I need to copy a database from the machine to other one which is running SQL Server 2008 ...
1
vote
0answers
11 views
Are there any advantages in SQL Server Always On vs. SQL Server 2008 R2 Mirroring with only two nodes? [migrated]
We are currently hosting a SaaS website on two Windows 2008 R2 / SQL Server 2008 R2 Servers. Would upgrading to SQL Server 2012 / Always On give us any advantages with respects to high availability?
...
0
votes
0answers
32 views
Do I need an SQL Server 2012 / Windows Server 2012 Upgrade Insurance? [closed]
We are a small SaaS company that has until recently participated in Microsoft's Bizspark program. Now that our Bizspark subscription is over, we have a time-limited oppurtunity to buy discounted ...
0
votes
1answer
24 views
Configure SQLServer 2000 Win7
I've got SQL Server 2000 running on Win7. There's no management tools so I wonder how do I configure/interact with the server. Main purpose for me is to enable remote connections. I know how to do ...
0
votes
1answer
39 views
Service running as local system on server A connecting to SQL server on server B. How?
I have a service running on one server (A) which traditionally runs under the local system account. Now SQL server has moved from server A to a new server B.
I tried adding the computer account of ...
0
votes
0answers
41 views
Connecting to a MSSQL database via unixODBC from a cPanel Host (HostGator)
I'm having differences about connecting between databases and operating systems.
I have a cPanel Unix hosting at HostGator. and I'd like to connect a MSSQL Database in another Windows Server (not ...
0
votes
1answer
38 views
Can I install TFS 2010 using SQL Server 2012?
Can I install TFS 2010 on top of a SQL Server 2012 RC0 installation? I do not need the sharepoint integration.
0
votes
1answer
37 views
Using different ports with multiple instances on SQL Server
In our development environment, we have numerous named instances of SQL Server 2008 running. I have recently added a new one it doesn't work as expected. Here is our set up:
DEFAULT on ...
-6
votes
1answer
77 views
Alert when SQL transaction log becomes too big?
I want to monitor the transaction logs of a database and send some kind of alert once a threshold is reached.
How can I do this?
3
votes
0answers
37 views
Repair mssqlsystemresource.ldf
I accidently deleted mssqlsystemresource.mdf and mssqlsystemresource.ldf.
I undeleted them both, but the .ldf file is corrupted (bad FGID), and because of this I can no longer start up my database ...
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
38 views
SQL Server 2012 performance benchmarks [closed]
Are there any published benchmarks to compare SQL Server 2012 to SQL Server 2008 R2. I am not particularly concerned with the newer features, I really just want to find some benchmarking of queries ...
0
votes
0answers
14 views
SQL Server Cluster Failover Making DB Inconsistency Error [migrated]
I encountered the following DB tables inconsistency error whenever I do a cluster 'move' over from Server-A to Server-B and then do a DBCC CHECKDB on the database in Server-B:
SQL Server detected ...
0
votes
1answer
97 views
Can't update SQL Server 2008 to SP3, it only offers the option to create a new instance
A colleague is attempting to update our server's SQL Server 2008 version 10.0.1600.22 (not R2) install up to SP3. Unfortunately, we can't work out where the "Update" button is; the installer seems to ...
1
vote
1answer
24 views
Is it possible to use xp_cmdshell to format a harddrive?
I was looking through some coding standards at my work and I came across this:
string query = "SELECT * FROM USERS WHERE USER_ID='" + userIdFromWebPage + "'";
userIdFromWebPage is a variable that ...
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 ...
1
vote
1answer
88 views
SQL Server backup strategy consequences
In simple terms, I need point-in-time restore between full backups - what are the consequences in the following plan - the database is in full recovery mode:
1:00 AM Transaction Log Backup (no ...
0
votes
1answer
99 views
Why are SQL Server pages 8 KB?
According to Mark Russinovich's Windows Internals 5th Edition, Windows uses (small) page sizes of 4 KB on both x86 and x64 architectures to manage memory.
Even though I can't find a reason for this, ...
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 ...
2
votes
2answers
46 views
Safe initial sync for SQL Server OLEDB/ODBC Replication
I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider.
I can successfully create a subscription, and transactions ...
0
votes
1answer
91 views
MSSQL 2008 is claiming the firewall is blocking ports even from local machine
I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message.
The windows firewall on this machine is currently blocking remote ...
0
votes
1answer
19 views
High MSSEARCH Wait Type in SQL Server 2005
This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem.
The server had been running with no problem for several weeks until the other ...
0
votes
1answer
45 views
SQL Server Failover and Licensing [closed]
Possible Duplicate:
Can you help me with my software licensing question?
How many servers can I install SQL Server 2008 R2 Standard Edition on? I'd like to set up a backup server in case my ...
0
votes
0answers
12 views
TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers [migrated]
I've got an issue with SQL Server.
The value of TdsInputBufferError is not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers.
This happens randomly, once or twice a week, ...
0
votes
0answers
59 views
sql query help to get unique records [closed]
I need a help in writing a query which only select one record from the table . I have four tables , all linked to each other .
Accounts
acctno
303753
304759
303381
Customer
...
0
votes
1answer
27 views
SQL Server reporting services shutting down without log info
Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I ...
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
0answers
7 views
Can I restore the defult SQL Server Public Role? [migrated]
I setup a new user login and attached it to a specific database on my server. I then opened up management studio on my local pc, connected to the database using the server IP and selecting the ...
0
votes
0answers
27 views
Install pdo_dblib in Ubuntu for connect to SQL SERVER
Iḿ trying to install PDO_DBLIB to connecto to my SQL Server throught symfony2 but Iḿ getting errors when I launch this:
pear/PDO_DBLIB requires PHP extension "pdo" (version >= 1.0)
No valid ...
0
votes
2answers
61 views
Can't Connect to (local) database
I have SQL Server 2008 and was forced to make a new windows 7 profile. I no longer can connect to my (local) databases.
Everything I try to use windows authentication to login I get
Cannot ...
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 ...
1
vote
0answers
17 views
How does one scale SQL Server 2008 or 2012? [migrated]
How does one scale SQL Server 2008 (or 2012)? At its basic, I understand there are two options:
Scale up:
If CPU bound, I can clearly see going from 1 CPU core to 2 to 4. Or if RAM usage rockets, ...
0
votes
2answers
118 views
Limitations of SQL Server 2012 Express version?
I'm aware that the SQL Server 2008 R2 Express was limited to 1 CPU and 10 GB Databases. It's not clear if Microsoft bumped those numbers up to be more reflective of 2012. I looked at several places ...
0
votes
2answers
119 views
Is it possible to restrict SQL server access to a Hamachi VPN?
We already use Hamachi to link our isolated servers together, but it is possible to restrict access to certain applications so that they can only be seen on the server or via Hamachi's VPN.
From our ...
