Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).

learn more… | top users | synonyms (2)

1
vote
0answers
36 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
3
votes
1answer
76 views

Unknown _TransactionIndex table in Azure SQL Database

Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}" It has 1 column, Id, that contains 8 GUIDs. Couldn't find any information about this ...
2
votes
1answer
1k views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

We have a group of users within my company that are running reports directly against our production database. It has gotten to the point where they are hammering it enough to cause performance issues ...
3
votes
1answer
588 views

System table missing in SQL Server 2012

I restored a SQL Server 2000 database to 2005 then to 2012. I am not able to see system tables that existed in SQL Server 2000 now. Why?
1
vote
1answer
743 views

Does MAXDOP affect the number of tempdb data files I should create?

From what I have read, best practices for configuring tempdb includes creating multiple data files. The rule of thumb as I understand it is if you should create the same number of data files as you ...
3
votes
2answers
254 views

How can I most closely monitor this table in production to find why rows are disappearing?

Scenario: We write online banking software and for the time being (due to legacy design decisions) are using Quartz 2.2 right now as a queue system to perform a handful of operatoins long term. ...
1
vote
2answers
102 views

Does RAM taken up Shared Memory connection counts against Max Server Memory?

I have an app that's local to the SQL Server and thus has a Shared Memory connection to it. I was wondering whether the RAM taken by the connection (including data transfers) counts against the max ...
3
votes
3answers
807 views

Is there a way to execute sql statement in sql server based on sql server version?

I would like to create computed index on a table if sql server is 2008 or newer and a simple index if sql server is 2005 or older: -- check for sql server version if (select ...
3
votes
1answer
105 views

Using unique non clustered index with unique clustered index

Would there be any scenario where it would make sense to create a unique non clustered index that includes a column that is contained in a unique clustered index? In other words, if I have a Products ...
2
votes
0answers
21 views

Is there a way to execute sql statement in sql server based on sql server version? [duplicate]

I would like to create computed index on a table if sql server is 2008 or newer and a simple index if sql server is 2005 or older: -- check for sql server version if (select ...
2
votes
1answer
309 views

How to access external DLL's static methods that incorporate output parameters in SQL Server

I know how to load a CLR DLL in SQL Server and access to its static methods which does not incorporate output parameters in their method signatures but what I cannot realize is how I can use methods ...
2
votes
2answers
488 views

Scripting all of available databases to .sql files containing schema+data+users with single command

I have a SQL 2008 Express with 80 databases in it. I want to move these databases completely to another server which is hosting a SQL 2008R2 Enterprise instance. As i'm told it is better to script ...
0
votes
3answers
155 views

how to extract the last inserted value [closed]

i have two table i.e tbl_Contactgroup(id,name) and tble_contactlist(id,name,address,telephoneno,mobileno,groupid) my question is how to retrieve all the contact list value from the tble_contactgroup ...
1
vote
1answer
147 views

Get maximum number with combination of columns [closed]

I have table with columns like AutoID, Number, Name, City, State, Country. What I wanted is the maximum number entered in the “Number” column with the combination of Name, City, State and Country. ...
0
votes
0answers
41 views

unclear SQL Server Issue

I'm attempting to determine root cause for an issue that caused an outage for my company. Essentially the site connections to our database server were timing out after not receiving a response for ...
3
votes
1answer
225 views

Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?

I have an app (windows service) local to the SQL Server box. It calls a sproc on the SQL Server box that returns a ton of data and thus causes ASYNC_NETWORK_IO wait. The database connection from is ...
7
votes
1answer
128 views

TEMPDB Log Files [duplicate]

Do I want to store the tempdb log files on the same drive as my user database log files, the same drive as the tempdb data file, or on a separate drive?
4
votes
1answer
11k views

Query that displays backup information (successful and failed) SQL Server

I have two jobs that backs up two different databases. Job 1 backs up DB1 Job 2 backs up DB2 DB1 fails to back up due to low space on Drive 1 resulting to a Job 1 failure. To fix that issue, I just ...
2
votes
1answer
27 views

Running members of a job subset at different intervals

So I'm wanting to batch a number of stored procedures into one job and would like a number of the procedures to run on a schedule different than that of the main job without setting up a new job for ...
1
vote
1answer
134 views

Size of DB files

I am trying to optimize some settings on a SQL Server that talks to inhouse programs. I have read to size all DB files the same. I have a server with a 20GB data file, with the other 9 files being ...
1
vote
2answers
115 views

Check entry based on entry in another column

Still fairly new to databases and SQL, so bear with me. I'm trying to check whether or not data can be inserted depending on data in another column, create table Table1 (PaymentType varchar(5) ...
4
votes
1answer
2k views

Mapping of multiple server logins to one database user

This seems to be a stupid question but despite some research I was unable to find any information regarding this only (possibly due to using the wrong terminology). Is it possible to log multiple ...
2
votes
2answers
620 views

dbcc shrinkfile not reducing size of log file in sql server 2008

I am shrinking log file of SQL Server 2008 R2 database, but it is not working. I was using this code: ALTER DATABASE [database] SET RECOVERY SIMPLE DBCC SHRINKFILE(DATABASE_LOG, 20) ALTER DATABASE ...
0
votes
2answers
1k views

Delete records from one table using join with another table? [closed]

Delete records from one table using join with another table. Ok, the mission is to delete all employee records if in the title of their department can be found word "sales". It can happen in the real ...
2
votes
1answer
24k views

SQL Server is configured to allow remote connections

I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks Tabular Model SQL Server 2012 From This link I open it with Visual Studio 2010 and ...
1
vote
0answers
54 views

What's Scalar Operator in the plan?

I have a doubt. What means this Scalar Operator in the print below? I've been investigating our database cause we have severals RESOURCE_SEMAPHORE_QUERY_COMPILE . I've seeing a lot of queries using ...
0
votes
0answers
70 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
0
votes
1answer
87 views

Is it possible to have a unique key condition based on another value?

I have a table with the following columns: ID, STRING_VALUE, ENUM_VALUE, CATEGORY_IDENTIFIER I'd like to create a condition that won't allow two identical ENUM_VALUEs, but only if their ID is also ...
2
votes
0answers
107 views

Disabled index still incurs overhead when inserting

I have a 38 million row table that I periodically truncate and refill. I disable the indexes (non-clustered) when I do this. But when I included the Execution Plan I noticed SQL Server 2005 is still ...
0
votes
2answers
1k views

c# Backup sql server database, error Operating system error 5(Access is denied.)

I have been trying to backup an sql server database, and I understand that this error is in regards to drive write protection. I am at the end of my rope with this, as nothing that I have found online ...
1
vote
0answers
97 views

Differential backup job is working but not the Full daily backup

I have a full backup job for my database that runs once daily, I see it posted daily in the folder that it should go to, but when I check the "View History" for this job in SQL Server Agent, there are ...
0
votes
1answer
452 views

What is ag(always on) and fci(failover clustering) databases in sql server 2012? [closed]

I found an article from http://msdn.microsoft.com/en-us/library/ff929171.aspx. But I need simpler and better explanation. Can someone explain to me what they are and when you need it and why you need ...
2
votes
2answers
167 views

Partition : understanding files and file groups

We are trying to partition a large history table. Being new to partitioning, I was trying to understand the concept of files and file groups. File groups can be set up in following three ways : 1. ...
2
votes
1answer
52 views

Can we tell dbcc to ignore subnormal real values?

Currently dbcc DATA_PURITY complains about subnormal real values in some of my columns, such as 7.561407E-42. I would rather keep them in my tables, and ask dbcc to ignore them. I am OK with the ...
0
votes
2answers
379 views

Slow insert - 300+ Million Records

The following query takes over an hour on the table to insert. There are no indexes. There was one which was deleted but still takes an hour after deletion. Any pointers on improving this ...
0
votes
1answer
496 views

How can i deploy ssrs report one server to another server [closed]

When I create a sample ssrs report and I deploy it, I get the following error: The specified report server URL http://localhost/reports could not be found. verify the syntax of the URL and that ...
1
vote
1answer
173 views

How to divide data per client from a single database?

I am looking for best practices to separate data from a single database into multiple client specific databases. Currently my application dumps data for all the customers into single database and I ...
1
vote
1answer
1k views

Best Format to Bulk INSERT/UPDATE Data to SQL SERVER using C# [closed]

Can anyone tell me what is best way to bulk insert/update data to SQL SERVER 2012 using C#? I have an excel file which I am passing as TVP(table value parameter) to a SP. But this is little bit ...
-4
votes
1answer
259 views

Insert text data into image datatype using SQL Server 2000 [closed]

I want to insert text into image datatype and then want to fetch it. And I am using SQL Server 2000. Please help me. Thanks in advance.
2
votes
1answer
147 views

Restoring Differential Backups

Is it possible to restore a differential backup separately? The production server runs the following every sunday DECLARE @Pathname VARCHAR(512) = 'N:\Backup\Dir\DBName_' + (select ...
4
votes
2answers
138 views

Masking or substring data while replicating data

I have a table that has some unencrypted data that needs to be replicated to another server. I want to do : Mask the data with an x except the last 5 characters e.g. xxxx12345 just replicate ...
4
votes
1answer
142 views

SQL Server transaction replication ignores DML which does not change data

I have a transactional replication setup between the two servers and I noticed that if a run a statement similar to this: UPDATE mytable SET mycolumn = mycolumn the replication somehow knows to ...
1
vote
2answers
748 views

Where clause for multiple rows and columns

I have a UDT that receive 2 parameters which is ID and Quality CREATE TYPE [dbo].[ItemUdt] AS TABLE( [ID] [int] NOT NULL, [Quality] [int] NULL ) This UDT will be use as condition to filter records ...
3
votes
1answer
467 views

Delete All Tables With Dates By Date

Refer to this question on SO because it's similar. I'm working on a way to delete a range of dates from all tables with date values in a database (purpose for building mini-devs). I built a script ...
1
vote
1answer
181 views

Database Recovery Model - Simple vs. Full [duplicate]

Does the SIMPLE Recovery Model perform the same transaction logging as FULL Recovery Model? i.e. keep record of each insert/update/delete transaction? If this is the case, then why should FULL ...
2
votes
1answer
68 views

Update various tables depending on survey answer

I've created a survey solution and it work just fine. All questions have multiple options to choose from as answer. What I would like to achieve is when a certain option is saved as an answer the ...
6
votes
2answers
8k views

SQL Server Connectivity Issues

I am getting the below error on occasion. Maybe every 30mins or so. I am not sure how to track what is causing the issue. I think it could be a Network problem as there are disk backups running as ...
4
votes
1answer
10k views

“Database is in transition” Error

Today I was trying to restore a database over an already existing database, I simply right clicked the database in SSMS --> Tasks --> Take Offline so I could restore the database. A small pop up ...
1
vote
0answers
59 views

Migrating from SQL Server to IBM Filent P8

I am Newbie to IBM Filenet P8. I was trying to migrate my sample SQL Server database to IBM Filenet the other day and was stuck right at the beginning. I was just wondering FROM WHERE I SHOULD BEGIN. ...
5
votes
2answers
772 views

Pulling data from identical tables in different databases

I'm dealing with a situation in SQL Server 2008 where each client is setup as their own database, with each database having identical table structures. I have a query that selects from across ~20 ...