The TRIM function removes spaces from the ends of a string, and SQL Server has had it since 2017. The tests here show which characters TRIM leaves behind, the LEADING and TRAILING keywords, and a WHERE clause that read 884 pages against 3.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SharePoint Conference Singapore 2013: A Great Experience
I had the great pleasure of presenting at SharePoint Conference Singapore 2013, my second visit to the event. I shared three database tips in a session inspired by SQL in Sixty Seconds, and the room overflowed. Here is my recap, with photographs.
Grandfather-Father-Son Retention: Choosing Which Backups to Keep
Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.
Designing a Date Dimension
A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.
Why Table Size Numbers Disagree: Reserved, Used and Unused Space
Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.
SQL SERVER – A List of Various SQL Server RTM and Service Pack Number
Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4
A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.