How can I view jobs in Management Studio when SQL Server Agent is stopped? Currently, it says SQL Server Agent (Agent XPs disabled). Is there a way...
Was wanting some input on the use of schemas for applications. Basically, I have a database with all of the tables used in our data warehouse....
Recently we upgraded our developement box from SQL 2000 to 2005. We are now experiencing a large increase in query cost when the Lazy Spool is used....
I have found that writing a regular select expression with a where clause against the linked server has a different execution plan from an OPENQUERY....
How do you find out the status of a particular job? In SQL 2000, I would simply go to SQL Agent, and the click on jobs. It would like all of the...
Separate names with a comma.
