Remove multiple whitespace from a string (alternat
Here's an alternate way of removing multiple white spaces by using the REPLACE command.
2005-03-08 (first published: 2005-02-22)
168 reads
Blogs
A Basic Update Trigger: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Apply for a 2025 PASS Summit Scholarship
By Brian Kelley
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...
SQL Server TempDB: The Most Overlooked Bottleneck
By Kevin3NF
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...
Forums
Best/easiest way to import an SSIS package...
Folks, Looking for advice on the best way to import a package. I hope...
Measure duplicating its value when non-conformed dimension attribute is included
Hi, I have two fact tables (say FactA, and FactB), that are joined/shared...
balancing numa nodes
Can anybody advise on how i go about balancing threads to each node. As...
Question of the Day
How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers