SQL Server

  • 1,353 Blog Articles
Options
859
EbruErsan on 10-20-2020 06:44 AM
3,064
SQLTom on 10-01-2020 12:32 PM
3,325
Sasha_Nosov on 09-30-2020 11:20 AM
1,495
SrinivasSQL on 09-28-2020 04:39 PM
1,366
SrinivasSQL on 09-10-2020 04:58 PM
1,103
EbruErsan on 09-09-2020 07:31 AM
12.8K
SrinivasSQL on 09-02-2020 01:56 PM
2,358
EbruErsan on 08-21-2020 01:38 AM
3,058
Pedro Lopes on 08-18-2020 12:47 PM
1,836
SrinivasSQL on 08-06-2020 01:51 PM
1,616
SQLTom on 08-04-2020 03:41 PM
3,113
EbruErsan on 07-03-2020 05:46 AM
2,158
SrinivasSQL on 07-01-2020 02:14 PM
1,577
EbruErsan on 06-29-2020 07:01 AM
2,078
EbruErsan on 06-24-2020 01:00 AM
1,852
SQLTom on 06-22-2020 11:29 AM
7,526
EbruErsan on 06-17-2020 06:13 AM
2,728
SQLTom on 05-29-2020 04:46 PM
6,197
EbruErsan on 04-27-2020 05:42 AM
2,460
HristinaSQL on 04-09-2020 09:34 PM
2,376
SQLTom on 03-31-2020 10:43 AM
2,515
SQLTom on 03-12-2020 01:59 PM
2,872
HristinaSQL on 02-25-2020 12:01 PM
2,234
SQLTom on 02-13-2020 05:14 PM
2,265
SQLTom on 02-11-2020 11:55 AM
1,845
SQLTom on 02-11-2020 11:54 AM
1,732
SQLTom on 02-11-2020 11:53 AM
1,619
SQLTom on 02-11-2020 11:51 AM
1,545
SQLTom on 02-11-2020 11:50 AM
1,809
HristinaSQL on 02-05-2020 06:21 PM

Latest Comments

I'm confused. Wasn't nvarchar always supported? We use it to store Unicode data for years...
0 Likes
Enlightening and a must read for anyone not confident of their own knowledge of trace flags and their use. Sometimes the obvious must still be said. Trace flags are used to enable features and determine behavior. Thank you for sharing.
0 Likes
Can you do this with SSMS and when using MS Azure? Can you point me to further articles you may have published on this topic? This is EXACTLY what I am looking for to help me understand the cause of long running queries with MS Access as a front end and Azure as the back end.I am interested in seein...
0 Likes
@-Michael_Karpenko- that is true, if you can re-architect the database using something like memory-optimized tables or hash partitioning, you will likely get better performance. This solution is designed for customers who cannot re-architect for some reason. It's not a huge improvement in throughput...
1 Likes
if promised throughput improvement is just 20-30%...I'm wondering if we still need to use or combine OPTIMIZE_FOR_SEQUENTIAL_KEY feature with different solutions.Most probably hash partitioning (Method #5)https://support.microsoft.com/en-us/help/4460004/how-to-resolve-last-page-insert-pagelatch-ex-c...
0 Likes