SQL Server
Copied!
Home
Options
1,796
Pedro Lopes on 01-17-2020 11:25 AM
2,449
SQLTom on 01-07-2020 03:23 PM
1,820
EbruErsan on 12-27-2019 01:32 AM
3,690
EbruErsan on 12-27-2019 12:54 AM
1,754
SQLTom on 12-09-2019 12:15 PM
1,439
SQLTom on 12-09-2019 12:07 PM
2,415
EbruErsan on 11-25-2019 04:22 AM
2,266
EbruErsan on 11-06-2019 11:27 AM
2,120
SQLTom on 11-04-2019 06:29 AM
2,613
SQLTom on 10-08-2019 06:13 PM
2,332
SQLTom on 10-08-2019 05:31 PM
2,335
SQLTom on 09-30-2019 01:30 PM
2,741
EbruErsan on 09-23-2019 03:51 AM
2,319
SQLTom on 08-01-2019 05:26 PM
1,662
SQLTom on 07-31-2019 04:38 PM
8,285
EbruErsan on 07-30-2019 12:55 AM
1,636
SQLTom on 07-29-2019 03:53 PM
1,063
SQLTom on 07-29-2019 03:52 PM
2,432
SQLTom on 07-09-2019 01:37 PM
1,998
SQLTom on 07-09-2019 01:37 PM
1,573
SQLTom on 07-09-2019 01:37 PM
1,449
SQLTom on 07-09-2019 01:37 PM
755
SQLTom on 07-09-2019 01:37 PM
494
SQLTom on 07-09-2019 01:36 PM
628
SQLTom on 07-09-2019 01:36 PM
710
SQLTom on 07-09-2019 01:36 PM
552
SQLTom on 07-09-2019 01:36 PM
1,728
SQLTom on 07-09-2019 01:36 PM
2,048
SQLTom on 05-23-2019 06:57 PM
1,940
SQLTom on 05-22-2019 05:50 PM
Latest Comments
@nikb33 You're correct that it's possible you will shift some contention to the non-clustered index, but as long as the non-clustered index is narrow (i.e. only one key column and few or no included columns), the contention on that index shouldn't be as bad. Since the clustered index contains the da...
0 Likes
I really don't understand how the first method in the kb4460004 article is supposed to resolve the issue. You just move the contention from the clustered index to the nonclustered one whose key is still ordered by the monotonically increasing IDENTITY value. So all new inserts will be hitting the sa...
0 Likes
Hi Pedro, First of all thank you for the latest version! I've been using this tool for quite some time now and it works great.One remark though; If you're using GMSA accounts for your SQL Server this till will set them, and if you run the tool again it will give the status "Misplaced". When you fix ...
0 Likes
first link is to an internal Microsoft sharepoint site that gives a login error
0 Likes
@haveyoumetcp It's available in Azure SQL, but only for managed instances - sadly the more cloud-centric SQL databases option does not support this, which is a shame - I really hope that Microsoft does bring this functionality to all SQL Azure versions eventually.
0 Likes