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
1 answer

SQL 2008. What permissions needed to see log file free space?

I need to see how much space my log file has. What permissions need to be granted to do so? What script shall I run to see that? Thank you
Boppity Bop
  • 752
  • 3
  • 11
  • 34
2
votes
1 answer

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire procedure cache is cleared which in turn is forcing…
Equixor
  • 73
  • 1
  • 3
2
votes
1 answer

MSSQL 2008R2 Service Broker Initiator Queue Filled With Old Conversations

My initiator queue is filled with about 18 million old messages of either EndDialog or Error message_type_name. Apparently the Microsoft sample code I used to set up internal activation (http://msdn.microsoft.com/en-us/library/cc281517.aspx) didn't…
Aushin
  • 175
  • 6
2
votes
1 answer

many partitions on a single filegroup?¿ does it make sense?

I'm designing a datawarehouse solution and I'm a newbie in disk configuration issues, let me explain you. Our storage is spread over 6 storage enlosures having each of them 5 raid-1 disk arrays, and having 2 LUNS defined per each disk array, which…
river0
  • 123
  • 3
2
votes
5 answers

sql server - shrink database size

I have a SQL Server 2008 DB. I store mainly text data in it, but also inserted some blobs in it. The size of the DB increased. Now I deleted the blobs, but it seems that the size of the DB stayed the same. How can I make it shrink?
Cyan
  • 121
  • 2
2
votes
2 answers

Did I read somewhere that if you purchase SQL Server Enterprise 2008 R2 the license is good to install on 4 separate servers?

Did I read somewhere that if you purchase SQL Server Enterprise 2008 R2 the license is good to install on 4 separate servers or am I imagining things?
Jeff Stock
  • 135
  • 1
  • 5
2
votes
3 answers

Why can't I connect to remote Microsoft SQL Server through SSH tunnel?

I have at home a D-Link DIR-615 C1 router with DD-WRT. I set up the SSH server on the router, and log on through an SSH2-RSA passphrase-protected key. That router is the gateway between the local network and the internet. One of the computers on…
Alex
  • 163
  • 1
  • 1
  • 9
2
votes
1 answer

What are minimum number of services I need to start to have w working sql server?

I'm looking to start the very minimum number of services to have a fully working version of SQL Server running that will enable external connections. I know MSSQLSERVER is required but do I need to start SQLSERVERAGENT, MSSQLServerOLAPService,…
Webmonger
  • 203
  • 2
  • 7
2
votes
1 answer

Using HAProxy for load-balancing SQL Server 2008

Is it possible/feasible/reasonable to use HAProxy to load-balance three SQL Server 2008 database servers? Here is our situation: we have two web servers that are load-balanced on Amazon EC2. We are currently using one production SQL Server 2008 DB…
htxryan
  • 123
  • 1
  • 5
2
votes
2 answers

High context switches on SQL Server box

We have a server with 2 quad xeon 5550 processors. The only application installed on the server is SQL server. CPU usage rarely goes above 40%, and the transaction rate is 2,000 transactions per second. Processor queue length is also about 2.…
Parissa Bakhshi
  • 21
  • 1
  • 2
2
votes
2 answers

SQL Server 2005 log file is getting too large

I have an initial DB which I have to import very often during development, this DB is not large but it seems like the transaction log file is getting bigger and bigger, so each time I have to delete the database recreate it... Does any body know to…
O.O
  • 133
  • 14
2
votes
3 answers

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a "bottleneck in the IO Subsystem". Unfortunately I…
Abe Miessler
  • 925
  • 4
  • 11
  • 20
2
votes
3 answers

How to migrate the data directory for MSSQL Server?

I have an installation of MSSQL where I would like to move the data directory to another drive so that all the existing databases are located there and all new databases are created there, as well as the backups, logs, etc. I know I can…
Ryan
  • 123
  • 3
2
votes
1 answer

How do I install ONLY the bcp program for SQL Server

Just like the title says. All I need is the BCP program on my client computer. The BCP will be from a remote machine, so I don't want to install SQL Express or the management studio or any of that. How can I do this?
Jasmine
  • 145
  • 1
  • 6
2
votes
2 answers

MSSQL database mirroring

Reading over (and then testing out on a test database) the setup for mirroring it appears that one is supposed to leave the mirror database in restoration mode for normal operations. is this correct? at whatever point it becomes necessary to…
Devnull
  • 951
  • 1
  • 7
  • 23
1 2 3
…
99 100