Mark Storey-Smith

less info
meta site favicon meta user | stack exchange network profile network profile
18,854 reputation
13072
bio website uk.linkedin.com/in/…
location London, United Kingdom
age
visits member for 1 year, 10 months
seen 7 mins ago
stats profile views 800

307 Answers

newest activity votes
36
When to use TINYINT over INT?
27
Possible attack on my SQL server?
24
SQL Database Structure for RESTful API
21
Should you design the database before the application code is written?
21
How to implement a 'default' flag that can only be set on a single row
16
Indexing from start or when performance problem arises?
15
Is DB2 more reliable and stable compared to PostgreSQL or MySQL?
15
Why is my database still fragmented after I rebuilt and reindexed everything?
14
Is it possible to restore sql-server bak and shrink the log at the same time?
14
SQL Server 2008 R2 “Ghost Memory”?
14
Why “Begin Transaction” before “Insert Query” locks the entire table?
14
Why shouldn't we allow NULLs?
13
Does the order of columns in a table's definition matter?
13
How are bit fields sorted for an index?
13
Will the transaction log shrink automagically in SQL Server?
13
How to find out who deleted some data SQL Server
13
Performance difference for COALESCE versus ISNULL?
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?
12
Designing a platform: one database or multiple databases?
11
What is the function of rebuilding indexes?
11
Difference Between Row Level and Page Level Locking and Consequences
11
How many Sproc Parameters is too many?
11
Why should I use Visual Studio 2010 over SSMS for my database development?
11
SQL Server Max Memory not limiting use of RAM
11
Compare Microsoft SQL server performance between virtual and dedicated server
10
How to tackle a large undocumented database
10
SQL Server TempDB behaviour in large memory environment
10
How to find the SQL statements which caused the tempdb grew huge?
10
How to store data in a database without tables?
10
What 'resets' the transaction log
1 2 3 4 5 … 11