User marc_s

4 votes

Accepted

Restoring database always throwing exception

answered Jan 2, 2012 at 10:54

4 votes

Accepted

Restoring SQL Server database backup file for read-only access - is it possible to skip the ldf file creation?

answered Jan 20, 2012 at 6:01

4 votes

Accepted

Execution Plan in Microsoft SQL Server

answered Aug 2, 2014 at 9:37

4 votes

Accepted

When do you add your foreign keys?

answered Jul 8, 2013 at 14:03

4 votes

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012

answered Apr 15, 2015 at 6:32

4 votes

Accepted

SQL Server database backup(2012) restore on lower version(2008)

answered Sep 29, 2015 at 8:39

3 votes

Accepted

Differentiate SQL Server Express from SQL Server installed in a server

answered Mar 25, 2015 at 8:40

3 votes

Does SQL Server prioritize select and update statements?

answered Jul 23, 2015 at 9:21

3 votes

Does SQL Server place shared locks on scanned records when using REPEATABLE READ

answered Apr 22, 2013 at 15:20

3 votes

Index optimization for table that is truncated every day

answered Sep 11, 2014 at 9:34

3 votes

using IDENTITY column with increment -1

answered Nov 22, 2012 at 13:35

3 votes

how to select * from XML where id=1?

answered Dec 20, 2012 at 10:40

3 votes

Regarding create index and lock word in SQL statement used for SQL Server

answered Oct 15, 2012 at 17:10

3 votes

Sequential GUID or bigint for 'huge' database table PK

answered Dec 28, 2012 at 7:43

3 votes

Accepted

How to downgrade my mdf file from version 661 to 655 or earlier?

answered Jan 4, 2013 at 5:54

2 votes

Back up my ASPNETDB

answered Mar 25, 2013 at 11:38

2 votes

Accepted

Clustered index always better than Non-Clustered index?

answered Feb 1, 2012 at 16:20

2 votes

Accepted

Generally speaking, what pecking order should be used when tuning SQL Server?

answered Aug 9, 2012 at 19:21

2 votes

Help improving SQL Server 2005 query execution time

answered Nov 7, 2009 at 17:17

2 votes

Accepted

Is there a way to view the body / contents of a system function in sql server 2008

answered Feb 10, 2012 at 14:20

2 votes

How can I remove an index scan from a SQL Server SELECT statement?

answered Apr 12, 2012 at 6:59

2 votes

How to restore a database from SQL Server 2000 to SQL Server 2012

answered Sep 10, 2015 at 7:36

2 votes

Access 2010 ODBC Connection to SQL Server 2005

answered Jun 17, 2015 at 17:15

2 votes

Accepted

Constant values in columns

answered Aug 28, 2013 at 14:18

2 votes

Accepted

Subqueries are not allowed in this context. Only scalar expressions are allowed

answered Mar 8, 2014 at 16:59

2 votes

SQL Server 2008 R2 Missing Index

answered Mar 18, 2014 at 21:38

2 votes

Accepted

Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'

answered Aug 3, 2014 at 14:52

1 vote

how to identify table name using a column name if we are not aware about the table name

answered Feb 20, 2015 at 9:09

1 vote

Server side trace to database

answered Apr 19, 2013 at 8:59

0 votes

Accepted

Trigger Gives an Error on Multiple Rows SQL SERVER

answered Jul 6, 2015 at 17:24

Stack Exchange Network

60 Answers

Restoring database always throwing exception

Restoring SQL Server database backup file for read-only access - is it possible to skip the ldf file creation?

Execution Plan in Microsoft SQL Server

When do you add your foreign keys?

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012

SQL Server database backup(2012) restore on lower version(2008)

Differentiate SQL Server Express from SQL Server installed in a server

Does SQL Server prioritize select and update statements?

Does SQL Server place shared locks on scanned records when using REPEATABLE READ

Index optimization for table that is truncated every day

using IDENTITY column with increment -1

how to select * from XML where id=1?

Regarding create index and lock word in SQL statement used for SQL Server

Sequential GUID or bigint for 'huge' database table PK

How to downgrade my mdf file from version 661 to 655 or earlier?

Back up my ASPNETDB

Clustered index always better than Non-Clustered index?

Generally speaking, what pecking order should be used when tuning SQL Server?

Help improving SQL Server 2005 query execution time

Is there a way to view the body / contents of a system function in sql server 2008

How can I remove an index scan from a SQL Server SELECT statement?

How to restore a database from SQL Server 2000 to SQL Server 2012

Access 2010 ODBC Connection to SQL Server 2005

Constant values in columns

Subqueries are not allowed in this context. Only scalar expressions are allowed

SQL Server 2008 R2 Missing Index

Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'

how to identify table name using a column name if we are not aware about the table name

Server side trace to database

Trigger Gives an Error on Multiple Rows SQL SERVER