User Mark Storey-Smith - Database Administrators Stack Exchange

bio	website	uk.linkedin.com/in/…
	location	London, United Kingdom
	age
visits	member for	1 year, 10 months
	seen	6 mins ago
stats	profile views	794

	18,754 reputation	bio	website	uk.linkedin.com/in/…	visits	member for	1 year, 10 months
13072 badges		location	London, United Kingdom		seen	6 mins ago

10

25

votes

2

answers

2

kviews

Are SQL Server in-place upgrades as ill advised as they used to be?

dec 10 at 12:21 Mike Walsh 3,518

8

23

votes

3

answers

2

kviews

Unexpected scans during delete operation using WHERE IN

sql-server-2008-r2 query optimizer

dec 15 at 1:20 Dmitriy Pilugin 1

8

19

votes

7

answers

4

kviews

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

sql-server sql-server-2008 database-design aggregate indexed-view

jun 17 '12 at 0:18 AlexKuznetsov 3,627

5

19

votes

4

answers

708

views

How do you test for race conditions in a database?

concurrency testing

apr 2 '12 at 15:02 Nick Chammas 5,910

13

18

votes

2

answers

3

kviews

What does a DBA have to know about SSAS?

sql-server database-administration ssas

mar 12 '12 at 20:42 ConcernedOfTunbridgeWells 10.4k

6

14

votes

3

answers

954

views

Dynamically Define a Range in a Dimension

sql-server-2008 ssas cube dimension pivot-table

jul 9 at 12:17 AmmarR 1,390

3

13

votes

3

answers

4

kviews

Efficient INSERT INTO a Table With Clustered Index

sql-server performance insert clustered-index

nov 13 '11 at 23:38 Martin Smith 17.5k

2

12

votes

1

answer

2

kviews

Why is using a table variable more than twice as fast as a #temp table in this specific case?

sql-server sql temp-tables

feb 16 at 14:14 Martin Smith 17.5k

3

12

votes

3

answers

1

kviews

Can you explain this execution plan?

sql-server sql-server-2008-r2 execution-plan

mar 14 '12 at 8:28 Martin Smith 17.5k

2

12

votes

3

answers

814

views

Slow deletion of records when a trigger is enabled

sql-server performance sql-server-2008-r2 triggers delete

aug 29 at 12:19 Paul White 7,985

2

11

votes

2

answers

828

views

Deadlocks From Locks on Same Temporary Tables In Different Processes

sql-server sql-server-2008 deadlock

apr 11 at 7:19 amin 11

7

10

votes

1

answer

445

views

SQL Server - Anyone use SUMA, trace flag 8048, or trace flag 8015?

sql-server-2008-r2 performance memory

nov 16 at 0:20 Mike Walsh 3,518

3

9

votes

2

answers

1

kviews

SQL Server does not optimize parallel merge join on two equivalently partitioned tables

sql-server join partitioning

aug 29 at 10:31 Paul White 7,985

2

9

votes

1

answer

690

views

What's the anatomy of a columnstore index?

sql-server index sql-server-2012 columnstore

jun 2 '12 at 6:05 Paul White 7,985

4

9

votes

4

answers

466

views

Inaccurate 'Actual' row counts in parallel plan

sql-server

may 3 '12 at 22:55 Mark Storey-Smith 18.8k

3

9

votes

1

answer

549

views

SQL Server Cache Flush and Disk I/O

sql-server performance service-broker

dec 4 at 7:01 Remus Rusanu 21.1k

2

8

votes

2

answers

493

views

Optimization: Moving variable declarations to the top of your procedure

sql-server sql sql-server-2008-r2 stored-procedures optimization

jun 13 '12 at 15:33 Nick Chammas 5,910

1

8

votes

3

answers

1

kviews

What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?

sql-server sql-server-2005 performance fragmentation application-design

nov 19 '11 at 4:57 D K 341

1

8

votes

2

answers

753

views

using tables as Table-Valued Parameters (TVP)

sql-server-2008

feb 27 '12 at 9:36 Andrei Rinea 227

1

8

votes

2

answers

403

views

SQL Server Data Tools and partition functions

sql-server

jun 5 '12 at 10:43 Gonsalu 488

3

7

votes

4

answers

488

views

Is there a standard language/interface for programmatic ETL in SQL Server?

sql-server etl

apr 19 '12 at 17:21 Jon of All Trades 793

1

7

votes

1

answer

379

views

What factors go into an Indexed View's Clustered Index being selected?

sql-server index-tuning clustered-index indexed-view

oct 16 at 15:30 Paul White 7,985

4

7

votes

3

answers

2

kviews

What is the best method to add error handling in SQL 2005 stored procs?

sql-server-2005 stored-procedures best-practices

mar 1 '12 at 21:25 Phil Helmer 236

5

7

votes

2

answers

311

views

Increased RAM, Worse Performance

sql-server sql-server-2008-r2 memory

jan 25 at 22:02 Derek Kromm 773

2

6

votes

3

answers

150

views

Nonclustered Index Insert

sql-server

mar 9 '12 at 20:44 Martin Smith 17.5k

2

6

votes

2

answers

1

kviews

SQL Server Join/where processing order

sql-server performance join

aug 25 '11 at 18:47 Mark Storey-Smith 18.8k

2

5

votes

2

answers

236

views

Best practices for change management with indexes

index best-practices change-management

may 7 '12 at 6:05 Community♦ 1

1

5

votes

1

answer

553

views

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

sql-server temp-tables identity sql-server-2012 sequence

mar 16 '12 at 15:27 Nick Chammas 5,910

2

4

votes

1

answer

975

views

Remote Debugging

sql-server debugging remote

nov 28 '11 at 10:18 Jack Douglas♦ 12.8k

3

votes

1

answer

196

views

sql server database sharding - what to do with common data / non sharded data

sql-server

may 3 at 1:05 Community♦ 1

Mark Storey-Smith

40 Favorites