Skip to main content
Greenstone Walker's user avatar
Greenstone Walker's user avatar
Greenstone Walker's user avatar
Greenstone Walker
  • Member for 11 years, 4 months
  • Last seen this week
  • Christchurch, New Zealand
142 votes

When should I use a unique constraint instead of a unique index?

23 votes

What's the owner of SqlServerAgent job for?

16 votes

When is it appropriate to use SQL Server Developer Edition?

14 votes

SQL Server 2014 - Reset everything

13 votes

Is select * still a big no-no on SQL Server 2012?

13 votes
Accepted

Users cannot view tables in non-default schema in SSMS

13 votes

Why are constraints applied in the database rather than the code?

11 votes

How to hide rows in SSRS report?

11 votes

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

9 votes

Clustering vs. transactional replication vs. availability groups

7 votes

Mirroring vs. Log Shipping

7 votes

Why should an application not use the sa account

6 votes

Is it recommended to use Identity as an alternative to primary key?

5 votes

Prevent SysAdmin from doing a Database Restore

4 votes

Transferring Data from OLTP to OLAP databases

4 votes

How do I find all tables in a DB that have no explicit primary key?

4 votes
Accepted

How to securely connect app and database servers?

4 votes

MSSQLSERVER service does *not* start, port 1433 in use

4 votes

Uniqueidentifier vs. IDENTITY vs. Material Code --which is the best choice for primary key?

4 votes

Why would a table use its primary key as a foreign key to itself

4 votes

Should a SQL Server DBA know Windows Server and vice versa? Are these roles soon to become synonymous. Or at least more encapsulated/?

4 votes

Arbitrarily ordering records in a table

4 votes

In what data type should I store an email address in database?

4 votes

Is there a generic term for tables and views?

3 votes

Simultaneous money withdrawls from a distributed/replicated database

3 votes

Naming foreign key columns

3 votes

What are the differences between SQL I/O Sim and SQL IO tools?

3 votes

Why does a UNIQUE constraint allow only one NULL in SQL Server?

3 votes

Adding non-nullable NEWSEQUENTIALID() column to existing table

3 votes

Options for Data Encryption in SQL Server 2008 R2 Standard Edition?