Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.

The 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 serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
2
votes
6 answers

SQL Server 2005: Selects good, Inserts bad

We've come across a perplexing problem with our database application. We're running the application in 3 different (but similarly spec'd) environments. Select Insert Env1 0.81ms 0.94ms Env2 0.69ms 5.79ms Env3 0.52ms 15.61ms We…
DerRubberDucky
2
votes
1 answer

In-Place Upgrade of 64-bit OS and 32-bit SQL Server to 64-bit SQL Server - Is it possible?

Not sure if this is possible, or what the steps are if it is. We have a server running Windows Server 2003 R2 64-bit as the OS, and SQL Standard Edition 2005 32-bit. I have been tasked to upgrade the OS to Windows Server 2008 R2 64-bit AND the…
charnley
  • 577
  • 3
  • 14
2
votes
2 answers

sys.dm_db_missing_index_stats reports existing index

I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ... The following query returns missing indexes that are actually created on the tables. select * from sys.dm_db_missing_index_details where database_id =…
electricsk8
  • 65
  • 5
2
votes
2 answers

Can I replicate data between mySQL and SQL Server/SQL Azure?

I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to replicate the data over to there as well. So that's…
Ernest Mueller
  • 1,199
  • 2
  • 12
  • 25
2
votes
3 answers

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.
Noel
  • 123
  • 1
  • 3
2
votes
2 answers

SQL Server R2 different versions on x86 and x64?

I have the latest SQL Server 2008 R2 installed on a W2K8 server. The version number says "10.50.1600". My problem is that my backup fails to restore on the x64 machine. I downloaded and installed the latest from Microsoft's page for a Windows 7…
TruMan1
  • 435
  • 2
  • 9
  • 18
2
votes
2 answers

Just discovered a log file occupying over 12Gb, what do I do?

trying to figure out how come my disk space was so low I discovered a log file occupying over 12Gb... is this normal? how do I prevent this from happening again if not? do I just delete it? Any ideas? Thanks :)
RadiantHex
  • 547
  • 2
  • 9
  • 18
2
votes
4 answers

How to change storage location of a database?

my hard-drive is currently almost full!! I need to migrate the db to a different drive, how can I do this? They are all stored in the default C:\ drive. Any ideas?
RadiantHex
  • 547
  • 2
  • 9
  • 18
2
votes
2 answers

SQL Server Remote Connections

I am at my wits end with trying to access a remote SQL Server 2008 R2 Express instance. Here are the following that I have tried. 1) I enabled remote connections in the instance properties. 2) I enabled sql server and windows authentication mode and…
Barry
  • 185
  • 1
  • 3
2
votes
2 answers

SQL Server Full Text Search resource consumption

When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour period of the exact amount of CPU and…
Sam Saffron
  • 1,979
  • 3
  • 18
  • 27
2
votes
2 answers

Database/Web Server and SQL Server Setup - Security?

This seems really basic, but I couldn't find an answer already ... we are looking to deploy a website to an IIS server, and a database to a separate server. We aren't sure how to best secure this for access by internal users and internet. The IIS…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
2
votes
4 answers

Is allowing remote Sql Server Management Studio safe?

I administer a website that runs on IIS on one box, and SQL Server 2008 Workgroup on another box. typically I remote into the DB box and run SSMS to work on the db, but I would like to be able to access the db directly with SSMS on my local box. …
dave thieben
  • 123
  • 5
2
votes
1 answer

Is it possible as an Administrator to gain access to a SQL Server 2008 instance without changing any passwords?

I have administrative access on our network, but I don't manage the installation of all servers or software. On some of our machines instances of SQL Server 2008 have been installed which I need to be able to access, but since my account hasn't been…
adhocgeek
  • 159
  • 1
  • 5
2
votes
6 answers

Setting up a network e-mail server

My boss just asked me to buy a new server for our office network. I know next to nothing about servers and networking, so I need someone to point me in the right direction. He said he wants this to be our e-mail server with a network login. I have…
Jason
  • 21
  • 2
2
votes
1 answer

Add shortcut SQL management studio 2008 to select top 1000 order by PK desc

when I right click a table I can select select top 1000 rows and edit top 200 rows I'd like to add an option select bottom 1000 rows I am pretty sure that I've seen it somewhere online how to do this. But I can't remember where... already found…
JP Hellemons
  • 267
  • 6
  • 16
1 2 3
…
99 100