To get parallel processing to work, I think you will either have to combine all your queries into one with something like UNION ALL, or write an async CLR SP.

Also,...

Use the ROW_NUMBER() function to work out which row the information should be on.

Also, PIVOT tends to be more readable than lots of CASE statements.

Try something like:

SELECT SYear, SWeek

,[2] AS...

The problem may be that all 1.3 million rows are being sent to the MSSQL instance before the filter is applied.

This could take a long time on a slow link.

Try:

1....

On the limited amount of informaton provided, it is difficult to say how to improve the performance.

The main problem is the CHARINDEX(@query, a.account) > 0, or the equivalent a.account...

On looking at it again, maybe the following:

SELECT

CASE

WHEN N.N = 1

THEN 'FreeSpace'

ELSE 'UsedSpace'

END AS Measurement

,CASE

WHEN N.N = 1

THEN FreeSpaceMB

ELSE UsedSpaceMB

END AS SizeInMB

FROM

(

SELECT FreeSpaceMB, UsedSpaceMB

,ROW_NUMBER() OVER (ORDER BY EntryDateTime DESC) AS...

I am not sure what you are trying to do. If you want the latest information for each drive then try something like:

SELECT fkServerID, DriveLetter, FreeSpaceMB, UsedSpaceMB

FROM

(

SELECT fkServerID, DriveLetter, FreeSpaceMB,...

Some of the code here may help:

http://www.sqlservercentral.com/articles/SQL+Server+2008/66554/

As you have an aggregate function on OrderDate it does not make much sense to have it in the GROUP BY clause.

Try:

GROUP BY I.ProductID, I.Description, I.UnitsInStock, I.UnitPrice, I.Expires--, O.OrderDate

Edit: Using...

As you have not raised an error or returned within the CATCH block I think the code will continue to execute.

(Edit: This will depend on what XACT_ABORT is set to.)

Try...

netguykb (2/2/2010)

---

NO IDEA How to do this. Here is what I have so far and I know this is not right considering the where clause is only allowing me to...

If you do not have access to the application code, you could look at using a trigger to clean the data as it was being saved.

You may also find this thread useful:

http://www.sqlservercentral.com/Forums/Topic754864-169-1.aspx

With inner joins where the filter is applied seems to make no difference. The optimizer generally sorts...

You may want to redesign your schema.

With your current schema, something like the following may work:

SELECT dCats.[NAME]

,refTable.[Id]

,'Default' AS CatType

FROM tbl_categoriesRefTable AS refTable

JOIN tbl_defaultCategories AS dCats

ON dCats.defaultCategoryId = refTable.defaultCategoryId

AND dCats.universityId =...

ALTER TABLE dbo.docfol

ADD CONSTRAINT FK_folderid_folder

FOREIGN KEY folderid

REFERENCES dbo.folder(folderid)

GO

ALTER TABLE dbo.docfol

ADD CONSTRAINT FK_docid_document

FOREIGN KEY docid

REFERENCES dbo.document(docid)

GO