Combining result strings in SQL Server

This is just a quick tip on combining (aggregating) result strings in SQL Server. Sometimes it's useful to add multivalued columns to results (or CSV files) but it's not all that simple.

For combining results of a JOIN to a single column you can use the STUFF function ...

more ...

Fixing misplaced SQL Server database files

SQL
Photo by John Carter

Recently I was moving a SQL Server model database log file to another disk. I made an ALTER DATABASE [model] MODIFY FILE... command a bit too fast and pasted the destination from a file browser window. Of course this set the log directory as the new ...

more ...

Searching and replacing text in T-SQL

Database

I recently started learning and using T-SQL for a database integration project I'm doing at work. T-SQL (or Transact-SQL) is Microsoft's extension to SQL that adds some transactional programming features to it. It's used in SQL Server.

I'm slowly getting the hang of it. Mostly I ...

more ...