create function dbo.mymax (

@i1 int ,

@i2 int = null ,

@i3 int = null ,

@i4 int = null ,

@i5 int = null ,

@i6 int = null ,

@i7 int = null ,

@i8...

when you use EM to order columns inside a table, it creates a new table with desired structure, moves your data to that table, drops the old one, and rename...

So may be you don't care about the values in next 2 columns. or their relation with the phone number column. you may want to revisit you table designs.

try...

If you are sure that the plan on your good server is always right to pick up, you can force that using SQL 2005 Plan Guides. Checkout BOL for that....

Check the default database selected in your connection. may be your connection is lying in master db. and hence not showing you procs from your own database.

not able to get your  requirement. if there are 10 records in table, with 3 distinct phone_numbers, how your results should look ??

can you put an example of what you...

on 64 bit, I would recommend you to give "lock pages in memory" right to your SQL Server service account. (Local Security Policy -> Local Policy -> User Rights Assignment...

I dont think tempdb usage has anythign to do with your procedure context question.

I am aware of an issue with SQL 2005 tempdb and temporary tables cleanup. The fix is...

see http://support.microsoft.com/?id=281642 if it is applies to you.

if so, you could take a msdb backup ( for safety ), and then

UPDATE sysjobs SET originating_server =  @@servername

WHERE  originating_server...

1. consider running the procedure normally once. capture a profiler trace (with tunning template). Pass the trace as a worload to tune to the DTA.

2. Replace #temp with a normal...

Try this approach

1. on your centralized monitor server, create a linked server pointing to each server that you want to monitor.

2. Write a simple procedure that accepts a tablename...

andy,

I have my answer ready. How do i send it to you? (I need email id)

I want my points back, as my answer is 100% correct...

Slightly more optimized statement ....

SELECT LowerMissing,  UpperMissing , q.UpperMissing - q.LowerMissing + 1 TotalMissing FROM

(

   SELECT  A.Id + 1 LowerMissing , (SELECT MIN(Id ) FROM MyTable  WHERE Id ...

does this help you ?

create proc sp1

as

begin

CREATE TABLE #who (

 spid int primary key,

 ecid int,

 status varchar(30),

 loginame varchar(128),

 hostname varchar(128),

 blk int,

 dbname varchar(128),

 cmd varchar(16)

)

insert into #who

exec...