alantsai

有時候檔案名稱裡面會有數字，但是排序的時候因為是用字串排序，所以順序不如預期。 例如說有以下幾個檔案：

a1
a2
a10
a20

預期的排序應該如上，但是實際上排序出來會類似：

alantsai

When delete large data showed

The transaction log for database '{db name}' is full due to 'ACTIVE_TRANSACTION'.

which means there is no more space for log

if you don't have that much space for large delete, do it in chunks

more info checkout

alantsai

# 看看那些會刪掉

dir -Directory -Recurse -Include bin,obj  | %{$_.FullName}

# 實際刪掉
dir -Directory -Recurse -Include bin,obj  | Remove-Item -Force -Recurse

alantsai

簡報

• 01-Azure DevOps Overview
• 02-Azure DevOps Pipeline - Build
• 03-Azure DevOps Pipeline - Release

問卷

麻煩有參加幫我填寫一下問卷 - 瞭解一下大家感受如何 感謝

alantsai

source https://stackoverflow.com/questions/159038/how-can-foreign-key-constraints-be-temporarily-disabled-using-t-sql