Category Archives: Procedures

Below is a SQL script that I use all the time when it comes down to hung procedures and any unwanted processes that are left open. This below T-SQL could also be turned into a procedure quite easily and used as a cleanup job before running any backups. DECLARE @p_SPID int, @p_SQL nvarchar(2000), @dbName nvarchar(100) [...]

As I am currently looking into ways in which I could automate dataloading from multiple file formats using stored procedures. I stumbled accross OPENROWSET, which proves to have more than what i bargined for with being able to support multple file types which include (access, Excel, csv, text) So for this post I am looking [...]