user avatar
user avatar
user avatar
db2
  • Member for 11 years, 4 months
  • Last seen more than a week ago
  • United States
41 votes

Write differences between varchar and nvarchar

39 votes

Why do people recommend not using the name "Id" for an identity column?

37 votes
Accepted

Find the Foreign Keys Associated with a Given Primary Key

30 votes
Accepted

Is it OK to keep a value which updates in a table?

24 votes
Accepted

Should I add SET NOCOUNT ON to all my triggers?

23 votes

Sort by match of LIKE

20 votes

Should developers be able to query production databases?

18 votes
Accepted

Easy way to check connectivity to SQL Server from client

15 votes
Accepted

Automatically restart SQL Server 2008

11 votes

MAXDOP setting algorithm for SQL Server

11 votes

SQL Server AFTER INSERT trigger

11 votes

How to block user access to perform database application update?

10 votes

Best way to get last identity inserted in a table

10 votes
Accepted

Best Data Type to Store Result of HASHBYTES('MD5', ...)

9 votes

Can I recover a TDE certificate by restoring the MASTER database?

9 votes
Accepted

SQL Server - Transaction Slowness

8 votes
Accepted

What does 'sp_configure allow updates' do?

8 votes

Cannot remove unused filegroups

7 votes

Can I force a user to use WITH NOLOCK?

7 votes

Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?

7 votes
Accepted

Saving a SQL Server database to a file and opening it on another server under any database name

7 votes

Enforce Schema-bound views

7 votes
Accepted

Delete from table where not in another table using two columns

7 votes

How should I design a relationship table for friendship?

7 votes

Is there a reason to update statistics manually?

7 votes
Accepted

Advantage of using a database snapshot for reporting purposes

7 votes

securely exposing sql server 2008 for windows authentication

7 votes
Accepted

identify blocking and send alert

7 votes
Accepted

Multiple triggers vs a single trigger

7 votes

considerations when using triggers on a replicated (target) database

1
2 3 4 5 6