SQL Server knowledge center - All Comments

re: How to get clustered index information with DMV in SQL Server 2005

HARRY — Wed, 25 Jun 2008 07:10:44 GMT

MAS.SAYA MAU TANYA BGAIMANA CARA MENGIMPLEMENTASIKAN COST BASED OPTIMIZATION DI MYSQL

re: SQL Internal Viewer Tool

Kasim.Wirama — Mon, 23 Jun 2008 00:51:12 GMT

sama-sama :)

re: SQL Internal Viewer Tool

Irwansyah — Sun, 22 Jun 2008 10:05:38 GMT

Kayaknya keren nih! Thx atas infonya man ;-)

Decorrelating Correlated Subquery | Freight News

Decorrelating Correlated Subquery | Freight News — Sun, 22 Jun 2008 05:31:56 GMT

Pingback from Decorrelating Correlated Subquery | Freight News

re: Execution Plan for Noncorrelated Query

aiska — Tue, 17 Jun 2008 09:52:17 GMT

good explanation.

Thanks

tapi klo pake bahasa indonesia mungkin lebih banyak orang yang akan paham

re: Indexed View for Performance Enhancement in SQL Server 2005

mybrainsgrowell — Tue, 10 Jun 2008 23:23:33 GMT

saya pake sql server 2005 standard, OS WIndows XP,

step2nya:..

nyoba query sebelum ada view, trus bikin view + indexed view, trus nyoba query yg sama, dan logical readsnya sama, sepertinya view nya belum dipke. apa perlu dipaksa?

kalo saya coba select * from view with(noexpand) dapet logical reads 84.

re: Indexed View for Performance Enhancement in SQL Server 2005

Kasim Wirama — Tue, 10 Jun 2008 02:51:02 GMT

bisa dijelaskan step2 yang sudah dilakukan dan versi sql server yang dijalankan?

Terima kasih.

Kasim Wirama

re: Indexed View for Performance Enhancement in SQL Server 2005

mybrainsgrowell — Mon, 09 Jun 2008 03:42:47 GMT

saya mencobanya, tapi logical reads sama saja. tetap 703. apakah ada yang salah?

Menampilkan Query Yang Berjalan Paling Lama Melalui DMV

SQL — Thu, 05 Jun 2008 06:38:29 GMT

Berikut adalah cara menampilkan query yang berjalan paling lama melalui DMV (Dynamic Management Views

re: Study of Stream Aggregation

Kasim.Wirama — Mon, 02 Jun 2008 09:46:47 GMT

About rewind and rebinds? no, it isn't. I will let you know about rewind and rebind discussion. You're welcomed.

regards,

Kasim Wirama

re: Merge Replication in SQL Server 2005

Sun, 01 Jun 2008 00:55:20 GMT

ted

re: Study of Stream Aggregation

Rangga Praduwiratna — Fri, 30 May 2008 16:46:24 GMT

Good article. Anyway, is this article that you meaned later in SQL Server User Group Indonesia milis? Good post, I'm still collecting and learning about join function and other T-SQL languange in SQL Server, since I'm still weak in SQL Server Programming. Thanks again!

Regards,

Rangga P.

nested join

nested join — Thu, 29 May 2008 23:07:11 GMT

Pingback from nested join

3gb switch in 64 bit system

3gb switch in 64 bit system — Tue, 27 May 2008 12:52:12 GMT

Pingback from 3gb switch in 64 bit system

date and privilege level error

date and privilege level error — Tue, 27 May 2008 11:08:09 GMT

Pingback from date and privilege level error