This function allows the user to pass in a string / character value and it will padd the value according to given parameters. The parameters are as follows:@ValueToPad = Value to be padded by function.@PadCharacter = Character used to pad a given value.@Justification = Justification format bit 0 - Value will be RIGHT justified […]
2002-09-06
280 reads
This function strips a list of characters from the value passed in. Useful for cleaning up input data and removing unwanted characters for streamlined data storage.
2002-09-06
348 reads
Database backup made simple. You dont even have to pass any parameters if desired. It will all be handled for you.Capable of Net Send status notifications and writes status message to Windows event log.Side Effects:When not passing any @database params the the backup is done of the database where the proc resides. That means if […]
2002-09-06
583 reads
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Comments posted to this topic are about the item The SQL Server 2016 Plan
hi, a few years ago was at a very large company that bought a...
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers