osman hömek / not defteri

February 11, 2010

mssql profiler trace

Filed under: mssql — osman @ 12:25 am 

SELECT * INTO MyTraceTable FROM ::fn_trace_gettable('C:MyTrace.trc', default)
ne süper sql cümlesi ama değil mi?
http://msdn.microsoft.com/en-us/library/ms979207.aspx

February 7, 2010

mssql shrink

Filed under: mssql — osman @ 8:38 pm 

  1. DBCC SHRINKFILE(Pubs_log, 100)
  2. BACKUP log Pubs WITH TRUNCATE_ONLY
  3. DBCC SHRINKFILE(Pubs_log, 100)

Powered by WordPress