@manhnguyenv

Welcome to my blog!

Sql Advanced Tutorials

July 30, 2019 17:36

SQL Server Advanced Tutorials (edit)

  • Indexes
  • Partition Table
  • Grouping

Ways to improve T-SQL

https://www.sqlshack.com/3-ways-to-improve-t-sql-performance/

  • MAXRECURSION
  • Temporary Table
  • Table with CTE
  • UNION | UNION ALL

Poor SQL Query ?

https://www.sqlshack.com/poor-sql-query-design-sql-query-performance-killer-basics/

Query Optimizer ?

https://www.sqlshack.com/inaccurate-sql-server-statistics-sql-query-performance-killer-update-sql-server-statistics/

SET command ?

SET STATISTICS io ON
SET STATISTICS time ON
GO

Huge Data (INSERT HUGE)

https://dba.stackexchange.com/questions/188667/best-database-and-table-design-for-billions-of-rows-of-data

https://www.sqlshack.com/understanding-database-backup-encryption-sql-server/

https://www.sqlshack.com/sql-server-cursor-performance-problems/

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Partition Table

https://www.sqlshack.com/database-table-partitioning-sql-server/ (HAY)

https://viblo.asia/p/partition-table-sql-server-MLzGOzbRvpq

Indexes & Partition Table

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd578580(v=sql.100)

https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-2017

https://viblo.asia/p/toi-uu-hoa-database-voi-indexs-MVpvKyxbeKd

Coalesce COALESCE (HAY)

https://www.sqlshack.com/querying-data-using-the-sql-coalesce-function/

Grouping (HAY) - Cube

https://www.blendo.co/blog/postgresql-guide-advanced-grouping/

  • GROUP BY GROUPING SETS
  • GROUP BY ROLLUP
  • GROUP BY CUBE

FUNCTIONS

  • Concat function
  • ISNULL function

https://www.sqlshack.com/sql-server-concatenate-operations-with-sql-plus-and-sql-concat-functions/

https://www.sqlshack.com/top-sql-string-functions-in-sql-server-2017/

ORDER BY (HAY)

https://www.sqlshack.com/overview-of-the-sql-order-by-clause/

Query results when you specify the conditional order

LIKE Operator (HAY)

https://www.sqlshack.com/sql-like-logical-operator-introduction-and-overview/

Data Munging Wrangling - Dữ liệu lộn xộn (HAY)

https://www.sqlshack.com/sql-string-functions-for-data-munging-wrangling/

Split String To Array

https://www.sqlshack.com/implement-array-like-functionality-sql-server/

JSON

https://www.sqlshack.com/importexport-json-data-using-sql-server-2016/

DateTime

https://www.mssqltips.com/sqlservertip/5206/sql-server-datetime-best-practices/

https://www.sqlshack.com/sql-convert-function/

Categories

Recent posts