Category SQL Server
- 2/2/2014 -There're many way to find sql server deadlock or resolve the issue. At this blog, I will show how to use SQL Server Profiler to show deadlock or one example how to fix it.
- 1/5/2017 -Example of setup the full-text search on SQL Server SQL Server full-text search requires installing on SQL Server, after install the full-text search you can setup the index as follows.
- 6/5/2014 -DATETIME vs DATETIME2 SQL Server DATETIME supports 1753/1/1 to "eternity" (9999/12/31), so if application pass default type Datetime, which is 0001-01-01, it'll throw exception from database. DATETIME2 support 0001-01-01.