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
10
votes
2 answers

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers

Tl;Dr I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its own IP address) which are all running on one…
John K. N.
  • 2,055
  • 1
  • 17
  • 28
10
votes
3 answers

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want to use the slow disk for anything where it doesn't…
Niels Brinch
  • 413
  • 5
  • 16
10
votes
4 answers

Sql Server Management Studio 2008 has suddenly become unresponsive

I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is no [not responding] message. It doesn't respond…
John Hoge
  • 619
  • 3
  • 7
  • 14
10
votes
6 answers

cannot add a user to sysadmin role in SQL Server

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008. My issue is, after log into SQL Server Management Studio, I select…
George2
  • 1,137
  • 6
  • 22
  • 41
10
votes
1 answer

SQL Server express service is not starting

I've bought my first VPS yesterday, and I have installed Microsoft SQL Server 2012 Express on it. Then I have restarted my VPS. But SQL Server Service didn't start. I've tried to start it manually, but It can't start: What is the problem? How to…
Mahdi Ghiasi
  • 361
  • 2
  • 4
  • 15
10
votes
1 answer

How to delete MSSQL database using sqlcmd

I have multiple databases created by POCO approach of website building and I want to delete those. However I get error. Command sqlcmd -S .\SQLEXPRESS -q "drop database aspnet-ORData-20120910180110" Error Msg 102, Level 15, State 1, Server…
sed
  • 297
  • 2
  • 4
  • 13
10
votes
4 answers

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 with Quest Lightspeed compressed backup, if that…
BradC
  • 2,220
  • 4
  • 27
  • 36
10
votes
14 answers

What Are The Reasons to Still Use SQL Server 2000?

From the questions on StackOverflow and elsewhere, I notice that there are still people using SQL Server 2000. To be honest, the greatest effect on me is that I have to remember how we used to do things without Common Table Expressions. Still, I'd…
John Saunders
  • 425
  • 7
  • 22
10
votes
3 answers

Automating the rename of a SQL Server

We're in the process of replacing our SQL Server and have decided that renaming the server itself is going to be much easier than changing everything else to point to a new name. We found instructions on changing the SQL Server instance name to…
Scott
  • 1,173
  • 3
  • 13
  • 25
10
votes
6 answers

How to migrate from SQL Server 2005 to 2008

How do you migrate SQL Server 2005 databases to SQL Server 2008? Is it as easy as backing up 2005 databases and simply restore in 2008? Are there any compatibility issues? Is SQL Server Reporting service changed in anyway? How would you go about…
dance2die
  • 2,011
  • 7
  • 32
  • 41
10
votes
4 answers

SQL Server Backups using Volume Shadow Copy

Many well-known backup utilities for Windows use the Volume Shadow Copy Service built in to newer versions of windows to create a point-in-time snapshot of the disk in order to safely back up open files. But how well does this mechanism play with…
tylerl
  • 15,055
  • 7
  • 51
  • 72
10
votes
2 answers

How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64

As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our new SQL Server 2008 R2 x64 nodes. I have done the…
SomeGuy
  • 387
  • 1
  • 3
  • 16
10
votes
7 answers

Reclaiming memory from SQL Server

I have an SQL Server instance who's memory usage gradually grows until windows will give it no more. It seems logical that the occasional big query result would cause the instance to grow. Is there a way I can convince SQL Server to release the…
BIBD
  • 1,866
  • 10
  • 30
  • 44
10
votes
3 answers

SQL Server: Statements vs. Batches vs. Transactions vs. Connections

My question is simple: What are the differences / similarities / cardinalities between Transactions Batches Connections and Statements in SQL Server? As far as I understand a connection is a single communications channel between a SQL Server…
Sleepless
10
votes
5 answers

What's the lowest cost, legal, Microsoft server stack you can assemble?

Assuming that you have an app infrastructure that generally only requires: ASP.NET MVC / C# / .NET Database or NoSQL data store (must be accessible from C#) Here's the challenge to you server gods: What is the least expensive configuration that…
McKAMEY
  • 635
  • 1
  • 6
  • 14
1 2 3
…
99 100