Tag Archives: system functions
-
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
6February 11, 2013 by Kenneth Fisher
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically …
Continue reading -
IsMSShipped
3January 23, 2013 by Kenneth Fisher
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
Continue reading -
My view isn’t reflecting changes I’ve made to the underlying tables.
8January 20, 2013 by Kenneth Fisher
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. …
Continue reading -
What port is my instance listening on?
8January 8, 2013 by Kenneth Fisher
I just had the interesting task of finding the port number that one of the instances I deal with is …
Continue reading -
Where is my backup?
10December 12, 2012 by Kenneth Fisher
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working …
Continue reading -
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
4November 12, 2012 by Kenneth Fisher
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats …
Continue reading -
How do I find all stored procedures or views that use a specific table?
3October 26, 2012 by Kenneth Fisher
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views …
Continue reading -
fn_OBJECT_TYPE
4October 19, 2012 by Kenneth Fisher
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist …
Continue reading
SQL Studies 