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)

0
votes
0answers
11 views

SQL Server Stored procedures run very slowly after a while

We have an ASP.Net application with a report page that runs several stored procedures. We have a problem with a production system where the report runs so slowly that it times out when the user ...
0
votes
0answers
39 views

Standby Database mirroring/user read only/back up [on hold]

I have a SQL Server 2008 R2 database in standby read only mode which retrieves transaction logs every 15 minutes. I'd like make the data available for read only to other users but am unable to do that ...
2
votes
1answer
34 views

Changing SQL Server installation - Will it bring the server down?

I need to install SSIS on our server, one concern that I have is the database being brought down temporarily since it's mission critical that the server is always up. Does changing the SQL Server ...
0
votes
0answers
5 views

SQL Server to MySQL data transfer using Talend Open Studio - recent performance drop

I have a problem with data transfer speed from SQL Server to MySQL server using Talend Open Studio. Normally my job has been able to transfer about 5000 rows/sec-7000 rows/sec. But lately the job ...
-5
votes
1answer
41 views

String or binary data would be truncated [on hold]

I am sure this has been dealt with,but not able to find exact search on it.My problem goes like this my table structure: i am trying to enter below query insert into test1 select ...
0
votes
3answers
57 views

T-SQL insert value based on identity column

Is it possible to have a table with PK based on Identity columns? Lets say I have a table of customers, two fields are important for our case Id which is PK nvarchar(20) and SequenceId which is int ...
3
votes
2answers
53 views

What happens with statistics when reverting to a database snapshot

Lets say I have a database FOO for which I created a snapshot (named FOO_snap). Now I'll run thousands of queries on this DB. After that I will revert DB to FOO_snap. Will I lose all of the statistics ...
0
votes
0answers
17 views

Query to Find Cluster Nodes for an Instance

I need a way, using T-SQL, to find the nodes available to a SQL instance. I have 3 nodes in a cluster running several instances of SQL Server, each instance is 2012 Standard and so can only be ...
0
votes
0answers
50 views

SQL Server Restore - Unusable .bak file [on hold]

Worst case scenario - the server crashed and the 2014 SQL Server .bak file had to be recovered from the failed disk. The .bak file I have is over 20gb in size but is unusable when trying to restore ...
1
vote
1answer
42 views

SQL Server 2014 .bak file error - The media family on device 'D:\..' is incorrectly formed

Worst case scenario - the server crashed and the 2014 SQL Server .bak file had to be recovered from the failed disk. The .bak file I have is over 20gb in size but is unusable when trying to restore ...
1
vote
0answers
12 views

Cannot Enable DTC For SQL Server to connect to oracle by linked Server

i've SQL server database 2005 and oracle database each one located in separated server . both databases have 1 table with the same structure i need to make sure that when a record added to the sql ...
1
vote
1answer
44 views

Cannot connect to SQL Server from Management Studio (both 2012)

I installed SQL Server 2012 Express. It seems to be running fine. My SQL Server Configuration Manager looks like this: From what I understand it means that my instance is called MSSQLSERVER. ...
0
votes
1answer
20 views

The SQL Server Network Interface library could not deregister the Service Principal Name

After windows patching (windows 2008 R2 , SQL Server 2012 Sp2). I could not start SQL Server Service . I get error 1067 and this from the error log* The SQL Server Network Interface library could not ...
1
vote
1answer
16 views

How can I detect the availability of sp_addextendedproperty on sql server

How can I find out if sp_addextendedproperty is available before trying to use it in a sql script? I gather it's not available on Azure. (I'm working on this bug, if you're interested).
2
votes
0answers
26 views

Output in SQL Profiler has results with Database ID as NULL

I ran profiler to filter out certain applications connecting an environment but the results has application for Database_id "NULL".. Am I missing anything ? Also another question , does all the ...
-1
votes
2answers
65 views

When there is a composite index and those columns are in query, does it use index seek? [on hold]

I have a table staff having columns, name, year,month and date. I have a composite index on year,month and date. If I have a query like below, will it use index seek scan? select * from staff where ...
4
votes
1answer
45 views

Auditing database administrator actions with SQL Server 2014 Standard

We have a requirement to audit database administrator access to customer databases - at a minimum, knowing which customer database they were accessing (and ideally why). Without upgrading to SQL ...
1
vote
0answers
31 views

Performance impact in orders of magnitude with Dynamic SQL [on hold]

This started as a problem debugging a SSRS performance problem where I found reports were timing out when they previously weren't. Finally I traced down the SQL the report server was submitting, and ...
1
vote
0answers
14 views

SQL Server 2005 Cluster Service pack 4 upgrade failure at remote user account

I built SQL Server 2005 ENT Cluster on Windows Server 2008 R2. I need to upgrade it to SQL Server 2005 SP4. However, I get this error at the Remote User Account screen Enter the remote user ...
3
votes
0answers
20 views

Launching SQL Agent Job from stored procedure not on [msdb] database, or, How Necessary is SET TRUSTWORTHY ON?

(With apologies in advance since I've been asked to pick up a project written by someone with more skills than me but who I can no longer ping for questions. If it sounds like I may be using ...
1
vote
0answers
18 views

SQL Agent AD account gets permission denied for ODBC connections in SSIS packages

We have an AD account specifically created for the agent service and when running SSIS packages that connect to databases we get permission denied even though we have granted that account access to ...
1
vote
0answers
20 views

Unable to install SQL named instance as it says RS feature exist, even after dropping it

We are trying to Un-install a named instance from one of our servers. But, don't know why it did not un-installed the reporting services even after proper selection was made during uni-install. ...
-3
votes
0answers
21 views

Cannot connect to database server 2008-r2 [on hold]

I installed SQL Server 2008 r2 but when I try to connect to Db instance with any application, (Sql management, Sharepoint ecc) I got the message that cannot find any Sql database Server. Every SQL ...
-1
votes
0answers
56 views

Table-valued Function XML Reader [on hold]

What makes the Table-valued Function XML Reader so slow? We are using SQL Server 2012 Standard to shred XML columns into tables and find it to be unacceptably slow for our business environment. The ...
1
vote
1answer
22 views

removing sql logins from one server, after migrating to another server, but all the databases were not migra

Here are the details of the production environment: I have 2 serevrs, A1 and A2. I have completely transfered 100 logins from server A1 to A2. Server A1 contains 5 DATABASES. But I moved only 2 ...
-2
votes
1answer
28 views

Retrieve multiple rows from table2 based on single row from table1 in SQL Server [duplicate]

I have two tables and I am using SQL Server. table1 structure is Campiagn_Id Campiagn_Name 1 test1 2 test2 3 test3 and table2 structure is Campign_Id EmalList ...
2
votes
2answers
77 views

How to backup full transaction logs for SQL Server 2008R2

I have a 32GB Database with over 7GB logs (DB name: XYZ). I'd like to copy the DB with all of the logs. I thought that I can simply run: ... ALTER DATABASE XYZ SET RECOVERY FULL; BACKUP DATABASE XYZ ...
1
vote
1answer
25 views

High Page Faults/sec low Page Reads/sec

I currently have Page Faults/sec avergaing 1269 while my Page Reads/sec is averaging 0.3. I am just trying to interpret what this means. I assume I am getting lots of soft page faults in this case ...
0
votes
2answers
32 views

why the optimizer doesn't choose the optimal plan [on hold]

I know, if the statistic is not updatad, it is possible, that the optimizer doesn't choose the optimal execution plan? Does any other reason/reasons exist?
2
votes
2answers
306 views

Getting all databases which a sql logon can connect

I need to know all databases in a SQL Server on which a user can connect. With sys.databases I get all databases and with sys.server_principals or sys.syslogins I get all server logons. But I can't ...
1
vote
1answer
31 views

Advantage of exposing data model to customers using our product

We have a product through which we provide a standard definition to customer's asset data. The problem currently lies in importing customer's data from different types of data sources to our data ...
0
votes
2answers
21 views

Receiving the following error in step failure of an agent job:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x00040EDA Description: "Warning: Null value is ...
1
vote
0answers
21 views

Create Nested XML in a Sql Server Indexed (Materialized) View

This page https://msdn.microsoft.com/en-us/library/ms188276.aspx indicates that if you wanted nested XML (ie an XML Tree) then you need to setup your query like this: SELECT Col1, Col2, ...
0
votes
1answer
16 views

Analyse and report disk usage growth historically

Is it possible to use historic information to show disk usage growth? I haven't keep much in the way of database setup and disk usage information. So I can't say how much disk growth has occurred in ...
-2
votes
0answers
33 views

Repair SQl server 2000 [on hold]

I need to Repair SQL Server 2000 by means of repairing it and not installing it or uninstalling it. Is there a way of repairing the system files without them being removed?
1
vote
1answer
36 views

Another Dynamically alias column question

I might be asking the same question as this, but perhaps if I ask it my way, a different solution may become obvious. I have this: DECLARE @Table1 AS TABLE( Table1ID Int Primary Key ,ColumnName ...
0
votes
1answer
15 views

Switching a partition on a table with one to many relation

There is two main tables in database (SQL Server 2014) table1: ---------------------------------------------- id name datetime image table2: -------------------------------- ...
-2
votes
0answers
28 views

How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB? [on hold]

How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB? Is there any way to copy data from an online database to another online ...
0
votes
1answer
36 views

SQL Service Broker and AlwaysOn Issue

I'm having an issue setting up my current environment using AlwaysOn and SSB and I'll try to explain as best as I can here: Current environment: Server A Server B database x(Pub) ...
2
votes
0answers
16 views

MS SQL Parsing with XPath Performance

I have a UI that allows a user to select certain data points they want to filter the results by. There are things such as location, department etc. Once they have selected all of the options, I ...
1
vote
1answer
122 views

Dropping person while their connection sleeping in SQL Server

I have a C# application that communicates with SQL Server. When I try to drop a user that recently had a connection with SQL Server, it gives me an error that I can't delete them because they have ...
1
vote
1answer
45 views

SSRS Blocking Processes

We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes: [dbo].[CheckSessionLock] [dbo].[WriteLockSession] We are aware that some ...
2
votes
0answers
51 views

Query looks optimal but logical reads is huge

I run the following (really simple) query in SQL Server: SELECT MAX(PK_Field1) FROM MainTable kh WHERE kh.PK_Field1 >= '2014-12-01T00:00:00' AND kh.PK_Field2 = 1572 AND ...
0
votes
0answers
17 views

How to clean DBMIRROR_EVENTS_QUEUE process on broken mirror?

We setup mirror (on SQL Server 2008 R2), but it fails during the setup. After that the mirror was moved on another server. My problem is that it left some process, because on that server I see active ...
1
vote
3answers
33 views

SQLSERVER Use only PRIMARY partition by default

My database has 2 partitions files: PRIMARY, DATABASE_ARCHIVED. A lot of tables have a column "archived". When archived is 1 row is in the DATABASE_ARCHIVED partition. When archived is 0 row is in the ...
2
votes
1answer
38 views

Where is SQLCMD.EXE in SQL Server 2014 LocalDB or how to install it?

On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately? Unfortunately I am not local admin of ...
2
votes
0answers
42 views

I need the reason why we should not install SQL server on the domain controller

I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
0
votes
0answers
25 views

Load Large data set SSIS AWS EBS

We have configuration of SQL 2012 std edition hosted in Amazon cloud that has data disk of 3 TB, Index disk of 3 TB, Log disk of 500 gb all raid 0 stripped. Am trying to load a table that has 8 ...
0
votes
1answer
27 views

Grant Select on some columns for specific user

I have a windows group with 20 people and all 20 people in the group were revoked access for some columns in the table. Now I need to add the select permissions for 2 of the users in this windows ...
1
vote
2answers
47 views

Running a T-SQL job under another user

I cant find my proxy user to "Run as" that user !? I am confused which kind of proxy user is appropriate to run a job with a simple T-SQL command. (I have created a credential and proxy but cant find ...