You have run a server side trace that created 45 trace files. You want to load the trace files on your workstation in a database table called PerfData for further analysis. You need to load three files starting at c:my_trace_38.trc.
Which Transact-SQL statement should you use?
A.
SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:my_trace.trc’, 3)
B.
SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:my_trace_38.trc’, 3)
C.
SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:my_trace38.trc’, default)
D.
SELECT * INTO PerfData
FROM ( SELECT * FROM ::fn_trace_gettable (‘c:my_trace_38.trc’, default)
UNION ALL
SELECT * FROM ::fn_trace_gettable (‘c:my_trace_39.trc’, default)
UNION ALL
SELECT * FROM ::fn_trace_gettable (‘c:my_trace_40.trc’, default) ) Trc