Well, if users forgets to use a where clause, chances are that they will forget to use ROWCOUNT (or TOP) as well.

Thanks, anyway.

What do you mean?

Thank you all for your suggestions.

I was also thinking about using triggers but I don't want to create a trigger for each table in the database. It's not that it...

David,

Here is more information:

select create_date from sys.databases where name = 'tempdb'

2008-08-19 15:12:27.390

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

9.00.3042.00SP2Standard Edition (64-bit)

What do you think?

dm_db_index_physical_stats shows page_count of 411689, 70779, 0 and other values.

sp_spaceused gives the following results:

database_size = 16813.50 MB

unallocated space = 4393.73 MB

reserved = 12615696 KB

data = 12597272 KB

index_size = 3976 KB

unused...

When I try to run sp_spaceused it says that the table does not exist in database 'tempdb' or is invalid for this operation.

Now, some of the tables are from Sep-2008....

I'm jumping into this (closed?) discussion because I have a similar problem: Big tempDB, some old temp tables.

When I run:

USE tempdb

SELECTid, OBJECT_NAME(id), rowcnt, o.create_date, o.modify_date

FROMtempdb..sysindexes i

JOIN sys.objects o ON i.id=o.object_ID

WHEREOBJECT_NAME(id)...

Thanks David.

Perry,

Do you know what is the latest MDAC?

Thanks,

Luiz.

What about Win98?

Would there be a problem? I know Express 2005 won't run on Win98, but only the client is in Win98 (SQL 2000 client)

Thanks,

Luiz.

Some time ago I had the same challenge and wrote a script for this.

Take a look at http://www.sqlservercentral.com/scripts/Compatibility/62093/

Note that If the problem is inside of a dynamic SQL...

David Griffiths (7/11/2008)

---

Thanks for 2 prompt replies.

My point about having the SELECT in its own transaction was that I wasn't doing a SELECT in a transaction where a previous UPDATE,...

Would you guys share some real examples where you stop using functions in order to increase performance? I mean, could you share the function code and the SQL statement code...

Matt Miller (1/23/2008)

---

The other place not yet mentioned where this gets even more important to consider is when you use a table-valued function within a CROSS APPLY clause. It's...

Thank you for your answers.

As pointed, http://www.sqlservercentral.com/Forums/Topic446308-360-1.aspx covers this issue. I'll add my new questions to it.

Luiz.