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

Row size, indexes and varchar(max)

I have a table with 100m+ rows. We're seeing very bad performance on queries as the data grows. I noticed that the row size is pretty big (10190) and I'm thinking that this is affecting indexes/index performance. the table has a bunch of columns set…
Titan2782
  • 135
  • 7
2
votes
1 answer

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction log, and 'shrinking' the file was still large…
GilesDMiddleton
  • 385
  • 3
  • 9
2
votes
2 answers

Temporary IO boost for an MSSQL server

The company that I am working for is looking at doing a data upgrade on a database to go from one version of an application to the next (Axapta 3 to Ax 2009). This process is very IO intensive and with our current setup will take a few days. We…
holz
  • 187
  • 1
  • 8
2
votes
3 answers

How can I migrate the default four system DB into another partitions?

Why can't I see any detach / attach command in the 4 SQL Server system DB objects? I want to move it into separate partition for each database files and the log files for greater performance. Am I supposed to do that or just leave it on C:\Program…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
2
votes
1 answer

How to reduce the SQL Server transaction log on the fly for production DB?

I'd like to know which is the best solution possible to reduce the SQL Server transaction log in the live production server without downtime ? Database full backup - which should commit transaction log ? (like in Exchange Server ?) executing the…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
2
votes
1 answer

Is there a data dictionary view that allows one to monitor log usage by Process ID?

What (if any) data dictionary views on SQL Server 2005 allow one to monitor log space usage on active queries by Process ID?
ConcernedOfTunbridgeWells
  • 8,820
  • 2
  • 32
  • 52
2
votes
1 answer

sql server windows authentication with IIS

Here is the situation: Where I work (small division of large company), we have a single on site big company owned server running SQL Server. We only have access to this server through windows authentication, and only a single windows account…
bunglestink
  • 123
  • 3
2
votes
2 answers

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional logic to ensure that (1) the server version is 2005 or…
Gnosian
  • 123
  • 4
2
votes
2 answers

SQL Server install on 64 bit Windows 7 installing as 32 bit

I am attempting to install SQL Server 2008 R2 on a new 64 bint Windows workstation. I wish to install the 64 bit version and am using this iso file: en_sql_server_2008_r2_developer_x86_x64_ia64_dvd_522665.iso But it has repeatedly started…
Jim Reineri
  • 21
  • 2
2
votes
1 answer

MSSQL db_datareader to All databases

I have 100 databases in MSSQL 2008 Server. I need to create a read only user to read all these databases. Is there a server wide role: db_datareader I can assigned the user to, so that I don't need to go through each database to add user mapping.…
starchx
  • 533
  • 10
  • 24
2
votes
1 answer

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my options to get just that document back?
TessellatingHeckler
  • 5,726
  • 3
  • 26
  • 44
2
votes
1 answer

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by step instructions to do this? I know I am supposed to…
user75231
  • 23
  • 2
2
votes
2 answers

SQL Server - SSL Encryption - Performance Overheads

I have a security compliance officer that would like me to implement SSL encryption for the data transmission. I have had a look but I can't find any impact studies on this. Does anyone have a rough idea of the performance degradation for adding SSL…
u07ch
  • 73
  • 1
  • 9
2
votes
1 answer

Configure SQL Server 2005 to take advantage of 32GB of RAM on 64-bit version of Windows Server 2003

I'm looking for recommendations/best practices for configuring SQL Server 2005 to take advantage of a recent memory upgrade to 32GB of RAM. The OS version is Windows 2003 64-bit Enterprise Edition. I've read that enabling "Address Windowing…
jamesaharvey
  • 135
  • 4
2
votes
4 answers

How to set up replication on SQL Server 2008

Say you have a production database and a staging database that you want to have replicate on a semi-hourly basis across the internet. The general intent is to have a stand-by backup, but also to have second read-only database for testing. How would…
Matias Nino
  • 1,392
  • 7
  • 25
  • 40
1 2 3
…
99 100