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 TransactSQL
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