I am happy you got to the bottom of it. I try to call these out whenever I can, it's not a knock, just pointing out the preferred syntax for...

Is your system running NUMA of any flavor?

Does this yield multiple rows?

SELECT [type],

[name],

memory_node_id,

...

OK, so not by a schedule which means something or someone besides the Agent scheduler kicked it off.

Anything from this after adding your job name?

SELECT j.name,

...

Yes. As often as you have a maintenance-window to keep those indexes...

When you use INSERT INTO are you adhering to the requirements to achieve a minimally logged operation?

From Books Online INSERT (Transact-SQL):

Using INSERT INTO…SELECT to Bulk Import Data with Minimal Logging

You...

The queries are a little off in my environments too, with clerks being about 10-15% higher. All I can think of is that clerks are operating a lower level than...

I think we covered the OP's question about SELECT statements so I...

Define "breaks." Do you receive an error or does the package execution succeed but no data is present in the Excel file?

Just for clarity, msdb.dbo.sysdtspackages90 is where Pakages were stored in SQL Server 2005. In SQL Server 2008 they are stored in msdb.dbo.sysssispackages.

Here is a PowerShell script already written that needs...

npranj (2/28/2013)

---

Hi,

I am trying to create a temporary table. It will contain approx 25 million rows to start with and will increase in future.

I tried

Option1: SELECT col1 into #tempT...

Dung Dinh (2/28/2013)

---

Hi all,

I have a table Order with primary key ID column is uniqueidentifier data type on server B. Nightly, a synchronization job runs to synchronize orders from server...

Did you get it resolved?

A shot in the dark:

mssqlserver is the hidden instance name handed to default instances of some versions of SQL Server. Are you sure it...

If...

The 'SQL Plans' cache includes plans for both 'Ad Hoc' and 'Prepared' queries.

Check the owner of the job(s) in querstion. It may be owned by an SID that does not resolve to a valid login which could be giving SMO heartburn.

SELECT ...