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...
quote:Originally posted by Adriaan It's not really a bug in the engine, as much as probabilities within a given set of data. As the data set...
SQL Server 2005 seems to have a bug in the database engine when using the NOT IN clause. I have many examples where the new server that we purchased...
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....
Microsoft does not have a 64 version of the OLEDB provider for Oracle. You will have to use the 64-bit Oracle Provider for OLE DB. According to...
quote:Originally posted by Adriaan On the old server, did you have the "Auto update statistics" and "Auto create statistics" options activated? Or...
quote:Originally posted by Adriaan Does the plan change if you use ... FROM CRMOrderActionsHistory A LEFT JOIN CRMMACSOrderActionsHistory B ON...
It now takes roughly 7 hours to execute that statement in SQL Server 2005 compared to 15 minutes in 2000. That is why I'm worried about the cost...
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....
No. Simple selects from a single table.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
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....
I was able to completely unistall SQL 2000 and then install SQL 2005 and attach the databases without any issues. I did detach them before...
Could anyone point me to a place that could help with questions like this?
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...
Remember that when you run a DTS package locally, it actually executes on your own PC using your security and DSN settings. When the job runs out of...
We've been using the SELECT INTO statement actually because it doesn't have the logging hit that an INSERT has.
Our data grows daily, but we saw a 50% improvement if not more.
We found that in our data warehouse, rewriting of scripts to avoid cursors actually decreased the amount of load time each day. We have taken the...
We are running a Proliant DL740 and it appears that we also have a Emulex LP950 adapter. We plan on installing a Firmware update in the near future,...
Separate names with a comma.
