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
12
votes
5 answers

How to load-balance SQL Server 2008 for high-usage ASP.NET applications?

Imagine that you have a successful web application that uses ASP.NET and IIS 7. It generates many calls to a SQL Server 2008 database, and is expected to be available to the public with 99.9% uptime (downtime of 8 hours, 45 minutes per year). Our…
Yakov-MIK
  • 123
  • 1
  • 1
  • 5
12
votes
2 answers

Find out which database in SQL Server 2005 uses how much RAM

A friend of mine asked me today (trying to calm down an agitated customer of his) how you could find out in SQL Server 2005 which database uses how much memory (in the server's RAM that is) at any given time. Is that possible at all? If so - how?…
marc_s
  • 1,152
  • 4
  • 21
  • 35
12
votes
5 answers

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one by one. Is there any way to point it at a…
aSkywalker
  • 555
  • 3
  • 9
  • 15
12
votes
2 answers

How can a Perfmon "% Processor Time" counter be over 100%?

The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + privilege mode). The book, Sql Server 2008…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
11
votes
5 answers

How to use MSSQL, rebuild all indexes on all tables? MSSQL Server 2008

I have a mssql database, we'll call it: mssqlDB01. I've been tasked with performing defragmentation on all of the tables. This database has a few hundred tables and each table has a range of 1 to 15 indexes per table. Google led me to discover a…
parsecpython
  • 395
  • 2
  • 6
  • 16
11
votes
2 answers

Should I encrypt OS disk with BitLocker for HIPAA compliance

I am looking into hosting a HIPAA compliant web application on Azure VM's. For the database, right now I am leaning towards using a VM with SQL 2014 Standard Edition. Since TDE is not available with Standard Edition, I am going to just use…
blizz
  • 1,134
  • 1
  • 26
  • 47
11
votes
3 answers

In SQL Server, when should you split your PRIMARY Data FileGroup into secondary data files?

Our database currently only has one FileGroup, PRIMARY, which contains roughly 8GB of data (table rows, indexes, full-text catalog). When is a good time to split this into secondary data files? What are some criteria that I should be aware of?
Jarrod Dixon
  • 685
  • 2
  • 13
  • 23
11
votes
1 answer

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything in place in this directory. Is there any reference…
the-wabbit
  • 40,737
  • 13
  • 111
  • 174
11
votes
4 answers

How can I backup an SQL Server database using Windows Server Backup?

Apparently Windows Server Backup has some support for backup of SQL Server databases: Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications like Microsoft® SQL Server® to protect application…
Heinzi
  • 2,217
  • 5
  • 32
  • 52
11
votes
5 answers

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some third party data providers, provide us all the…
kishore
  • 872
  • 3
  • 13
  • 28
11
votes
2 answers

SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?

I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide.... What are your strategies / best practices when it comes to dealing with a reasonably sized SQL Server…
marc_s
  • 1,152
  • 4
  • 21
  • 35
11
votes
6 answers

How does changing Windows SID affect SQL Server?

Our Windows admins have identified an issue with the way that they clone Windows servers. Apparently some of the cloned servers end up with the same SID at the OS level. I hear Microsoft doesn't support servers that have duplicate SIDs. Therefore,…
Ra Osolage
  • 173
  • 2
  • 2
  • 10
11
votes
1 answer

Finding out who has modified a Stored Procedure on SQL Server?

Looks like somebody has logged in and modified a Stored Procedure on our SQL Server database. Is there a way to find out the credentials of the person that has done that?
Behrang
  • 289
  • 2
  • 3
  • 10
11
votes
4 answers

SQL Server setup check list

What are the things I have to consider when I have to install SQL Server (2005/2008) on a new server? Storage setup TempDB Security What are some common mistakes made in that process?
splattne
  • 28,508
  • 20
  • 98
  • 148
11
votes
2 answers

gMSA account authentication failure during password rotation

When our gMSA accounts are automatically rotated, we see login failures for around 1-10 minutes. This is particularly apparent for gMSA client accounts that connect to MS SQL server, but I think it happens for other gMSA accounts as well. MS SQL…
devons
  • 153
  • 1
  • 9
1 2 3
…
99 100