Author Topic: Hasil reindex  (Read 2638 times)

CEMERLANG

  • User OtomaX
  • Sr. Member
  • ****
  • Posts: 1,075
Hasil reindex
« 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)
« Last Edit: November 06, 2016, 02:23:26 PM by CEMERLANG »
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

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 150
  • ACTion reload
    • www.actionreload3.com
Re: Hasil reindex
« Reply #1 on: November 06, 2016, 10:01:14 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

  • User OtomaX
  • Sr. Member
  • ****
  • Posts: 1,075
Re: Hasil reindex
« Reply #2 on: November 07, 2016, 06:31:25 AM »
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