Trim Left Char (for single words)
Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.
2012-08-16 (first published: 2012-08-02)
945 reads
trim
RE: Killed SPs and sqlserveragent stop working
Tyang, you should not kill all processes that have status 'sleeping'! Some is using by SQL Server itself and used only when some events triggered.If you insist to kill the processes, try to add one more condition - uid = 0
2004-04-15
RE: SQL Recommendations
SQL Reporting Services looks very interesting. Here's a good article and link to Microsoft's site. Although I haven't used it yet, it appears to be very user-friendly and the report designer is similar to MS Access. http://www.sqlmag.com/Articles/Index.cfm?ArticleID=40529 http://www.microsoft.com/sql/reporting/default.asp It will be free as an add-in to existing SQL 2000 licenses. However you will need to […]
2003-12-23
RE: Best Practices for Reboot Schedule
Like most respondants we only reboot our servers when neccessary. However as an aside this means you need a scheduled job to cycle your sql logs regularly (we do once a week, but we keep more than the default 6 past logs). The first time you try and check out the log file of a […]
2003-07-09
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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