1,087
594
739
2,058
788
923
658
1,375
1,679
880
1,661
1,425
865
674
2,072
898
1,219
1,602
2,874
1,887
9,078
2,117
1,959
1,245
3,478
10.8K
6,324
5,738
1,330
1,907
Joseph Pilov
in
Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests ; what does it all mean?
on
04-01-2020
@Database_Nova , thanks for the feedback. It helped me clarify the
points you were asking about - I appreciate it. See the updated
write-up. Yes, parallel queries is the same as parallel processing done
by SQL Server. You submit a query and if it is "too expensive" from
optimizer point of view AND i...
1 Likes
Database_Nova
in
Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests ; what does it all mean?
on
03-31-2020
Hello @Joseph Pilov , This is a wonderful write-up and it has brought me
much closer to understanding the fundamentals of Sessions vs
Connections. While reading your original post, I was cross referencing
the Microsoft Docs and I was wondering if you could help me better
understand one of your point...
1 Likes
SQLCH
in
Tracking Down Missing Indexes in SQL Azure
on
03-31-2020
Hello, I have tested the script but unfortunately I found problem
running it. Msg 2274, Level 16, State 1, Line 19XQuery
[sys.dm_exec_query_plan.query_plan.exist()]: Unterminated string
constant (started on line 1) Could you please post the corrected script?
Thank you!
0 Likes
DiamondDLott
in
SQL Server 2019 Installation Error - An error occurred for a dependency of the feature
on
03-24-2020
Thanks for this article! Very helpful for SSAS also!
0 Likes
_mrStudent
in
How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)
on
03-20-2020
I am having trouble in following the steps of installing the ssdt
offline...I am already done in steps 1-3.Can you please elaborate it..
sorry i am just new to this type of method
0 Likes