Remove trailing delimiting character from a delimited string
Contrary to the question asked, rtrim() will remove any number of characters, listed in the second argument, from the end of the string. … Read more
truncate
Is there any limit on line length when pasting to a terminal in Linux?
As mentioned in Stéphane Chazelas’s answer, the terminal driver’s input editing buffer has a limited size. Instead of pasting into the terminal, you … Read more
Most efficient method to empty the contents of a file
I am aware of three methods to delete all entries from a file. They are >filename touch filename1 filename < /dev/null Of these … Read more
SSIS package blocks itself if uses TRUNCATE
There is an SSIS package with Required transaction on the package level and Supported on the tasks level. The main part of the … Read more
Huge MSDB database
I have a very large MSDB database and have been working on clearing this out and setting up maintenance tasks – something my … Read more
Truncate log file mirrored database
In SQL Server 2008, I have a mirrored database with a log file that has increased to 80GB, which is not normal and … Read more
Transaction Log is big! But simple recovery mode is chosen!
I am wondering: We have a Database on our MS SQL Server 2012. The recovery mode is “simple”. The DB itself is about … Read more
Which command Deletes and Frees Space
I’m reading through the 98-364 exam book and there’s a question I can’t quite answer: “What command would you use to remove all … Read more
What factors prevent and delay TRUNCATE command?
I had a quite large table, perhaps a 50M rows and I had to truncate it. Usually truncate is really fast but in … Read more
Why do I have to backup a transaction log twice for it to shrink?
This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file – that … Read more
