If an approximatve value is enough for you then this would give you what you want:

selectO.name,

rowcnt

fromsysindexes I join sysobjects O on O.id = I.id

whereindid < 2

andO.type = 'U'

order

byO.name

You can improve...

And why you are not changing the column delimiter to other character then a comma? like ; or TAB or | or what ever? You should choose such a char...

And in addition to Rudy's comment for table less then 8 pages there is no defragmentation done!

So you will never see any improvement for tables less then 8 pages

Nowadays in the schools they are not teaching the ascii representation of the caracters.

The bigger issue is with the non english speaking countries, like mine in Hungary where we have...

And why not to use some Kensington lock while working ina café?

I mean even in our own company by policy we have to lock our laptops where normally we should...

I have put the sp_ prefix because such kind of procs should be located in the master database as the purpose is system wide.

and as the sp_ type of procs...

the stored proc would look like :

create proc sp_kill @spid int

as

declare @sql varchar(50)

Set @sql = 'kill ' + cast(@spid as varchar)

exec (@sql)

and you can call like:

sp_kill...

Have a look on this : http://www.sqldev.net/xp/xpsmtp.htm

I'm using a lot and it works fine for me.

Bruno,

I'm doing some geocaching. But I'm not the fanatical one who is getting out in any wheather condition.

In Hungary where I'm living there is quite a lot of geocachers.

Rudy,

It make sense to have NULL values in a clustered index. Especially when the index is an a date field and I'm doing reange selection based on this date field....

Hi Karl,

Do you know how I can verify it. I suppose also that the data is organised as you told me, but I would like to "see".

I didn't find it...

Here is what I'm talking about.

And this is a "small" SAP implementation of ours

DBCC SHOWCONTIG scanning 'sysobjects' table...

Table: 'sysobjects' (1); index ID: 1, database ID: 5

TABLE level scan performed.

- Pages...

You cannot defrag them.

I've exactly the same issue.

I'm running SAP on my SQL box, having over 200,000 rows in sysobjects table + sysindexes etc.

I have been discussing with Micrososft about...

I have no problems with Identity. I'm using it fairly often.

The Only thing you have to know is, that you cannot remove it once set (no alter table command is...

Basically the Count(*) wont be any faster as long you have an index on it. That's it.

Use Count_big, if the number of row is high.

Run updateusage regularry because this is...