Please post the actual execution plan and all involved table definitions including indexes and constraints.

My pleasure. Thanks for the feedback.

I didn't quite get your comment. Are you stuck? What can I help with?

OK, AWE is disabled (the default) so the largest your SQL Server buffer pool will ever see is somewhere between 1.5GB and 1.6GB. This is due to the 2GB limit...

You can run the query against any database as it refers to System Views that are available in any database and they report instance-level data, not data for a specific...

Good deal. Happy you found a way forward. If you don't mind posting your .NET code others may benefit from it down the line. I am also curious to see...

Is the client app using the SQL Server Native Client? If so you might be able to trace activity that way:

Tracing SQL 2008 SNAC

I am not sure if the same...

peterzeke (2/20/2013)

---

The following question is based on my zero-understanding of how SSIS performs regarding the use of server memory.

Does someone know if a SQL command in an OLE DB source...

Are you open to using PowerShell? This could be done in a single line.

Run this at a PowerShell prompt and you'll see how simple it is to identify which files...

SQL Server Database Mail does not actually send the email directly to a recipient, it sends it to an SMTP relay. If the database server can reach an SMTP relay,...

What about an email? You do not have to be connected to the internet to send an email.

It is sent using the Alerter Windows service and is received by the Messenger Windows server. The Messenger service is no longer enabled available in newer versions of Windows, and...

Let's make that link an actual link:

http://support.microsoft.com/kb/923247

The article Gail linked to above has a more "to the point" explanation of why these values can exist in your database, just search...

I could take a guess at what you want and I might nail it but I might not. So in the spirit of getting you some tested code in an...

fasttrack (2/20/2013)

---

SQL Server 2005 Enterprise Ed,

Hi guys,

I have the following issue:

There are some jobs running successfully. The execution is reported in the "Job Activity Monitor" highlighting the "Last execution" and...