Here is something that worked on the test data.

create table #prod (pid int, name varchar(10), pdesc varchar(max) Constraint PK_Prod Primary Key(pid))

insert into #prod values (1,'prod1', null)

insert into #prod...

Sounds like you may have "parameter sniffing" going on. The following quote is from this thread: http://www.sqlservercentral.com/Forums/Topic226815-8-1.aspx

Snippit from this link

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx#EGAA

Compilations, Recompilations, and Parameter Sniffing

"Parameter sniffing" refers to a process...

Yes. In SSMS go to SQL Server Agent -> Alerts. Right-Click and select New Alert. In the Type drop-down select SQL Server Performance Condition Alert. Then...

Here is a query to get you the 3 closest stores for each customer:

Select TOP 3

S.store_id,

M.customer_id,

DistanceFunction(S.Lat, S.Long, M.Lat, M.Long) as distance

From

tblStores S Cross Join

tblMaster M

Where

DistanceFunction(S.Lat, S.Long, M.Lat, M.Long) <=...

Why not try replacing your subquery

(

SELECT

PARTY_ID

FROM

PARTY_LOGIN

WHERE

USERNAME = CURROW.USERNAME

) AS PARTY_ID_INITIATED

With a join

Select

....,

...

Activity monitor is just giving you a point in time snapshot while profiler will give you a pattern of locking behavior. You can also use Perfomance Monitor and the...

Add another to the list of those who have never heard of implicit\explicit stored procedures. Based on the fact that it is called a "stored" procedure I would think...

Matt Miller (4/2/2008)

---

Jack -

I'm hoping you're not including SSNS in the list? 'cause Notification services is going the way of the Dodo bird.... And that's not just...

Tim has misspelled the Group Policy edit it should be gpedit.msc. Here is a link to a an MS articel about this: http://support.microsoft.com/kb/918483

As long as there ar eno features in 2005 standard that are removed from 2008 standard I am fine with it, but as soon as they start removing features I...

Any kind of file copy going on during this time? How often is the data warehouse being loaded and how is the load done?

You can check out this thread...

You can also include the port in the connection string in the report data source like this server=192.168.1.43:2500.

In my experience the best way to bring data across from a linked server, especially in your situation when you are not joining between local and linked server, is to...

sys.sysdepends has the dependency information.

We can't see your XML because of the < and > in the code. You need to edit is to use the replacement text for them.

Do you...