NO replication, no open transaction.

I tried shrinking from database option, and also from dbcc shrinkfile. But when i tried using dbcc shrinkfile it gave me error "Cannot shrink log file...

1) Backup log with truncate only option.

2) Shrink the log using DBCC Shrinkfile

I exactly follow these steps, but my problem is file size is not reduced even after these steps.

Is...

i wont be directly inserting/updating c,

i will just insert/update a & b only.........

so i want the effect of insert/update in a & b automatically be appeared in c....

How can i...

What if A1 is not present in the query?

SELECT X1

FROM Temp

WHERE C1 = Value

does the "sort in temp DB" option of index effects sorting performance??

Its a dynamic search query.......and parameters are passed to this query using sp_executesql

the order by clause is .......order by serialnumber

serialnumber is column of License Table and is indexed (non clustered)

Thanks alot gail.....well i have already adviced the developer to modify this query just like the way you said........and now i m monitoring the results

Following is the most commonly used query.....

exec sp_executesql N'SELECT TOP 50

(SELECT TOP 1 Name FROM Product WHERE Id IN (SELECT CurrentProductId FROM LicenseProduct WHERE LicenseId = License.Id) ORDER BY ReleaseNumber,...

Actually there are multiple queries and most of the times they are dynamic.

But what is the best practice or general practice for creating indexes?seperate index on each column or...

Now here is an another finding.........the following problematic part of the where clause

...

I tried to move the two select subqueries in the FROM clause and join them there but then the returned rows were different.

Gail its sql server 2005, whats the weird...

The total ram is 8 GB

sql server can utilize uptp 7GB......minimum is set to default (i.e 0)....should i change this?

"Have you assigned Lock Pages in Memory privilege to sql server...

Memory Manager KB

------------------------------ --------------------

VM Reserved ...

Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790:...

@

"You might be able to get away with setting up a reporting copy of the database, where users can query this view, but where it won't interfere with OLTP operations...