Stack Exchange

Mark Storey-Smith

London, United Kingdom

uk.linkedin.com/in/markstoreysmith

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
40
When to use TINYINT over INT?
dba.stackexchange.com

27
Possible attack on my SQL server?
dba.stackexchange.com

24
SQL Database Structure for RESTful API
dba.stackexchange.com

22
Should you design the database before the application code is written?
dba.stackexchange.com

21
How to implement a 'default' flag that can only be set on a single row
dba.stackexchange.com

16
Why shouldn't we allow NULLs?
dba.stackexchange.com

16
Indexing from start or when performance problem arises?
dba.stackexchange.com

15
Why is my database still fragmented after I rebuilt and reindexed everything?
dba.stackexchange.com

15
Is DB2 more reliable and stable compared to PostgreSQL or MySQL?
dba.stackexchange.com

14
Is it possible to restore sql-server bak and shrink the log at the same time?
dba.stackexchange.com

14
Why “Begin Transaction” before “Insert Query” locks the entire table?
dba.stackexchange.com

14
SQL Server 2008 R2 “Ghost Memory”?
dba.stackexchange.com

14
Does the order of columns in a table's definition matter?
dba.stackexchange.com

13
Will the transaction log shrink automagically in SQL Server?
dba.stackexchange.com

13
How to find out who deleted some data SQL Server
dba.stackexchange.com

13
Performance difference for COALESCE versus ISNULL?
dba.stackexchange.com

13
Why should I use Visual Studio 2010 over SSMS for my database development?
dba.stackexchange.com

13
How are bit fields sorted for an index?
dba.stackexchange.com

12
Designing a platform: one database or multiple databases?
dba.stackexchange.com

12
In SQL Server, is it possible to have a PRIMARY KEY on a table without either CLUSTERED or NONCLUSTERED indexes on the same key?
dba.stackexchange.com

11
Difference Between Row Level and Page Level Locking and Consequences
dba.stackexchange.com

11
Compare Microsoft SQL server performance between virtual and dedicated server
dba.stackexchange.com

11
SQL Server Max Memory not limiting use of RAM
dba.stackexchange.com

11
How many Sproc Parameters is too many?
dba.stackexchange.com

11
What is the function of rebuilding indexes?
dba.stackexchange.com

10
How do you ORDER BY a parameter?
dba.stackexchange.com

10
Is ROLLBACK a fast operation?
dba.stackexchange.com

10
How to free SQL Server memory?
dba.stackexchange.com

10
What is the most efficient way of inserting 199 millon rows of data?
dba.stackexchange.com

10
What 'resets' the transaction log
dba.stackexchange.com

1 2 3 4 5