Sometimes when you make a SQL script, that loops through a lot of records, you want to print a status. When you do this using print (or select), this will only display the content when the buffer is full. To immidiatly print everything to the screen use:
RAISERROR ('here', 0, 1) WITH NOWAIT
This will flush the buffers to screen and so you will see the output immediately.