All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag like sql-server-2016 if that is relevant to the question.

learn more… | top users | synonyms (2)

1
vote
3answers
4k views

SQL Server Database grew too much too fast

I have an issue with one database. The issue is as follows: The database is being running on SQL Server 2000 Standard for the last 6 years in Full Recovery mode. In the beginning of this summer the ...
1
vote
2answers
281 views

How do I track why my SQL Azure occupied space pulsates?

This is inspired by this StackOverflow question. I have this code: SELECT CONVERT(INT, SUM(reserved_page_count) * 8 / 1024) FROM sys.dm_db_partition_stats for detecting database space consumption ...
2
votes
3answers
1k views

Getting the information that exists in “Job properties -> Notifications” page?

I use SQL Server 2008 R2 and I need get some properties from the msdb database. I need a query to get information that exists in the Job properties -> Notifications page. In which table I can ...
1
vote
2answers
3k views

How do I unload data from a database to a flat file?

I am aware of the concept of bulk insert wherein I load data from a flat file to a database. Now I want to unload data from a table to a flat file, i.e. I want to export data in a table to a flat ...
1
vote
1answer
312 views

who i can join msdb.dbo.sysalerts table with msdb.dbo.sysoperators table?

i use sql server 2008 r2. and i want create script of my jobs. i need find all object that exist in one job. To achieve this goal, i get all operators whit this query Select O.* From msdb.dbo....
2
votes
1answer
203 views

How can I connect to a database after its disk has come back online?

I have problems with database after reconnecting a hard disk: .Net application works with database. Disconnect hard disk with physical files. Make any request to the database (of course we will have ...
4
votes
2answers
15k views

How do I view a Microsoft SQL Server Compact Database

I have installed SQL Server 2012 Enterprise Edition. I can use SQL Server Data Tools to add databases and tables and query tables etc. Next, I used Visual Studio to try out a tutorial on creating a ...
4
votes
2answers
230 views

Moving a database to a new server

My database server is being decommissioned at work. We have a new database server to take its place. Both servers have the same operating system and SQL Server 2008. I need to move all my databases ...
-3
votes
2answers
1k views

How to improve TempDb on RAMDisk showing performance on par with physical hard drive [closed]

Given 2 SQL Server Instances where the second instance is configured with a RAMDisk for tempdb and the following test case. -- Create source data select top(1000000) * /* ~10 cols */ into #t1 from ...
11
votes
2answers
8k views

How to optimise T-SQL query using Execution Plan

I have a SQL query that I have spent the past two days trying to optimise using trial-and-error and the execution plan, but to no avail. Please forgive me for doing this but I will post the entire ...
-2
votes
1answer
3k views

Importing delimited files into SQL server [closed]

I am trying to import a large file into SQL server that is | delimited. I know basically nothing about the data, I just want to get it imported. When I go to Database->tasks->import I use the ...
2
votes
3answers
5k views

Import .bak file in Microsoft SQL Server 2008 Service Pack 3 [duplicate]

I have a backup of my database as a TestDatabase.bak file but I am unable to restore it. When I try to restore I receive the following error message in SSMS: RESTORE could not start database '...
2
votes
1answer
65 views

Make database use more than one file

I have to following problem: since my database runs out of memory in a few days, I am looking for a way how to make the database use more than one file. I would like to store upcoming data in another ...
0
votes
1answer
245 views

Describe Interim Table and Basic Concept behind it?

Hy Everyone... Can anyone describe me what is interim table in sql Server 2008? what is the basic concept and structure behind it. thanks in advance.
11
votes
3answers
11k views

general memory requirements for sql server 2008 r2

I'm not experienced with DBA work, but I'm trying to make a case for requesting additional resources for our sql server and was hoping I could get some smart folks to provide a rough rough estimate of ...
10
votes
5answers
62k views

Why is SQL Server consuming more server memory?

Sqlserver is consuming 87.5 % of my server Ram. This recently causes alot of performance bottleneck such as slowness.I Research on this issue. One common solution i could find on the internet is to ...
1
vote
0answers
180 views

Inline TVF with One Row Result

I have several times converted scalar functions into inline tvf. Usually this is the basic design I used in inline tvf: CREATE FUNCTION TVF(@ID INT) RETURNS TABLE AS RETURN( WITH BASE AS( ...
8
votes
3answers
6k views

Does disconnecting the network stop a query?

I recently executed an update query against 100,000 records. I realized I'd made a mistake while the query was running and quickly unplugged the network cable. Does the update query stop ...
6
votes
3answers
10k views

Connect to SQL Server 2012 from an Windows XP client

We have an SQL Server 2012 Standard database, to connect to it we use SQL Server 2008 Management Studio (since 2012 SSMS is not supported on Windows XP). The problem is that SQL Server 2008 gives all ...
4
votes
3answers
6k views

Select rows after a specific ID

I have the following query, it chooses from a news articles table. Due to multiple sorting factors, I cannot locate the next page of date. The parameter I have is the last ID in the query result set, ...
5
votes
1answer
582 views

Changing autogrow settings with database mirroring

Recently I changed the Autogrow settings for some of the databases on our SQL Server 2008 R2 server. These are involved in a database mirroring configuration, with the principal on SERVER1 and the ...
5
votes
1answer
117 views

Transfer logins to another server

I moved a database from SQL Server 2005 to SQL Server 2012. Is there any way of restoring all the logins on the new server?
4
votes
2answers
151 views

SQL Server logs in Gmail

First off, I'm using SQL Server 2008 R2. When I set up my maintenance plan and got to the "Select Report Options" step, I selected to email the report to the Operator I already have set up. This ...
2
votes
1answer
4k views

Reporting Services TempDB keeps going into restoring mode

I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that ReportServerTempDB keeps on going into Restoring... mode. I ...
3
votes
4answers
6k views

Can I force a user to use WITH NOLOCK?

Can I force a user's queries to always run with the hint NOLOCK? e.g. they type select * from customer But what is executed on the server is select * from customer with (nolock) This question is ...
7
votes
3answers
1k views

How to determine Windows Server start time using T-SQL

I am looking for a way to find out when the Windows Server was last started using only t-sql commands. I am trying to stay within the default security configurations (i.e. I don't want to enable ...
3
votes
1answer
4k views

ORDER BY items must appear in the select list […]

Using Microsoft SQL Server 2008, I get the following error. Msg 104, Level 16, State 1, Line 43 ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or ...
0
votes
0answers
83 views

How do I get let SQL Server 2005 know that I changed host name in Amazon AWS server?

I am using an Amazon AWS SQL Server 2008 R2 server for dev purposes. In order to follow a new naming convention, we changed the name of the host. I then tried to let SQL Server know about this ...
1
vote
1answer
25 views

New instance with same @@VERSION as existing instances

I have a SQL Server 2008 R2 server with several instances installed. Is there a way to add a new instance and have it be to the same build as the existing (and updated / patched) instances?
16
votes
5answers
19k views

.bak file not visible in any directory in SSMS

I have a .bak file created today by someone else, manually created through SSMS 2008 R2. I'm trying to manually restore the database, unfortunately the file isn't appearing when I go to browse it. I ...
11
votes
2answers
1k views

DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition

TL;DR: I've got an unfixable corruption in an indexed view. Here the details: Running DBCC CHECKDB([DbName]) WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS on one of my ...
10
votes
2answers
3k views

When does sp_executesql refresh the query plan?

You'll have to forgive my naivety as I'm not a DBA but my understanding is that over time the statistics of a database change and a stored procedure must be recompiled to keep the query plan up to ...
1
vote
1answer
65 views

How to distinguish the current operation is done from system or from sql server management studio

We want to record who insert or update a table, so we add "CreatedBy" and "ModifiedBy" columns. When the data is changed through the application, we can easily get the person. But when someone uses ...
6
votes
2answers
1k views

SQL Server Tuning a table for massive inserts

I'm trying to solve a performance issue and I need advice. I have a table, which about twice a day has a massive surge of inserts coming in, and exactly at the same time everybody is trying to read ...
0
votes
2answers
301 views

Full text catalog does not allow me to hit on singular forms

I have created a full text catalog for a column under database name -> "Storage" -> Full Text Catalogs. It is accent sensitive and "default catalog" is set to false. The language for the column "...
3
votes
3answers
17k views

overwrite table with data from another table - SQL

Our users want to refresh a QA database from production but want two tables (lets call them T1 and T2) to retain the original QA data. So I copied two tables from QA (DB1) to a temp QA database (DB2). ...
0
votes
1answer
45 views

Apply profiler template to saved log

I need to check for deadlocks in my customer's system. He provided me with unfiltered logs. Can I filter them after running the trace somehow? (I don't have direct access to his server) It seems ...
5
votes
2answers
8k views

Importing a large column (8000 chars) from Excel using SSIS

I'm trying to set up a regular import of an excel spreadsheet that we get from a vendor. I'm using SQL 2008 R2 SSIS to import it into a table. The problem connection manager is an OLE DB connection ...
1
vote
2answers
276 views

How to avoid timeouts during big DML operations

I have a big insert script I need to run. Its about 55,000 records and 160 columns. The script is already created and I can't create it again. The problem I have is that this runs for about 4 hours ...
12
votes
2answers
13k views

Need to understand parallel query execution error

Today we experienced a degradation in performance on our production sql server. Durring the time this occurred we logged several "The query processor could not start the necessary thread resources ...
3
votes
1answer
4k views

Cannot rename the table because it is published for replication

I need to rename some tables in my DB - SQL Server 2005, with this: EXEC sp_rename 'dbo.TableName', 'Tmp_TableName', 'OBJECT' but I can't do this - I get this exception - Cannot rename the ...
3
votes
1answer
490 views

Is the Service Broker good for publishing data between servers?

I'm trying to find a better solution when publishing data to a remote table. So we have Server A and Server B. Server A holds a master table which should be replicated to Server B. Currently, we ...
2
votes
0answers
283 views

always on availability group with different speed disks

I'm looking to set up SQL Server 2012 installation with an Always On Availability Group, where the 'passive' replica will be hosted at another site on the WAN and using synchronous data commit - the ...
4
votes
6answers
9k views

Cannot remove unused filegroups

I wanted to remove some unused filegroups/files in a SQL Server Database but am stuck because SQL Server thinks the filegroups/files are still in use. Some background: We had some partioned tables ...
0
votes
1answer
677 views

Full text query slow on first run [closed]

I have SQL Server database which has size of 65GB and 6 million rows. We have essays in tables and the average size of an essay is 450 words. When I run a query for the first time, it takes 3-10 ...
3
votes
1answer
578 views

Splitting different parts of a string

I have an SQL Server database where there is a cell with a delimiter (\) separated string. An example of this string would be: category_path ============= RootCategory\Middle Category\Child Category\...
6
votes
1answer
13k views

SQL Server Maximum and Minimum memory configuration

What are the correct settings for min-memory and max-memory in this use case? The server has 8GB ram, dual Intel Xeon processors, running Windows Server 2008 R2 / Sql Server 2008 Standard Edition. It'...
2
votes
0answers
417 views

A Tool to Manage Tracking Query Performance Improvements [duplicate]

I'm building a BI system on SQL Server 2012. I have a test set of data with some tens of millions of rows. Currently many functions and stored procedures are unacceptably slow. I'm looking for a tool ...
1
vote
3answers
2k views

How can I drop a stored procedure whose name is in a variable?

Given a variable that contains a stored procedure name: DECLARE @stored_procedure_name sysname; SET @stored_procedure_name = 'some_stored_procedure_name'; How can I drop the stored procedure?
3
votes
1answer
7k views

Why is my Amazon RDS instance so slow?

I currently run a Windows Server with SQL Server Express. I'd like follow best practice and separate the application from the database, so I've created an RDS instance and exported my database. But......