Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: CEMERLANG on November 06, 2016, 02:11:24 PM

Title: Hasil reindex
Post by: CEMERLANG on November 06, 2016, 02:11:24 PM

Coba reindex dapat ilmu dari Om E-Refill

USE otomax
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM
information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',95)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE
TableCursor

hasilnya seperti gambar dibawah apa normal? ada MSG 2501 nya (gambar lingkar merah)
(http://i1211.photobucket.com/albums/cc430/Lunamek/Reindex%20tabel%20mutasi_zpsls0u6k1l.jpg) (http://s1211.photobucket.com/user/Lunamek/media/Reindex%20tabel%20mutasi_zpsls0u6k1l.jpg.html)

Title: Re: Hasil reindex
Post by: H3RRY on November 06, 2016, 10:01:14 PM

Quote from: CEMERLANG on November 06, 2016, 02:11:24 PM

Coba reindex dapat ilmu dari Om E-Refill

USE otomax
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM
information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',95)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE
TableCursor

hasilnya seperti gambar dibawah apa normal? ada MSG 2501 nya (gambar lingkar merah)
(http://i1211.photobucket.com/albums/cc430/Lunamek/Reindex%20tabel%20mutasi_zpsls0u6k1l.jpg) (http://s1211.photobucket.com/user/Lunamek/media/Reindex%20tabel%20mutasi_zpsls0u6k1l.jpg.html)

versi otomax nya??

Title: Re: Hasil reindex
Post by: CEMERLANG on November 07, 2016, 06:31:25 AM

Quote from: H3RRY on November 06, 2016, 10:01:14 PM

versi otomax nya??

Otomax Versi Standard Om tp di casing komputernya Merk Ultimate, Power supply Merk Ultimate ;D ;D