Skip to main content
Database Administrators
Mark Storey-Smith's user avatar
Mark Storey-Smith's user avatar
Mark Storey-Smith's user avatar
Mark Storey-Smith
  • Member for 13 years, 5 months
  • Last seen more than a month ago
Profile Activity
Stats
31,859
reputation
3.1m
reached
348
answers
7
questions
Communities
View all
Badges
View all badges
9
gold badges
90
silver badges
125
bronze badges
Top tags
View all tags
1,794
Score
216
Posts
61
Posts %
658
Score
92
Posts
26
Posts %
433
Score
63
Posts
18
Posts %
328
Score
45
Posts
13
Posts %
312
Score
47
Posts
13
Posts %
241
Score
24
Posts
7
Posts %
Top posts
View all questions and answers
answer
101
When to use TINYINT over INT?
Aug 23, 2011
answer
101
Check constraint only one of three columns is non-null
Sep 1, 2011
answer
39
Why is my database still fragmented after I rebuilt and reindexed everything?
Sep 2, 2011
answer
39
How to find out who deleted some data SQL Server
Aug 3, 2011
answer
37
Why shouldn't we allow NULLs?
Aug 30, 2011
answer
34
Is it possible to restore sql-server bak and shrink the log at the same time?
Oct 2, 2011
answer
34
Performance difference for COALESCE versus ISNULL?
Aug 3, 2011
answer
32
How to implement a 'default' flag that can only be set on a single row
Aug 19, 2011
answer
31
SQL Database Structure for RESTful API
Feb 18, 2013
answer
30
Possible attack on my SQL server?
Nov 8, 2011
Top Meta posts
4
3
40
Canonical Answers
36
Canonical Answers
13
Is DBA a place for homework questions?
13
Sometimes, an answer is just plain wrong. What to do?
7
How should we handle back and forth Q&A?
Top network posts
View all network posts
9
Visual Studio 2010 debug in a fixed port
7
Get a record of one fields and also of the Foreign Key
6
SQL Server SUM two values from other SUM's
5
How to count left joined rows?
5
Advice on software / database design to avoid using cursors when updating database