Introduction It’s amazing to me the reactions I get when I show people seemingly simple tricks on how to automate or generate code and/or script […]
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 […]
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 […]
How to get Filename and File Extension from a Column with tSQL
I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query […]
Straight to the Point: Query for Database and Table Sizes
I love how I have to search too much to find simple information, one liners, it is just like in College where my college course […]
Selecting Random Date Between a Date Range with tSQL
I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was […]
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 […]