News:

Selamat datang di Forum Orisinil!

Main Menu

Hasil reindex

Started by CEMERLANG, November 06, 2016, 02:11:24 PM

Previous topic - Next topic

CEMERLANG

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)
OS Tinux Blankon
Turbin 10.000 Watt kuat 1 Bulan
Versi Mini and Sexy
Koneksi : SPIDOL, INDIEHOY, CERMATPRET, TLETHONGSEL
Lain: Embuh rareti Mumet :D

H3RRY

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)


versi otomax nya??
otomax aseli
pontianak,kalimantan barat

CEMERLANG

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
OS Tinux Blankon
Turbin 10.000 Watt kuat 1 Bulan
Versi Mini and Sexy
Koneksi : SPIDOL, INDIEHOY, CERMATPRET, TLETHONGSEL
Lain: Embuh rareti Mumet :D