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

SQL Maintenance Cleanup Task 'Success' But not deleting files

I have a maintenance plan setup for a databases on a server. As part of the backup is a Maintenance Cleanup Task. SQL Version 2008 The task that 'succeeds' is setup as: Delete backup files Correct folder (same address as the backup task) File…
Seph
  • 185
  • 2
  • 2
  • 5
2
votes
1 answer

SQL Server synchronization failed

I'm getting the error message below when trying to synchronize a SQL compact database (SQL CE 2.0) to a SQL Server 2005 database. I have double and triple checked permissions, reconfigured IIS multiple times, and I've run Process Monitor to see…
notandy
  • 564
  • 1
  • 5
  • 19
2
votes
2 answers

How do I monitor Microsoft SQL cluster availability in Nagios?

We run a system designed to integrate with Microsoft SQL Server, in a clustered setup. Currently we have both database nodes monitored under Nagios, and everything's fine except the database host check: check_tcp -H $HOSTADDRESS$ -p 1433 Probably,…
jldugger
  • 14,342
  • 20
  • 77
  • 129
2
votes
3 answers

Moving database from SQL Server 2005 to Oracle DB

What would be the easiest way to migrate a database that I have in SQL Server 2005 to Oracle? I have around 6 tables each with a large amount of data in it.
EquinoX
  • 367
  • 3
  • 11
  • 27
2
votes
4 answers

Microsoft SQL server backup : restoring data to one table

Is there an easier way to restore data to single table in an MSSQL server, rather taking down the database and restoring the entire database?
phill
  • 327
  • 3
  • 13
  • 20
2
votes
1 answer

MSSQL 2008 - new tables do not show columns when using intelliSense

After creating new tables in MSSQL 2008, the intellisense list never displays updated tables or table names and columns. (Am using server management studio when this happens). Does anyone know how to refresh this information in sql 2008 without…
IanN
  • 313
  • 1
  • 6
2
votes
3 answers

sql server management console doesn't work with multi-byte characters

I'm trying to work out how to use SQL server management studio properly with multi-byte unicode characters. even something as simple as: select N'动漫' just returns square boxes in the result pane. I know the underlying database is set up correctly…
Andy
  • 499
  • 1
  • 5
  • 10
2
votes
5 answers

Portable SQL Server

I need to install SQL Server, however I have a BIG problem with it. I remember when I tried to install it I got error with MSXML and it was not installed because of MSXML and some other component. Is there any portable version of SQL Server?
10.
  • 121
  • 1
  • 1
  • 3
2
votes
2 answers

MSSQL 2005 Trigger Behavior

I'm wondering how a trigger on a table behaves in SQL Server in response to an uncommitted transaction affecting that table if the trigger is specified to fire AFTER UPDATE. If the transaction hasn't been committed on the UPDATE to the table, will…
Aushin
  • 175
  • 6
2
votes
5 answers

SQL Server 2005 Disk Configuration: Single RAID 1+0 or multiple RAID 1+0s?

Assuming that the workload for the SQL Server is just a normal OLTP database, and that there are a total of 20 disks available, which configuration would make more sense? A single RAID 1+0, containing all 20 disks. This physical volume would…
2
votes
1 answer

SQL Server 2008 Partitioned Table and Parallelism

My company is moving to SQL Server 2008 R2. We have a table with tons of archive data. Majority of the queries that uses this table employs DateTime value in the where statement. For example: Query 1 SELECT COUNT(*) FROM TableA WHERE …
2
votes
1 answer

What is the best way to determine what's locking up SQL Server using a query?

Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so far: SELECT SPID = s.spid , …
Aplato
  • 23
  • 1
  • 4
2
votes
1 answer

Query Performance Degrades with High Number of Logical Reads

I'm using Confio Ignite8 to derive this information, and monitor waits. I have one query that runs frequently, and I notice that on some days there is an extremely high number of logical reads incurred, +300,000,000 for 91,000 executions. On a good…
2
votes
1 answer

Migrating data from SQL Server 2000 to SQL Server 2005

I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has different columns. This is one time activity. After…
Kashif
  • 193
  • 2
  • 11
2
votes
1 answer

Dump Microsoft SQL Server database to an SQL script

Possible Duplicate: Dump Microsoft SQL Server database to an SQL script Is there any way to export a Microsoft SQL Server database to an sql script? I'm looking for something which behaves similarly to mysqldump, taking a database name, and…