Dinesh's Blog :::: Being Compiled ::::

Showing posts with label Extended Stored Procedure. Show all posts
Showing posts with label Extended Stored Procedure. Show all posts
Thursday, December 31, 2015

SQL Server CPU usage: Recording and monitoring with many more server statistics

›
There are many ways of collecting statistics of SQL Server such as CPU usage, IO made, reads and writes. One facility given by SQL Server ...
Tuesday, December 29, 2015

Split values in a string and get them into varibles using xp_sscanf extended stored procedure

›
While I was writing some Hive queries for getting words from a lengthy string, I came across a useful extended stored procedure that allo...
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.