Which Transact-SQL statement should you use?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *