Format Currency Into a String
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,001 reads
Currency
A SQL-Based Universal Currency Formatter
SQL Server isn't usually the best place to format dates or currency as strings. It can be a complex task to conform correctly with national and cultural conventions. Just occasionally, though, you need to do it. This is easy in SQL Server 2012, but if you aren't using that, what do you do?
2013-03-07
2,201 reads
RE: Very Large Transaction Logs
Thank you all for the input so far.You all right about the transaction logs and ArcServe. I went into the ArcServe event log for the backups and found that unlike SQL, only the database is backed up. While it does perform a proper Checkpoint, the log is not truncated and the actual Transaction Log device is […]
2004-02-05
2 reads
RE: Take too long to shrink a huge database, HELP!!!!
I know that it seems drastic I would try (on a test database first)1. Backup the database (just in case)2. Detach the database3. (I usually delete the log file)4. reattach the database (since its new it will have your default size allocation)
2004-01-25
1 reads
RE: Changing the SA Password in the MSDE
Thanks, that works a treat, what happens if the user has forgotten the current password, i was told they have to uninstall MSDE and reinstall it, is this correct. Thanks Steve
2003-12-01
1 reads
RE: Processor Performance issue. could it be virus
Any errors in SQL Server errorlog? Check serevr's application and system log too.
2003-08-21
1 reads
RE: Anyone uses C2 auditing on SQL Server?
We use C2 because we are required by the government to do so. From what I undertand, C2 audits all events. The events are written to 2000MB rollover files located in mssql\data. One disadvantage is that if SQL Server cannot write to the audit file used in C2, then SQL Server will automatically shut down! […]
2003-08-13
1 reads
RE: can't copy Log file
Hi Mark, I have literally just found the answer.(midnight here in sunny Glasgow)I was trying to copy on to a cd ROM that didn't have enough space for the massive LDF file... aaah my shame.To be fair, the error message was I was getting was hardly the most informative. aah well, it's a lesson learned.cheers […]
2003-08-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers