In which case, changing your WITH(NOLOCK) hint to WITH(TABLOCK) may enable the operation to be minimally logged.

Obviously this depends on whether you can afford for the operation to lock...

This sort of thing is mainly dependent on I/O throughput, although there may be an opportunity to make it minimally logged with some changes (NOLOCK will definitely prevent this as...

Can a productID exist multiple times for a single SaleID? If not, you could do something like the below:

SELECT SaleID FROM #SalesDetails sd

INNER JOIN #ProdList ON sd.ProductID = #ProdList.ProductID

GROUP BY...

...rewrite the update as a set based operation rather than a cursor. The performance of cursors for this type of work is unnecessary and dog slow.

We can't tell you how...

There's no built in utility to do this. You'd either have to use a 3rd party application or write your own one (e.g. in .Net)

Ok....So where does that say anything about DENY? Revoke's entirely different

A couple of things:

1:) If you're using Microsoft OLE DB Provider for Oracle, you're not using the OLEDB driver from the 11g Client Install - that will be called something...

If you have Enterprise Edition, Resource Governor can do this.

Steve Jones - SSC Editor (5/5/2011)

---

I see this talked about often, but not real testing being done. Now that we have lots of x64 systems, and the 2/4GB RAM limits...

SARGability is the first thing to look for when you think you have a suitable index that isn't used. Once you can see there are no functions etc. being used...

RecordKey is a char(18), but you've defined it at nvarchar(18) in your temp table. This is probably preventing an index seek

Can you post DDL including index definitions for dbo.Transactions and dbo.Company?

I can't find any official articles that suggest denying access to the public group. The BOL article says to DENY CONNECT ENDPOINT to the EVERYONE group, which is different. I...

The lists of deprecated/discontinued features for SQL 2008 are linked from here:

http://weblogs.sqlteam.com/derekc/archive/2008/06/06/60618.aspx

You'll also have to consider SQL 2005's versions of the same lists as you're jumping two versions.

No, there's no...

I doubt it's 100% perfect, but in that specific example, it's deprecated rather than incompatible, so it will work if the compatibility of the database was still set to 80...