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

High Transaction System Recommendations

I am a SQL Server database administrator and developer and I also have many years experience as an application developer. I currently have a customer with a very big project who is looking to me for direction. The customer has started development…
Todd
  • 21
  • 2
2
votes
3 answers

How can I monitor failed job steps on SQL server?

We have two MS SQL servers (one 2000 and one 2005) that run a number of jobs at various time during the day and night. These jobs have a number of steps that will pull data from an Informix database (our business system) and update tables for use by…
Swinders
  • 219
  • 6
  • 10
2
votes
4 answers

SQL Server 2005 / 2008 Licensing question

Possible Duplicate: Can you help me with my software licensing question? I have read up online, and through some threads here like this one. But I'm still confused and need to see if anyone can shed some light. My company is deploying a clickonce…
Jose
  • 167
  • 2
  • 7
2
votes
1 answer

Database 28 cannot be autostarted during server shutdown or startup

I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error. TITLE: Microsoft SQL Server Management…
Rauf
  • 199
  • 1
  • 2
  • 8
2
votes
2 answers

SQL Server Costs

Possible Duplicate: Can you help me with my software licensing question? I`ve been looking on the web for quite a long time to find out the pricing for SQL Server. Microsoft makes you browse for a long time until you find some piece of info.…
Doron
  • 21
  • 1
2
votes
1 answer

Should I consider shrinking or truncating a big LDF file?

I apologize for asking a question that gets asked a lot. I have a database that has an 80GB LDF file. MDF is 230MB. I have never shrunk or truncated the database. I do not know much about shrink and truncate. It is a SQL Server 2008 R2…
obautista
  • 149
  • 1
  • 7
2
votes
1 answer

Categorize sites in IIS manager

We're hosting >100 websites on a single IIS7 server, and adding about a dozen monthly. The problem is using the IIS manager - it displays all of the sites under the "Sites" node. The list is very long and difficult to navigate. Is there a way to…
felixg
  • 173
  • 1
  • 2
  • 7
2
votes
2 answers

Reindex job failing due to being victim of a deadlock, but it is the only process running at 3am..?

I have a reindex job in a maintenance plan which I run on every table in a given database at 3am so it won't interrupt any other work. However it is failing and reporting the reason as being the victim of a deadlock on the tables - how can I work…
Richard
  • 105
  • 1
  • 2
  • 16
2
votes
1 answer

how to see SQL Server cache hit rate?

I am using SQL Server 2008 Enterprise. I will issue a lot of query to SQL Server. And I think SQL Server itself will use some optimization internally, like pre-fetching data into SQL Server internal data cache or accessing frequent requesting data…
George2
  • 1,137
  • 6
  • 22
  • 41
2
votes
2 answers

Integrate Openfire with MS SqlServer

I originally posted this on stackoverflow. Not sure if this belongs on Serverfault. I am reasonably familiar with the guidelines of serverfault vs stackoverflow however, while it is a server question the goal is to get my XMPP development…
pat8719
  • 123
  • 1
  • 8
2
votes
3 answers

How can I speed up SQL Server queries on Amazon EC2?

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that's possible. Can we get quicker disks? Any ideas from anyone?
Jorge Guzman
  • 337
  • 2
  • 4
  • 14
2
votes
1 answer

SQL Server Mirroring - Should Witness server be dedicated to mirroring?

Scenario - SQL Server 2008 R2 Mirrored environment - High Safety synchronous with automated failover. Witness Server is a SQL Server 2008 R2 Express Edition. Question: Can the Witness server be used for other SQL purposes? In particular I am…
DOS
  • 55
  • 4
2
votes
1 answer

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 consultants) in to come and troubleshoot my issue…
Riaan
  • 145
  • 1
  • 1
  • 6
2
votes
2 answers

The concurrent snapshot for publication ‘xx’ is not available because it has not been fully generated or the Log Reader A

I am having all sorts of trouble getting SQL Server (2005) to work properly. When I run the client (SQL Server Express 2005) I get the following error "The concurrent snapshot for publication 'xx' is not available because it has not been fully…
user10104
2
votes
3 answers

MS SQL Server 2005: Fatal error 823

A MS SQL Server - Database that worked fine for the last weeks suddenly threw the following error: System.Data.SqlClient.SqlException: Warning: Fatal error 823 occurred at date / time Note the error and time, and contact your system…
user10082
  • 195
  • 3
  • 5
  • 8
1 2 3
…
99 100