Skip to main content
Mark Storey-Smith's user avatar
Mark Storey-Smith's user avatar
Mark Storey-Smith's user avatar
Mark Storey-Smith
  • Member for 12 years, 11 months
  • Last seen this week
101 votes
Accepted

When to use TINYINT over INT?

101 votes
Accepted

Check constraint only one of three columns is non-null

39 votes
Accepted

Why is my database still fragmented after I rebuilt and reindexed everything?

38 votes
Accepted

How to find out who deleted some data SQL Server

37 votes

Why shouldn't we allow NULLs?

34 votes
Accepted

Performance difference for COALESCE versus ISNULL?

34 votes

Is it possible to restore sql-server bak and shrink the log at the same time?

32 votes

How to implement a 'default' flag that can only be set on a single row

31 votes
Accepted

SQL Database Structure for RESTful API

30 votes
Accepted

How to find the SQL statements that caused tempdb growth?

30 votes
Accepted

Possible attack on my SQL server?

27 votes

Should you design the database before the application code is written?

27 votes

What risks are there if we enable read committed snapshot in sql-server?

27 votes

Does the order of columns in a table's definition matter?

26 votes
Accepted

Referencing system views in SSDT?

25 votes

Why "Begin Transaction" before "Insert Query" locks the entire table?

24 votes
Accepted

Database 'MyDb' is being recovered. Waiting until recovery is finished

21 votes
Accepted

SQL Server Max Memory not limiting use of RAM

21 votes

Can I see Historical Queries run on a SQL Server database?

20 votes
Accepted

Why are NULLs sorted first?

20 votes
Accepted

SQL Server TempDB behaviour in large memory environment

20 votes
Accepted

How can I query for existing database snapshots in SQL server?

19 votes

Why should I use Visual Studio 2010 over SSMS for my database development?

19 votes
Accepted

Will the transaction log shrink automagically in SQL Server?

18 votes
Accepted

How do you ORDER BY a parameter?

18 votes
Accepted

Designing a platform: one database or multiple databases?

18 votes
Accepted

How can I monitor the call count per stored procedure per timespan?

18 votes
Accepted

How are bit fields sorted for an index?

18 votes
Accepted

SQL Server nvarchar(max) vs nvarchar(n) affects performance

17 votes
Accepted

Find orphaned users

1
2 3 4 5
12