do your tables have clustered indexes?

I am not aware of anything that tells you an actual date when a rebuild was run, but if rebuild has been run then the statistics will also have been...

Steve Jones - Editor (12/13/2009)

---

A deadlock needs two sessions, and it needs multiple objects being accessed. AFAIK, if each person ran a single query you could not have a deadlock....

ah, have i misunderstood it, it matters when you have more than one query within a transaction?

--run in context of db you want size info for

declare @dbname sysname

SET @dbName = DB_NAME()

-- Create a temporary table to store the DBCC SQLPERF results.

...

If you are creating temp tables and loading large amounts of data into them that activity into tempdb has to be logged, hence the growth in the tempdb transaction log....

Its a moot point as to whether you consider deadlocks a performance issue (I would) but should there not at least be consistency in the order objects are accessed to...

I would agree that you should not be connecting to SQL with the sa account, or the windows account the SQL service runs under for that matter, but as someone...

you need to set the correct default database, correct default language and reassign any server level permissions (sp_addsrvrolemember)

You would be better off using sp_help_revlogin. then the code you posted, there...

DB in simple mode?

no full backup taken yet?

for my money the latest cumulative hotfix you should apply after SQL 2000 SP4 is rollup 2187 - the file is called 266223_ENU_i386_zip.exe

you should then apply security hotfix MS08-040 which...

If its a one off you may as well use the gui, that way its never in clear text on the screen.

You wont have to change the service account or...

because you have specified detailed you are getting the non-leaf levels of the index as well. return the index_level column as well or use LIMITED.

fragmentation of non leaf nodes wont...

Must mean in relation to AWE or even possibly 64bit

see

http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

though I note this is in the SQL 2000 forum, so note AWE is not dynamic for SQL2000 and available in...

jts_2003 (12/9/2009)

---

This reminded me of something that has been puzzling me recently about clustered indexes. If the leaf level of a clustered index actually is the table's data itself, does...