You can make use of information_schema.routines...

Another question is why do you need to update statistics on indexes and Clark was right...

Don't you have to create statistics on index or a table first?...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....

How to pull float numbers that have decimal part? ...

What will be the result of query: <pre class="brush: sql"> SELECT COUNT(*) as C1, COUNT(A) as CA, COUNT(B) as CB, SUM(A) as SA, SUM(B) as SB from [test].[dbo].[Table_1] </pre> On table: <pre class="brush: plain"> ID ...

Why do we need user defined data types?...