/****** Object:  Table [dbo].[macVendor]    Script Date: 22/01/2014 2:57:36 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[macVendor](
    [companyId] [nvarchar](50) NOT NULL,
    [organization] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED
(
    [companyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


/*** view cached query plans and text */
GO
SELECT TOP 100
    cp.objtype,
    OBJECT_NAME(st.objectid,st.dbid) AS ObjectName,
    cp.usecounts,
    cp.size_in_bytes,
    st.dbid,
    st.objectid,
    st.NUMBER,
    st.encrypted,
    st.text,
    qp.dbid,
    qp.objectid,
    qp.NUMBER,
    qp.encrypted,
    qp.query_plan

FROM sys.dm_exec_cached_plans AS cp
CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
WHERE  text LIKE '%macVendor%'
ORDER BY cp.usecounts DESC