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
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
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
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
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
I have a very large MSDB database and have been working on clearing this out and setting up maintenance tasks – something my … Read more
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
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
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
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
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