Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: MS SQL 2000 Performance / Hardware

    Delphi
    by shmia, 23. Mai 2006
  Prüfe doch mal, ob alle Tabellen einen Clustered Index haben!!
  CREATE VIEW dbo.vwNoClusteredIndex
  AS
  SELECT
  FROM dbo.sysobjects so
  WHERE (NOT EXISTS
  (SELECT si.id
  FROM sysindexes si
  WHERE indid = 1 AND si.id = so.id)) AND (type = 'U')
  ORDER BY name