Some T-SQL tips resources I came across lately:
- codemag: SELECT vs. SET in T-SQL parameters
- MSDN: DATETIME internals
- T-SQL language blog: compiler
- Angel Saenz-Badillos: connection pooling
And the last one comes from MSSQL server magazine, 09/2004. How can I find the last day of the month ?
SELECT DATEADD(ms, -5, DATEADD(mm, DATEDIFF(m, 0, GETDATE()) + 1, 0))
Sunday, September 26, 2004 1:22 AM