marc_s's user avatar
marc_s's user avatar
marc_s's user avatar
marc_s
  • Member for 12 years, 3 months
  • Last seen more than a week ago
  • Bern, Switzerland
151 votes
Accepted

How to query last restore date in SQL Server?

130 votes
Accepted

How to force drop database in SQL Server 2008

18 votes

Get Stored Procedure Result Column Types

17 votes

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

17 votes
Accepted

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

14 votes
Accepted

What is the difference between SQLEXPRESS and MSSQLSERVER?

14 votes

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

14 votes
Accepted

Max connections SQL Server Express could have?

14 votes

Remove collation from all database columns

13 votes

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

12 votes
Accepted

At What Point Does Having an Index Become Efficient

11 votes
Accepted

How to avoid index scans in SQL Server 2005?

11 votes
Accepted

Deny access to information schema in SQL Server

10 votes
Accepted

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

9 votes
Accepted

Error in restore database

9 votes
Accepted

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

8 votes
Accepted

PK Fragmentation on INT IDENTITY column

8 votes
Accepted

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

7 votes
Accepted

Performance of SQL Server indexing

7 votes

How to create unique index for month and year column?

6 votes
Accepted

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

6 votes
Accepted

Differences between estimated and actual execution plans

6 votes

SQL table design for primary keys (best practice)

6 votes

When is a full table scan better than index scan?

5 votes

SQL Server Primary key / clustered index design decision

5 votes
Accepted

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

4 votes
Accepted

Stored procedures and network congestion

4 votes

Attaching MDF without LDF

4 votes

How SQL server database reorganize memory

4 votes

Are these good indexing guidelines?