User marc_s

151 votes

Accepted

How to query last restore date in SQL Server?

answered Jan 28, 2013 at 9:53

130 votes

Accepted

How to force drop database in SQL Server 2008

answered Feb 6, 2013 at 16:51

18 votes

Get Stored Procedure Result Column Types

answered Apr 15, 2016 at 7:35

17 votes

Error on SQL Server 2000 backup (.bak file) restored on SQL Server 2012

answered Nov 22, 2012 at 11:03

17 votes

Accepted

How to change the instance name of SQL Server Express 2008?

answered Feb 7, 2010 at 16:16

14 votes

Accepted

What is the difference between SQLEXPRESS and MSSQLSERVER?

answered Aug 3, 2012 at 5:44

14 votes

Still wrong to start the name of a user stored procedure with sp_?

answered Oct 3, 2012 at 14:10

14 votes

Accepted

Max connections SQL Server Express could have?

answered Dec 29, 2012 at 10:23

14 votes

Remove collation from all database columns

answered May 13, 2013 at 4:39

13 votes

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

answered Feb 23, 2011 at 17:50

12 votes

Accepted

At What Point Does Having an Index Become Efficient

answered Jan 17, 2013 at 15:12

11 votes

Accepted

How to avoid index scans in SQL Server 2005?

answered Oct 24, 2011 at 21:16

11 votes

Accepted

Deny access to information schema in SQL Server

answered Oct 9, 2012 at 5:28

10 votes

Accepted

Need for reaching data through clustered index with a non-clustered index

answered Sep 1, 2012 at 12:37

9 votes

Accepted

Error in restore database

answered Dec 19, 2012 at 5:50

9 votes

Accepted

Column name or number of supplied values does not match table definition error

answered Nov 29, 2014 at 10:06

8 votes

Accepted

PK Fragmentation on INT IDENTITY column

answered Feb 13, 2013 at 21:43

8 votes

Accepted

Performance impact of having gaps in Identity Column in SQL Server 2005

answered Jan 27, 2012 at 6:06

7 votes

Accepted

Performance of SQL Server indexing

answered Aug 17, 2011 at 11:24

7 votes

How to create unique index for month and year column?

answered Jan 4, 2013 at 12:26

6 votes

Accepted

difference between having many non clustered index with single columns and with combination of many columns

answered Jul 14, 2012 at 7:10

6 votes

Accepted

Differences between estimated and actual execution plans

answered Jul 13, 2012 at 15:49

6 votes

SQL table design for primary keys (best practice)

answered Nov 30, 2011 at 15:54

6 votes

When is a full table scan better than index scan?

answered Dec 9, 2010 at 18:20

5 votes

SQL Server Primary key / clustered index design decision

answered Feb 22, 2012 at 12:15

5 votes

Accepted

Do you set an index on JOIN clauses or where clauses, or both?

answered Jul 11, 2012 at 16:03

4 votes

Accepted

Stored procedures and network congestion

answered Oct 27, 2012 at 14:34

4 votes

Attaching MDF without LDF

answered Feb 4, 2012 at 10:41

4 votes

How SQL server database reorganize memory

answered Aug 3, 2012 at 13:09

4 votes

Are these good indexing guidelines?

answered Nov 15, 2011 at 6:19

Stack Exchange Network

60 Answers

How to query last restore date in SQL Server?

How to force drop database in SQL Server 2008

Get Stored Procedure Result Column Types

Error on SQL Server 2000 backup (.bak file) restored on SQL Server 2012

How to change the instance name of SQL Server Express 2008?

What is the difference between SQLEXPRESS and MSSQLSERVER?

Still wrong to start the name of a user stored procedure with sp_?

Max connections SQL Server Express could have?

Remove collation from all database columns

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

At What Point Does Having an Index Become Efficient

How to avoid index scans in SQL Server 2005?

Deny access to information schema in SQL Server

Need for reaching data through clustered index with a non-clustered index

Error in restore database

Column name or number of supplied values does not match table definition error

PK Fragmentation on INT IDENTITY column

Performance impact of having gaps in Identity Column in SQL Server 2005

Performance of SQL Server indexing

How to create unique index for month and year column?

difference between having many non clustered index with single columns and with combination of many columns

Differences between estimated and actual execution plans

SQL table design for primary keys (best practice)

When is a full table scan better than index scan?

SQL Server Primary key / clustered index design decision

Do you set an index on JOIN clauses or where clauses, or both?

Stored procedures and network congestion

Attaching MDF without LDF

How SQL server database reorganize memory

Are these good indexing guidelines?