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

Showing posts with label Tables. Show all posts
Showing posts with label Tables. Show all posts
Saturday, March 4, 2017

Get all SQL Server tables that have IDENTITY enabled

›
Here is a useful script. If you need to find out tables that have Identity property enabled, you can simply query the sys.tables  Catalog ...
Wednesday, September 28, 2016

How to get the most accessed tables from SQL Server database

›
While discussing with one of my clients, this question raised but I knew that there is no direct way unless we use something related to in...
›
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.