TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To w...

How to Kill all Processes for a Specific Database

Usually you would just use the Activity Monitor like shown below… The mundane repetition of right click each process and selecting Kill Process becomes annoying after the n_th process.  ...

UPDATE SELECT FROM JOIN

This is something that I don’t do often, but it pops up every now and again. I always forget how to do it, so I have to look it up each time. Here is an example: [crayon-5f92b4bb033ad694096185/]...