When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache. Continue reading Clear Procedure Cache in SQL Azure database
After a long long break we are back in action but with short notice. This time we are with two different series. . Hope to you see you all in the meet, please pass this information to all your friends and colleagues so that we can see new faces.
All CSSUG members please register at www.sqlpass.org and select Chennai SQL Server user group as your chapter to get benefited from content and notifications about the event in CSSUG.
Thanks to Ram and Madhi for accepting the Invitations.
Facebook Group – https://www.facebook.com/groups/cssug/
WhatsApp Group – CSSUG
Hike Group – CSSUG
Send an SMS to me, Ram or Madhi to get you added to the group.
It’s been a month after the new year started. Hope everyone is having a wonderful time.
This is my first post for this year and it’s a simple one but most of them are looking around for this option quite from SQL Server 2012. Continue reading SQL Server 2016 – Truncate Table Supports Partitioning
It’s been a week I was playing around this new feature. Now I’m going to drop\disable this feature so save some $ in my Azure subscription 🙂 Continue reading SQL Server 2016 – Drop \ Disable Database \ Table Stretch Feature
I started testing the stretch tables quite some time and thought of blogging the experience. Continue reading SQL Server 2016 – Playing Around Stretch database