WOuld this be what you want?

SELECT

[empno],

SUM(DATEDIFF(Month,[startdate],[enddate])) as tot

FROM test

GROUP BY [empno]

Hi again.

Could you give us an example of what the ouput should be?

Thanks

Chris

HI there,

Is this what you looking for?

SELECT

s.[empno] ,

DATEDIFF(minute,s.[startdate],e.[enddate])

,[startdate]

,[enddate]

FROM (SELECT MAX(Enddate) as Enddate, [empno] FROM test GROUP BY [empno]) e

INNER JOIN (SELECT MIN(Startdate) as Startdate , [empno] FROM test GROUP...

Glad to be of help 🙂

I'm not 100% sure on this, but I have seen a few people with problems similar to this.

A lot of the time it is down to something called "Parameter sniffing"...

Strangest question I ever saw.

Why do you even need teh table?

DECLARE @Loop INT, @Number INT

DECLARE @Loop2 INT

SET @Loop = 0

SET @Loop2 = 3

WHILE @Loop <= 7

BEGIN

...

Cool thanks

They all have Avg page of 1

So these I don't have to worry about then is that right 🙂

I must say thats you all, I have learn' more today...

The table only has 163 rows or so.

How would I tell how many pages it's using?

just want to say thanks again for all the help 🙂

HI All,

I just ran an index rebuild on a table and it still has a fragmentation of over 90%????

Anyone know why this is?

Thanks

Chris

THis pretty exciting stuff 🙂

Thanks for all the help everyone.

Whats cause index fragmentation?

Last question he he he

Does anyone have any good procedures for searching an entired DB for Index Fragmentation?

Thanks for the reply...

Looks like I might spend my afternoon rebuilding half the indexes on the server 🙁

as most are 66.66%

Also is this just simply a matter of manually droping...

Thanks Jack that is great help.

I'm going start reading up about indexes fragmentation now 😉

Grant,

Do you have any tips/advice on scripts that you mentioned above, that check indexes and fragmentation etc?

and how often you do this kind of thing on your system.

I'm just worried...

HI All,

I'm new to statistics and all that, but finding it interesting 🙂

Yesterday on our production system we had a query that ran like a dog however if I put...