what are Query optimization techniques ?

I get the following error:

I have looked at this KB fix, but we are a newer version then in that article:
http://support.microsoft.com/kb/945896

Also found this post with a similiar issue, but no solution:
http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/4a78ddbd-c6f0-44a7-8c54-36d63440a3fd

Before I call Microsoft Support I thought I would try here first.

I am trying to run a stored proc that basically needs to parse xml messages coming from an outside datasource.  We are using SQL Server 2005 SP3 (9.00.4053.00 SP3 Standard Edition).  This datasource is an old pervasived database with not the best data model.  So what we wanted to do was pull the raw data as is into a staging table and then convert it to a better data model in our ODS.  There are around 300 columns in this table and I have a generic process that pulls the rows out and converts to XML and saves to a working table (this

I have the MDX query below that intermitantly takes forever to execute. Sometimes it runs in 10-20 seconds...others, 7-10 MINUTES! I am new to MDX, so I am not sure what I need to do to optimize the execution. The end result is typically only a few hundred rows of data.

Here's the query. I captured this using the Profiler from a SSRS report which is feeding the StrToSet functions with parms selected by the user.

WITH 
 MEMBER [Measures].[QtyRTS] AS 
  IIF
  (
   [Measures].[Molding - Cases RTS] = 0
   ,[Measures].[Molding - Quantity RTS]
   ,[Measures].[Molding - Cases RTS]
  ) 
SELECT 
 {
  [Measures].[QtyRTS]
  ,[Measures].[Molding - Quantity RTS]
  ,[Measures].[Molding - Quantity Made]
  ,[Measures].[Molding - Mach % Std (Schd Hrs)]
  ,[Measures].[Molding - Mach % Std (Run Hrs)]
  ,[Measures].[PID Labor - Labor Efficiency %]
  ,[Measures].[Downtime Hrs]
  ,[Measures].[Scheduled Hrs]
  ,[Measures].[Downtime (% Schd Hrs)]
  ,[Measures].[Run Hrs]
  ,[Measures].[Unknown Availability Hrs]
  ,[Measures].[Scrap - Scrap (% Made)]
  ,[Measures].[DMR - Quantity Rejected]
  ,[Measures].[DMR - After Rework Rejects]
  ,[Measures].[OEE %]
  ,[Measures].[OEE - Availability %]
  ,[Measures].[OEE - Performance Rate %]
  ,[Measures].[OEE - Yield %]
 } ON COLUMNS
 ,NON EMPTY 
  CrossJoin
  (
   [Dim Product].[Product - Family Name].MEMBERS
   ,[Dim Resources].[Machine].MEM

Hi

need some help on optimizing my query below. I wanted to do here is put more weight on other resulting items besides documents. Are there any improvement / points /performance optimization to the query?

SELECT "PageMap", "Filename", "Title",  "Created","LastModifiedTime","Author","Path", "Contentclass", "Description", "Rank" ,"ContentType","ContactsM","ContentE","IsDocument" FROM Scope()
WHERE 
(
(
CONTAINS("PageMap",'"*{0}*"') RANK BY WEIGHT ( 0.90 ) OR
CONTAINS("Title",'"*{0}*"') RANK BY WEIGHT ( 0.20 ) OR
CONTAINS("ContactsM",'"*{0}*"') RANK BY WEIGHT ( 0.20 )OR
CONTAINS("ContentE",'"*{0}*"') RANK BY WEIGHT ( 0.20 )
)

AND

(
PageMap Is NOT NULL RANK BY WEIGHT ( 0.90 )
AND
(
ContentType='Contacts' OR
ContentType='Content Editor' OR
ContentType='text/html'
)
)
)

OR
(
  (
   FREETEXT("Title",'"*{0}*"') RANK BY WEIGHT(0.20) OR
FREETEXT("FileName",'"*{0}*"') RANK BY WEIGHT(0.20) OR
FREETEXT("Contents",'

Hi i have a SP which will pull the Data  and another SP to organize that Data into proper format to fit my front end application reports.

below is the SP that we use to do formating the resultset form the original SP

00000000000

Can Some one optimize this SP, i dont to use the while loop coz i have 18 such SP's and i cant do it in all the SP.

Can we get this kind of out put by using a regular query

Thx

 Hi ,

        How to optimize sql query in sql server 2005, any idea
 

Hello....

I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??