Columnstore Index

http://msdn.microsoft.com/en-us/library/gg492088.aspx

Should I use a #temp table or a @table variable?

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

SQL Fiddle

http://sqlfiddle.com/

Compare 2 tables are equal in SQL

Reference:

http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

SQL window function

Just read the SQL cookbook and learn userful sql windows function.

Over()

http://msdn.microsoft.com/en-us/library/ms189461.aspx

NTILE

http://msdn.microsoft.com/en-us/library/ms175126.aspx

TSQL Date and Time function

http://msdn.microsoft.com/en-us/library/ms186724.aspx

WITH common_table_expression (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms175972.aspx

See a good list of SQL tutorial while googling:

http://www.databasejournal.com/article.php/3649246

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005146s-Ranking-Functions-150-NTILE-and-ROWNUMBER.htm

SQL optimization

http://www.techartifact.com/blogs/2009/12/sql-optimization-tipsquestions.html

http://www.databasejournal.com/features/mssql/article.php/1437391/Transact-SQL-Optimization-Tips.htm

http://www.sql-server-performance.com/2006/tuning-joins/2/

Error Handling in SQL 2000 – a Background

http://www.sommarskog.se/error-handling-I.html

http://sharedderrick.blogspot.com/2010/04/sql-servererror-log-file.html

SQL Server Date Formats

Here is a table for SQL Server Date Format:

http://www.sql-server-helper.com/tips/date-formats.aspx

多db record 處理情況

今日試左兩個好多record 既database table，基本上一join 就會load 太長時間timeout

同埋用左好多以前無寫既野，好似

1. declare variable

2. temp table

@tmptable, @@tmptable, #tmptable 既分別

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

How to add sequence number within groups of repeating values

Read this:

http://www.tek-tips.com/viewthread.cfm?qid=859372

sql 2000 problem

Warning: The table 'xxx' has been created but its maximum row size (8707) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Oracle Special Table - Dual

Oracle:

Dual is a special table with a garbage cell which is used for our queries.

For example,
select seq.nextval from dual

SQL Server Import and Export Wizard

http://msdn.microsoft.com/en-us/library/ms188032.aspx

SQL Server Integration Services
http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx

SQL Server Integration Services

http://msdn.microsoft.com/en-us/library/ms141026%28lightweight%29.aspx

Select 30% of records randomly in SQL Server

select top 30 percent * from [table_name] ORDER BY NEWID()

select 30% of records of last month

select top 30 percent * from[table_name]
and DatePart(""m"", date_created) = DatePart(""m"", DateAdd(""m"", -1, getdate()))
AND DatePart(""yyyy"", date_created) = DatePart(""yyyy"", DateAdd(""m"", -1, getdate()))
ORDER BY NEWID()

Mysql Workbench

http://dev.mysql.com/doc/workbench/en/wb-basic-add-table.html

Generate ‘INSERT INTO’ scripts in MS SQL Server

http://vyaskn.tripod.com/code.htm#inserts

http://stackoverflow.com/questions/422847/are-there-any-free-tools-to-generate-insert-into-scripts-in-ms-sql-server

EXEC sp_generate_inserts 'TABLE NAME'

TSQL Union and Union ALL

Union will select distinct values where Union ALL will not

Top 10 steps to optimize data access in SQL Server

Top 10 steps to optimize data access in SQL Server
Part I:
http://www.codeproject.com/KB/database/OptimizeDBUseIndexing.aspx
Part II:
http://www.codeproject.com/KB/database/RefactorTSQLs.aspx
Part III:
http://www.codeproject.com/KB/database/IndexAndDenormalize.aspx