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)

2
votes
1answer
79 views

How to output more than 4000 characters in sqlcmd

I've made a stored procedure restoredatabase that returns code to restore a database. The output script looks like this: restore database [DB] from disk='F:\FULL1.bak' with norecovery restore ...
6
votes
2answers
294 views

Unexpected Implicit conversion in a procedure

I have a procedure like this (simplified): CREATE PROCEDURE test @userName VARCHAR(64) SELECT * FROM member M INNER JOIN order O ON M.MemberId=O.MemberId WHERE M.Username = @userName There is a ...
2
votes
1answer
25 views

Select multiple rows based on date interval from two fields

I am still learning SQL and I would like to do something that I dont know if it is possible. I have a table in which each record has a initial date and a final date. I would like to create I query ...
-1
votes
1answer
54 views

Replace SQL Server with another DBMS [closed]

In our current application (C#, ASP.NET) we are using SQL Server database. My superiors are planning to move from SQL Server to another database considering the amount of investment involved with ever ...
-6
votes
1answer
64 views

SQL Server Query Question

I get the following errors when I execute the below query Error messages: Msg 207, Level 16, State 1, Line 10 Invalid column name 'Name'. Msg 207, Level 16, State 1, Line 10 Invalid ...
1
vote
1answer
76 views

SSMS Database Node Refresh causes Restore to Fail

I have confirmed via testing that clicking on the refresh icon (one or more times) for the database node of a SQL Server instance being observed in SQL Server Management Studio (SSMS 2012) causes my ...
1
vote
0answers
59 views

Multiple SQL Server Indexes, which ones to keep?

I am looking at my database that several people have worked on. A particular table is responding slowly when queried on a certain join. I notice some of the parameters of the join are not indexed. ...
1
vote
1answer
75 views

Shorthand for on primary key?

Is there a shorthand for merging rows based on the primary key? For example: MERGE INTO [MyDatabase].[MySchema].[MyTable] AS target USING [MyLinkedServer].[MyDatabase].[MySchema].[MyTable] AS source ...
0
votes
1answer
18 views

SQL queries failing, Memory not releasing

I have a SQL Server 2008 R2 with 8GB of ram and SQL Server is limited to 6GB. It seems to not be releasing the memory its used, and at some point future queries begin to fail. This is a mirrored ...
3
votes
1answer
89 views

Unable to start SQL Server Browser service in Sql server 2005 [closed]

we are unable to start the SQL browser service on one of our machine with below error: I believe this to be the reason, why we could not connect to the instance with below error: I tried ...
-4
votes
0answers
38 views

Oracle to SQL Server query conversion. Getting “Argument data type int is invalid for argument 1 of substring function.” error

I tried to convert a SQL query from Oracle to SQL Server. Oracle query: SELECT T@o_NUMBER(T@o_CHAR(GETDATE(),'HH24')), T@o_NUMBER(SUBSTR(T@o_NUMBER(T@o_CHAR(sysdate,'MI'))/15+1,0,1)) INTO ...
2
votes
1answer
65 views

The operating system returned error 665(The requested operation could not be completed due to a file system limitation) on SQL Server 2014

Have a SQL Server 2014 instance running on Windows 2012 R2 that was running Ola Hallengren's DB integrity script. This is the error that resulted: The operating system returned error 665(The ...
2
votes
2answers
95 views

Restoring database between different version of SQL Server (SoftwareVersionBuild)

i have a question about restoring database from newer version of SQL Server to older, when version differs only in SoftwareVersionBuild. I know that's not possible to restore database from SQL Server ...
0
votes
1answer
37 views

Is it possible to get a list of procedures create with WITH EXECUTE?

Is it possible to get a list of stored procedures create with WITH EXECUTE in SQL Server? If so how? I tried looking at the sys.procedures table but they all have the principal set to null and I know ...
1
vote
1answer
70 views

DROP LOGIN fails on SQL Server 2014

We have a database with an owner 'dbowner'. Our install procedure drops the login for user 'dbowner' and creates it again. On any other version of SQL Server the following SQL query succeeds: USE ...
1
vote
1answer
52 views

Are scripts like sp_BlitzIndex and the others accurate on restored backups?

I am a developer trying to get a better grasp of things. I am wondering if using the scripts from BrentOzar.com will work on restored backups? For example if I have the DBA give a backup of ...
0
votes
1answer
32 views

How should I store changes to items in the database?

I have items (tracked with itemid) that have attributes assigned to them (field1,field1 for example). At any given time, field1=val1, field2=val1, ..., fieldn=valn where val1,val1,...,valn = 1..100. ...
0
votes
0answers
46 views

Instance consuming large amount of disk space

I have an environment that is Microsoft Server 2000 and Microsoft SQL Server 2000. The database has a file size of 112 GB. The total size of the disk is 122GB. For some reason in less than a few ...
0
votes
1answer
74 views

Is it possible to simplify a query with multiple joins to the same table?

I have a rather large query which takes longer to run than I would like because of 17 LEFT JOINs on the same table. I've done some searching, but haven't found anything that is really similar to my ...
0
votes
1answer
36 views

copy table with all constraint

how I would copy a table with all constraints? I run select * into myNewTable from baseTable where 1=0 This copy a table but no with constraints
0
votes
1answer
40 views

“Incorrect Syntax near S” in Stored Procedure [closed]

I'm creating a SQL Server stored procedure and getting error Incorrect Syntax near S I'm not able to find the exact reason of the error. CREATE PROCEDURE RPT_IVR_CALL_SUMMARY ...
1
vote
0answers
51 views

SQL server deadlock graph explained

I am testing a scenario or recurrent request that ends up in executing the following store procedure simultaneously ALTER PROCEDURE [dbo].[clear_class]( @classID [int]) AS BEGIN DELETE FROM ...
0
votes
0answers
36 views

Find and return items based on matching strings across 17 tables

I must start by saying that I am at best a sql novice. I am doing some data analysis and consolidation for my company and need to find if items match across any of the tables. The info in the tables ...
-2
votes
0answers
20 views

Recover deleted data for SQL Server database [duplicate]

On 03/19 one user had deleted the data from 3 tables from one of the databases that we have. Now we have the full backup of that database each day. What we want to do is to restore the deleted data ...
1
vote
1answer
22 views

Recover deleted data SQL Server

On 03/19 one user had deleted the data from 3 tables from one of the databases that we have. Now we have the full backup of that database each day. What we want to do is to restore the deleted data ...
3
votes
1answer
126 views

Over 99 million records with geography column & spatial index - VERY VERY VERY slow queries!

I’ve been working with SQL Server for a long time but have only recently encountered the need to work with spatial data. I have come into an environment that uses it pretty heavily and my first real ...
7
votes
1answer
148 views

How does SQL Server's optimizer estimate the number of rows in a joined table?

I am running this query in the AdventureWorks2012 database: SELECT s.SalesOrderID, d.CarrierTrackingNumber, d.ProductID, d.OrderQty FROM Sales.SalesOrderHeader s JOIN ...
0
votes
1answer
29 views

Data mismatch on Subscriber Database in SQL server transactional replication

We have Transactional replication set up between an OLTP Database server 'A' and reporting DB server 'B', where the Data from OLTP DB(Size 400 GB) "AR" is getting replicated on the server B as ...
0
votes
0answers
44 views

DatabaseMail didn't start when an email is queued

This is about SQL Server 2005. I have configured SQL agent jobs to send an email when it failed. So far I have received email reliably. However, I have an weird problem where an email would get ...
0
votes
1answer
47 views

Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?

For context - SQL 2014 EE, we're doing tran log backups from our main production box and restoring to a R/O instance. The log is usually around 50GB. So I'm familiar with the structure of SQL Server ...
0
votes
1answer
17 views

How do I get the corresponding row for a RowsetID?

We're faced with the following error when a query runs against a partitioned table with Read-Only file groups: The index "ix_my_index" for table "dbo.my_table" (RowsetId 72057600379912192) resides ...
1
vote
1answer
31 views

Foreign Data Wrappers & Windows Authentication

I been trying to get data from a SQL Server to use it on a PostgreSQL database. After a previous question I got into use FOREIGN DATA WRAPPERS, first I try with tds_fdw but after a successfull install ...
1
vote
0answers
76 views

Strange IO stall values in sys.dm_io_virtual_file_stats

Values for io_stall_read_ms seems to be higher than actual run time for query. The setup: create database filestats; use filestats; create table t1_primary( a int identity ,b int ,c ...
0
votes
1answer
22 views

detect what columns to select depending on a column value of the same table

I am trying to build a query which returns different columns of the table depending on a column of the same table. Say, a column represents a type of item. This is my temporary solution, in which I ...
1
vote
0answers
53 views

Why does an SSIS package fail when executed from the IS Catalog?

When executed via the SQL Server Agent under the same user context, is there any reason a package would successfully run when using the file system (i.e. DTExec.exe), but fail to execute when launched ...
0
votes
0answers
12 views

How do I determine if membership in a DB fixed role is by direct user memership or through membership in a custom DB role?

I'm cataloging memberships of DB users in the various fixed DB roles so that I can create custom roles by business function and grant permissions through these custom roles only. When using SSMS to ...
1
vote
1answer
45 views

Rebuild vs Reorganize [duplicate]

I currently have a maintenance plan that is reorganizing indexes everyday and I would like to know if you reorganize an index everyday would you ever need to rebuild the index? If so, why?
0
votes
0answers
59 views

I cannot restore a SQL Server database in a new location

Made backup of the database on server c, SQL Server 2012, moved on to the local computer with SQL Server 2012, restore database does not work. When checking the validity of the file on the server ...
0
votes
1answer
135 views

SQL Query - Possibly the most poorly written query in the history of mankind

Having a major headache trying to tune this query and looking for help, a programmer who had no idea what they were doing messed with this query and it is currently being used in production and it ...
0
votes
1answer
41 views

Creating a constraint

I created a report that records entries from a table which has 4 columns 1 Shipper ID 2 SHipper Reference 3 loading 4 Completion My primary keys are columns 1 and 2 there are no foriegn keys, ...
2
votes
0answers
60 views

Multi-Instance Windows Failover Cluster - Min / Max Memory Allocation Dilemma

We run numerous 2 node SQL Server 2008 R2 Failover Clusters in Windows Server 2008 R2 on a VMWare eSXi virtual platform. Each cluster hosts 3-4 SQL instances with varying degrees of memory ...
1
vote
2answers
109 views

How to re-declare T-SQL variables if it already exist?

Background: I'm building a SQL command to be executed on the server which involves a lot of accessing store procedure and declaring variables which are used as input to other stored procedures. This ...
1
vote
1answer
72 views

SQL Server to XML files alternatives

I am currently looking for an alternative to writing a large, complex XML file based on a known specification. Currently the file is written in t-sql as a stored procedure. The output is in a results ...
1
vote
1answer
47 views

upgrade of 24/7 OLTP [closed]

Our primary db is a 24/7 OLTP db on SQL2008 R2 on an Active / Passive Windows cluster. It is a VLDB and uses almost all SQL functionality (including Service Broker and Mirroring), acts a Publisher and ...
1
vote
1answer
56 views

Execution Plan : Table Insert Cost 90% vs Clustured Index Insert Cost 86% [duplicate]

Situation : We have table It has millions of records. Table has 1 Clustured Index and 1 Non Clustured Index. It was found that Clustured Index is not used by any of SQL Query. But Insert Execution ...
0
votes
0answers
22 views

Why do the databases go into the “recovery pending” state when the share permissions are changed from “everyone”?

Yesterday we had a power failure and after the power was back our financial databases on the SQL did fall into "Recovery Pending" state. After struggling a while I've remembered that a few days ago we ...
0
votes
0answers
19 views

Procedure or function 'sp_InsertImages' expects parameter '@Img_path', which was not supplied [migrated]

i have passed img_path in my code nd procedure but it show me error please anyone help me. my procedure is : create proc sp_InsertImages ( @Img_path nvarchar(max), @product_id numeric(18,0), ...
-1
votes
2answers
44 views

How to run multiple select statements in Data flow task in SSIS [closed]

I am migrating data from one database to another database using SSIS package and i need to write multiple select statements for same table depending on conditions as mentioned below. Actual Queries i ...
1
vote
0answers
30 views

Rolling back a SQL Server 2008R2 Database stored in SQL Server Express [closed]

We had an accident where a bunch of data was deleted from one of our products. The product removed a bunch of lines from various tables about 12 hours ago. There is no good backup and I try to ...
0
votes
0answers
29 views

The Local Security Authority cannot be contacted

I am not very expert with SQL Server but I have to use to for one of my application development. Issue is that when I open the PC in morning to start my work, my application couldn’t make connection ...