Database Administrators
marc_s's user avatar
marc_s's user avatar
marc_s's user avatar
marc_s
  • Member for 13 years, 2 months
  • Last seen more than a week ago
  • Bern, Switzerland
Profile Activity

61 Answers

Score Activity Newest
8 votes

SQL Server alert mechanism whenever an identity column data type value is about to reach its maximum limit

9 votes
Accepted

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

131 votes
Accepted

How to force drop database in SQL Server 2008

18 votes

Get Stored Procedure Result Column Types

4 votes
Accepted

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

2 votes

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

3 votes

Does SQL Server prioritize select and update statements?

0 votes
Accepted

Trigger Gives an Error on Multiple Rows SQL SERVER

2 votes

Access 2010 ODBC Connection to SQL Server 2005

4 votes

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

3 votes
Accepted

Differentiate SQL Server Express from SQL Server installed in a server

1 vote

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

3 votes

Index optimization for table that is truncated every day

2 votes
Accepted

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

4 votes
Accepted

Execution Plan in Microsoft SQL Server

2 votes

SQL Server 2008 R2 Missing Index

2 votes
Accepted

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

2 votes
Accepted

Constant values in columns

1 vote

Server side trace to database

4 votes
Accepted

When do you add your foreign keys?

14 votes

Remove collation from all database columns

3 votes

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

2 votes

Back up my ASPNETDB

8 votes
Accepted

PK Fragmentation on INT IDENTITY column

155 votes
Accepted

How to query last restore date in SQL Server?

12 votes
Accepted

At What Point Does Having an Index Become Efficient

7 votes

How to create unique index for month and year column?

3 votes
Accepted

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

14 votes
Accepted

Max connections SQL Server Express could have?

3 votes

Sequential GUID or bigint for 'huge' database table PK

1
2 3