sp_dboption used to be a very useful system procedure available till SQL 2008 R2 which helps us to identify the set options for database as well as modiying already set option values. I’ve used it numerous times for setting options for…
Triggers on FileTables in SQL 2012
This is a follow up post to the below which explained on step by step details for configuring and implementing FileTables in SQL 2012 In this post, I will be illustrating with sample code how triggers can be implented on a…
Working with filetables in SQL 2012
Filetable is an exciting new feature that was introduced in SQL 2012. It can be regarded as an extension of FILESTREAM data storage that got introduced from SQL 2008 onwards. Filetables enable us to create table type entity on file…
Last access time in Filetable schema
I was doing some experiments with new filetable feature introduced in SQL 2012 and I noticed something strange which is clarified in this blog. The filetable has an internal schema table which gives us the details on the files and folders that…
Generate datetime values from integers
This post is an extension to my earlier post regarding datetime formatting tips given below http://visakhm.blogspot.com/2010/01/some-quick-tips-for-date-formating.html The impetus behind creating this blog is the increasing requests I’ve had recently from my own colleagues as well as from many others through forums asking me…
DAX DATE function demystified
I was working intensively last few days on DAX and DATE() was one of the functions I used quite a few times. I was confused initially on how DATE() function works and it took me a while before I understood…
Date and Time functions in DAX extended
I was working on DAX project during last few days and found out something strange. Though DAX function set has some of very advanced date/time based functions like DATESMTD,DATESQTD,etc it lacks a few basic functions like QUARTER(). As this is…
Extended analytic and window functions in SQL 2012 -2
This is a follow up post from http://visakhm.blogspot.com/2012/07/extended-analytic-and-window-functions.html to explain on some of new additions to OVER clause in SQL 2012 which gives us more flexibility in calculating running counts. Extending the earlier example, Lets consider scenario below Analyzing the sample…
Extended analytic and window functions in SQL 2012
This post explains couple of scenarios where new analytic and aggregation windowing functions of sql 2012 can be effectively used to achieve functionality as compared to sql 2008.In one of my previous postshttp://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html I’d explained the application of APPLY operator in various…