mike42

less info
stack exchange network profile network profile
48 reputation
5
bio website
location
age
visits member for 7 months
seen Mar 12 at 16:38
stats profile views 1

20 Actions

suggestions reviews revisions comments badges posts accepts all
Feb
1
 answered Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
Jan
22
 answered MI Data Warehouse Advice
Jan
21
 awarded  Supporter
Jan
18
 awarded  Teacher
Jan
18
 answered How can I rename a table, but also all FK etc. references to that table?
Jan
16
 revised Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
added 709 characters in body
Jan
11
 comment Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
let us continue this discussion in chat
Jan
11
 comment Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
IO messages appended to the end of the question
Jan
11
 revised Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
added 943 characters in body
Jan
11
 comment Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
As a reference, the charge table is about 100 million rows and reserves about 25GB split roughly 50/50 between data and index. The entire db is about 325 GB.
Jan
11
 awarded  Editor
Jan
11
 comment Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
Advice taken; plans attached.
Jan
11
 revised Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
deleted 29 characters in body
Jan
11
 asked Same Query takes 0 seconds on Server A, 7.5 minutes on Server B (same db/hardware/config)
Nov
16
 comment Why does my transaction log use so much space?
Terrific advice! I mocked up a test and reran the exact same process, exact same data, exact same tables. The insert took 20 seconds rather than 20 minutes. Log space usage was much less (I was unable to monitor the log space as precisely due to the single user mode). The only thing I did differently was to use simple recovery mode rather than bulk.
Nov
16
 awarded  Scholar
Nov
16
 accepted Why does my transaction log use so much space?
Nov
15
 awarded  Student
Nov
15
 comment Why does my transaction log use so much space?
26 columns, 1 clustered PK, 15 nonclustered indexes, 11 foreign keys. 0 indexed views, no change data capture, no change tracking, no indexed views.
Nov
14
 asked Why does my transaction log use so much space?