Multi-statement table valued functions can be found in sys.objects with type = 'TF':

SELECT OBJECT_SCHEMA_NAME(object_id) + '.' + name

FROM sys.objects

WHERE type = 'TF'

Inline table valued functions have type = 'IF'

SELECT OBJECT_SCHEMA_NAME(object_id)...

The only thing that comes to my mind is sp_get_query_template.

It is used to get the parameterized form of a query, but it fails if the query is not valid.

BEGIN...

I have no idea how SQL Server calculates that number, especially when no page has ever been flushed from the cache: I can only tell you what it means.

I don't...

Usually intermittent performance issues are caused by:

* blocking

* bad parameter sniffing

For the first one, I would set up some monitoring. With SQL Server 2005 your options are not many: I...

Lynn Pettis (9/1/2016)

---

spaghettidba (9/1/2016)

---

PLE is a counter that represents the number of seconds a data page is expected to live in the buffer cache before it is evicted to make...

PLE is a counter that represents the number of seconds a data page is expected to live in the buffer cache before it is evicted to make room for other...

spaghettidba (8/29/2016)

---

It will allow only one user at a time to access the database.

If you want to restrict access to only db owners (any number of them at the same...

It will allow only one user at a time to access the database.

If you want to restrict access to only db owners (any number of them at the same time),...

ALTER DATABASE MyDatabase SET SINGLE_USER

Unfortunately it is not possible.

No, credentials and proxy are for execution, not for managing the jobs.

The builtin roles are for managing jobs. Set the owner of the job to the user you need to...

Lowell, why don't you use the API for that?

You can stream the event in (near) realtime if you have a session running, or you can post-process the event reading a...

That could...

SQL Server Agent could impersonate you windows users in these cases:

1) You are the owner of a job and not a sysadmin in SQL Server

2) SQL Server Agent service is...

There is no way to tell that without setting up an auditing mechanism upfront.

SQL Server does not store logon history anywhere, unless explicitly instructed to do so.