It would be better to put tempdb in a separate drive. Then there wont be much Disk IO issues. Other than that, your idea seems pretty good.

Ah Yes Matt, you are right. Thats what happens when you start typing the query in without looking at it carefully:hehe:. My bad..

Glad that it worked for you. I got this info from one of the other Forum members.

You could use derived tables for each sum and do a left join.

Some thing like

Select Ix.D, a.FirstVale, c.FourthValue, d.FifthValue

from MainTable as x

Left Join

(Select Sum(Column1) from Table1) as a

on x.ID...

You can use row_number() over partition

select * from (select *, row_number() over (partition by Date order by Count desc) as num from ) as z

where num <= 3

Anotonio,

Your quick and dirty trick worked like charm..:)

Thanks Mate. 🙂

Roy

Thank You Ivan and Ian. I am glad you apreciate the article. It is very encouraging to get feed backs when writing articles.

Isnt this just an oversight from you?

One table has "Collect_Date" as column name and the other one has "CollectDate" as column name. So it will return that error.

Thanks Mike. Although I have around 12+ yrs of experience as DBA, I have only 3 yrs of experience in MS SQL. I was an Oracle DBA. So I am...

Thanks again for all the input. This is my first article. So it makes me happy that it is being read and is also being discussed. 🙂

I will have...

Drop Procedure dbo.sp_who5

go

/*******************************************************************************************************

** Name: admin.dbo.sp_who5

** Desc: Procedure to retrieve information about active sql connections

** Auth: Adam Bean

** Date: 12/10/2007

*******************************************************************************

** Change History

*******************************************************************************

** Date: Author: Description:

** -------- -------- ---------------------------------------

**

********************************************************************************************************/

CREATE PROCEDURE [dbo].[sp_who5]...

Hi All,

Thanks for all the input you have provided. Since you all read it it means I did something to make you think of different options that is possible.:)

Using of...

It might work for me, I have to check it. It was just a work around that I had for getting the Stored Proc name. When I go back to...

I just created a derived table for all the Union ALL statements and aliased as x.

(Select id, name from sys.sysobjects with (readuncommitted)

UNION ALL

Select id, name from testdb.sys.sysobjects with (readuncommitted)

UNION...

Adam Bean (1/25/2008)If I look at the results from the code above, the newly created sp_who5, it shows the contents of the procedure ... as a create statement instead of...