using ROW_NUMBER is the classic way of finding/deleting dupes. Most do it with a CTE as the driver, which can be a bit easier for some to grok.

Nice dead-pan delivery there Jeff! hehehe

bitbucket has the better solution.

also, may I recommend you add a primary key to your table(s)?? 🙂

Avg Disk Queue Length is essentially useless in modern times where the IO subsystem is almost always NOT single-spindle based.

use avg disk sec/read and avg disk sec/write from...

1) use dbcc memorystatus to see what is really going on with memory usage. search online for info on that undocumented functionality.

2) As Gail says, lots of stuff outside...

MSDTC and linked servers are not inter-related. I note however that configuring DTC properly can be a real b-tch! Numerous articles online about problems and how to resolve...

shiv.kr.verma (11/25/2009)

I am executing query as follows

select top(1) city, state from city_state_finder where

freetext((city,state),'vancouver') and freetext((city,state),'on')

While executing this query response will not come as it's delaying the result without giving any...

You cannot rely on object dependency information kept by SQL Server. You must review every piece of source code you have to do what you ask.

There are SOOOOO many things that can cause performance problems. Have you checked for:

1) file IO stalls (virtual file stats DMV)

2) wait stats analysis?

3) blocking?

4) done query tuning? ...

Glad you have an (interim) fix by moving database Florian. 2 questions though:

1) why -g1024? I have never seen anyone use more than 512 there, and...

Make sure you read up on the interplay between clustering and mirroring.

Actually I HIGHLY recommend you get a professional in to help you evaluate your DR need and get...

That is my take on it.

simple answer since you gave us to little to go on is to us dynamic sql in your sproc which should get you exactly the same performance you would see...

it has been my experience that memory grants is one of the last things you should be concerned about. there are almost always huge amounts of low-hanging performance fruit...

1) first and most important recommendation: get a performance consultant in to help you analyze and improve the system in general and this query in particular. Especially work...