Monthly Archives: October 2014

SQL Server: Get Fragmentation Level for Indexes

If using an older version of SQL Server,

DBCC SHOWCONTIG

Newer versions should use the dm_db_index_physical_stats

DECLARE @db_id SMALLINT;
DECLARE @object_id INT;
SET @db_id = DB_ID(N'AdventureWorks');
SET @object_id = OBJECT_ID(N'Production.Customers');
IF @object_id IS NULL 
BEGIN
   PRINT N'Invalid object';
END
ELSE
BEGIN
   SELECT IPS.Index_type_desc, 
      IPS.avg_fragmentation_in_percent, 
      IPS.avg_fragment_size_in_pages, 
      IPS.avg_page_space_used_in_percent, 
      IPS.record_count, 
      IPS.ghost_record_count,
      IPS.fragment_count, 
      IPS.avg_fragment_size_in_pages
   FROM sys.dm_db_index_physical_stats(@db_id, @object_id, NULL, NULL , 'DETAILED') AS IPS;
END
GO

Reference

 

Windows: Convert .wav to .m4a [PC Audio to AAC] using FFmpeg

The latest version of ffmpeg use the libvo_aacenc library. This means the libfdk_aac library is optional.

To convert, type the following

ffmpeg -i in.wav out.aac

Or run the following script in a directory to batch convert files.

@ECHO OFF

FOR /R %%G IN (*.wav) DO (CALL :SUB_VLC "%%G")
FOR /R %%G IN (*.wav.m4a) DO (CALL :SUB_RENAME "%%G")
GOTO :eof

:SUB_VLC
 SET _firstbit=%1
 SET _qt="
 CALL SET _newnm=%%_firstbit:%_qt%=%%
 SET _commanm=%_newnm:,=_COMMA_%
 REM echo %_commanm%
 CALL "D:\Program Files (x86)\FFmpeg\bin\ffmpeg.exe" -i %1 "%_commanm%.m4a
GOTO :eof

:SUB_RENAME
 SET _origfnm=%1
 SET _endbit=%_origfnm:*.wav=%
 CALL SET _newfilenm=%%_origfnm:.wav%_endbit%=.m4a%%
 SET _newfilenm=%_newfilenm:_COMMA_=,%
 COPY %1 %_newfilenm%
 DEL %1
GOTO :eof

:eof