Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Tuesday, 10 May 2016

Query to Find an Object Type

 The relevant query is as follows:

SELECT object_type
FROM   user_objects
WHERE object_name = ‘<OBJECT_NAME>’;

Share this article :


  1. Hi Dayakar,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    We have a weird issue with MSSQL 2012 on AMAZON (RDS), at one point the CPU spikes to 20 % and the 20% is now the new 0% until I change the threshold for parallelism. This means the cpu stays constant > 20% during the day. After the modification of the parameters the cpu drops and the sql server shows normal CPU signs going from 5% to 10% with some higher spikes. I have no idea why this happens and why this resolves itself when I change the max dop or the threshold for parallelism.

    Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.