Good article for Semi-Addtive measures in SQL Server (OLAP - SSAS)

http://www.databasejournal.com/features/mssql/article.php/3445761/Introduction-to-MSSQL-Server-2000-Analysis-Services-Semi-Additive-Measures-and-Periodic-Balances.htm

http://blogical.se/blogs/jahlen/archive/2009/09/16/unleashing-the-power-of-sql-server-enterprise-edition-part-1.aspx

How to monitoring Shrink Database / File in SQL Server

วิธีการ Mornitoring percentage ของการ Shrink database หรือการ Shrink file ใน SQL Server


select  T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)
                , R.cpu_time, R.total_elapsed_time, R.percent_complete
from    sys.dm_exec_requests R
                cross apply sys.dm_exec_sql_text(R.sql_handle) T

SQL Server , Generate scripts for INDEXS, Primary key

http://sqlsrvscrpt.codeplex.com/wikipage?title=DBScript%20Utility&referringTitle=Home&ProjectName=sqlsrvscrpt

Good tool for this case

Window 64 bit & Microsoft Visual studio , Connect to Oracle problem

Just run
start /B "C:\Progra~2\Microsoft Visual Studio 8\Common7\IDE" "C:\Progra~2\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"


Ref 1. http://www.sqlserverdba.co.cc/2008/12/error-in-initializing-provider-ora.html
Ref 2. http://www.sqlservercentral.com/Forums/Topic330866-150-2.aspx

How to drop all tables in SQL Server

Choose database you want to drop all table
and just run this script

  EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"