Unless it's someone in my field I say "computer stuff". Anything beyond that I generally get a blank stare.

pietlinden beat me to it - here's what that solution would look like:

-- Sample data
USE tempdb
GO
IF OBJECT_ID('dbo.t1') IS NOT NULL DROP TABLE dbo.t1;

I'm stuck on the last Sunday at the moment but here's how you handle the first Monday. 
Lynn Pettis has a great post about common date routines.  I...

This perhaps? 

SELECT FullName, NewType, SUM(Amount1), SUM(Amount2)
FROM
(
SELECT TOP (1) FullName, NewType, Amount1, Amount2
FROM @test-2
ORDER BY TDate...

I stumbled across this while looking to create my own and would like to propose a couple changes:  
First, I have noticed lately moving filters from a WHERE clause to a...

Can you provide an example of what the array looks like and what type of array it is? 

Problem is that the array can contain up to 250...

Fixing your data model to avoid this type of tomfoolery is always my first choice.

Thanks folks for the replies. After a little more research I discovered that the problem was related to periodic connectivity issues between the server and the SAN. I never saw...

Another really fast way to tackle this (using NGrams8k - link is in my signature):

SELECT *
FROM #stringsplit s
CROSS APPLY
(
SELECT STUFF(REPLACE((

I must admit, when I saw the title, TRIM() in T-SQL my first thought was, "boring!" 
That said - I was quite impressed and found the article to be quite...