SQL Server Performance Tips: Rebuilding Indexes

[red_dr4gon7]

Ya iyalah.. Wong nama database nya aja gak dirubah gmn mau eksekusi, hahaha..  ;D  :D

[zurigh]

tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D

[AE_Reload]

Ya iyalah.. Wong nama database nya aja gak dirubah gmn mau eksekusi, hahaha..  ;D  :D

udh di rubah jg sama bos,  ;D ;D

kasih contoh dong

[fadlyfayruz]

tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D

1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

USE otomax --Enter the name of the database you want to reindex

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,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D

[farhancellular]

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


berhasilkah klo hasilnya begini???

[deydi]

tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D

1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

USE otomax --Enter the name of the database you want to reindex

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,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D

setelah di coba hasilnya seperti ini :

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


apakah hasil diatas kita save atau diabaikan saja?

[Yusuf]

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


berhasilkah klo hasilnya begini???

itu berhasil bos.

[centerpulsa]

SAYA uda coba seperti nya mmg agak cepat pada saat membuka otomax nya,hihihihi

[zurigh]

tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D

1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

USE otomax --Enter the name of the database you want to reindex

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,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D

tinggal testi kalo gini.. hatur tengkyu om bajay  :-* :-*

[zurigh]

MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D

[spiderbooo]

 ;D iya nih bos,yg berasa banget dimananya sih..?
Kl saya,berhubung baru,jd database masih sedikit..waktu blm di rebuilding,ukuran database sekitar 70MB..setelah di rebuilding,kok jadi 90MB ya..?

[zurigh]

ayooo siapa yg bisa kasi tau yg paling berasa di bagian yg mana ;D :D :D

[VIOLET CELLULAR]

MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D

paling bersa klu kita udah diujung tanduk oowwwwwhhhhh sungguh nikmat MANTAB  ;D ;D ;D ;D

[zurigh]

MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D

paling bersa klu kita udah diujung tanduk oowwwwwhhhhh sungguh nikmat MANTAB  ;D ;D ;D ;D

malah bnr2 kesitu jwbanya :D :D

[Yusuf]

;D iya nih bos,yg berasa banget dimananya sih..?
Kl saya,berhubung baru,jd database masih sedikit..waktu blm di rebuilding,ukuran database sekitar 70MB..setelah di rebuilding,kok jadi 90MB ya..?

dishrink aja bos... ada menunya di sql studio...

[zurigh]

dishrink aja bos... ada menunya di sql studio...

kalo di shrink nya di tab menghapus data sama ga  ???

[titanium_ponsel]

kok punya sy respon nya begini ya???

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The statement has been terminated.
Msg 1105, Level 17, State 2, Line 14
Could not allocate space for object 'dbo.SORT temporary run storage:  458229543075840' in database 'Otomax' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

[BOMB]

benar2 terasa jd cepat aksesnya

[falcon]

Untuk melakukan Shrink via SQL
otomax>Tasks>Shrink...    Pada SQL Studio Express ada 2 pilihan Yaitu database sama file dan yang menjadi pertanyaan saya apakah ke-2 pilihan tersebut yg dilakukan apa salah satu aja............ ??? ??? ???

[epro reload]

Nyimak aj aahh... db ku masih dikit.... belom banyak kaya konco2 disini.... jadi malu... :-\ :-\ :-\ :-\