作者查詢 / rockchangnew
作者 rockchangnew 在 PTT [ Database ] 看板的留言(推文), 共225則
限定看板:Database
看板排序:
全部Gossiping1804HatePolitics990Database225HsinChuang60movie59FJU_CLASS44FJU35TaiwanDrama25Olympics_ISG22Baseball12nCoV20196iOS4WindowsPhone4CMWang3FJU-STAT95B3FJU-Stat97A3FJU_NIGHT3home-sale3L_TalkandCha3Militarylife3NTUT_EE493A3NTU2Shu-Lin2ShuangHe2Tennis2Tour-Manager2Zombie2BigSanchung1car1CrossStrait1DJ_fightman1EatToDie1gay1Golden-Award1Japandrama1MLB1MobileComm1PublicIssue1sex1Stock1Zhongshan1<< 收起看板(41)
4F推: Rebuild clustered index時指定新的file groups即可10/20 23:19
6F推: Clustered Index就是資料表本身10/21 19:54
1F推: google一下pivot,應可以滿足你的需求10/04 14:58
1F推: 重點是有索引09/09 19:45
2F→: 一筆一筆join校能不會比較快呀,反而會慢09/09 19:47
1F推: 去這裡發問吧! https://goo.gl/ZLK65K08/15 11:26
14F推: 先匯再建04/26 15:19
1F推: Ms SQL有支援04/20 14:12
6F推: 微軟有工具可以裝在linux上 https://goo.gl/2aYLHi03/28 14:30
1F推: 不會影響01/05 16:56
1F推: 應該是要做shrinkfile12/20 22:44
5F推: 4樓正解11/30 16:50