Using a base table versus a # temp table will help if your tempdb is either being hammered on, or is badly fragmented.  If you're using a lot of #temp...

Well - it all seems to depend on how much you plan on using it and/or how big of a dataset we're talking about.  In defining the XML data source,...

Have you considered dumping the subquery results to a separate table, preferrably indexed (or dump to it first, then index), and run the outer query based on the new table?

It...

Query analyzer might be the quickest way to do this.

Open up QA, and use the object browser to find the SP.  Right-click on it, and pick "Script into new window...

Check scheduled DTS packages.  If they involve outside data sources and you're using SQL server logins, you might see that type of entry.

encapsulate whatever you're doing in a transaction, and then use a locking hint to prevent updates. 

UPDLOCK looks like the one, and be sure to specify to do it at...

SELECT <columns>  FROM CompanyCategory WHERE CategoryID in

(select companyid from CompanyCategory where categorid in (<all categories you want&gt having count(distinct categoryid)=<count of categories you want&gt

A few comments:

• if the purpose of this copy is to fill in default values - why not use the default value property of the various fields?
• your primary key is by...

Is the database trying to grow during that time? 

I've had this happen before.  It did have something to do with the clustered index in my case.

Keep in mind that the clustered index determines how the data is stored...

To build on peter's example from before:

Set @sql=' SELECT '+ @fiyatgrup+'*'+ @fiyatgrup+'Brm' result FROM dbo.GenelSFiyatlari'+

  ' WHERE UrunID = '+@urunid+' AND...

I might be missing something, but it seems to be that the outer GROUP BY and aggregate function isn't needed.  Your subquery already seems to be summarizing things to return...

I'll pass on a bit of wisdom someone gave me a while back when I was ranting about some of my customers....

"The pay's the same"

As long as the paycheck continues...

Now - I can't address why it works in some places and not others - but that error usually is data-conversion or collation-related.  like taking oracle date fields and shoving...

Well - do what you will while you're learning.  That's how you learn after all

what I think he was getting at is that you're...