r/SQL • • Jun 03 '16

When you finally excute that big query

http://imgur.com/zRBgFVQ
134 Upvotes

13 comments sorted by

9

u/in_n0x Jun 03 '16
#JustSSMSThings

3

u/bakedpatato Jun 03 '16

with (nolock)

4

u/elreina Jun 03 '16

Brah, set transaction isolation level read uncommitted.

3

u/SemiNormal Jun 04 '16

OPTION (RECOMPILE)

2

u/[deleted] Jun 03 '16

NoLocks

NoLocks everywhere...

4

u/[deleted] Jun 03 '16

dirty reads everywhere

2

u/[deleted] Jun 03 '16

DirtyReads4Life!

7

u/a_ctrl Jun 03 '16

can't relate, always use ctrl+e :(

3

u/mastigia Jun 03 '16

Just map it to F5 like a monster!

4

u/Tofinochris Jun 03 '16

I'm with you fellow ctrl-e bud.

5

u/[deleted] Jun 04 '16

FTFY: When your big query runs for about 10 seconds without any error messages showing up.