#SQLHelp, Twitter, 7/29/2020 8:01:08 PM, 231362


FAQ | Problem?

#SQLHelp Twitter NodeXL SNA Map and Report for Wednesday, 29 July 2020 at 19:52 UTC
#SQLHelp Twitter NodeXL SNA Map and Report for Wednesday, 29 July 2020 at 19:52 UTC
From:
marc_smith
Uploaded on:
July 29, 2020
Short Description:
#SQLHelp via NodeXL https://bit.ly/2Djbig0
@paulrandal
@sqlpoolboy
@jdanton
@nalgorithms
@sqlha
@mrdenny
@nocentino
@tradney
@glennalanberry
@n8gis

Top hashtags:
#sqlhelp
#sql
#sqlserver
#databases
#100daysofcode
#sqlfamily
#azure
#postgresql
#careerlimitingmove

Description:
Description
The graph represents a network of 104 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Wednesday, 29 July 2020 at 19:52 UTC.

The tweets in the network were tweeted over the 8-day, 22-hour, 13-minute period from Monday, 20 July 2020 at 21:34 UTC to Wednesday, 29 July 2020 at 19:48 UTC.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 104
Unique Edges : 113
Edges With Duplicates : 88
Total Edges : 201
Number of Edge Types : 5
Replies to : 99
Tweet : 49
Mentions : 36
Retweet : 16
MentionsInRetweet : 1
Self-Loops : 49
Reciprocated Vertex Pair Ratio : 0.0340909090909091
Reciprocated Edge Ratio : 0.0659340659340659
Connected Components : 34
Single-Vertex Connected Components : 21
Maximum Vertices in a Connected Component : 49
Maximum Edges in a Connected Component : 149
Maximum Geodesic Distance (Diameter) : 8
Average Geodesic Distance : 3.602675
Graph Density : 0.00849514563106796
Modularity : 0.472971
NodeXL Version : 1.0.1.439
Graph Gallery URL : https://nodexlgraphgallery.org/Pages/Graph.aspx?graphID=231361
Data Import : The graph represents a network of 104 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Wednesday, 29 July 2020 at 19:52 UTC.

The tweets in the network were tweeted over the 8-day, 22-hour, 13-minute period from Monday, 20 July 2020 at 21:34 UTC to Wednesday, 29 July 2020 at 19:48 UTC.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

Layout Algorithm : The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.
Graph Source : TwitterSearch
Graph Term : #SQLHelp
Groups : The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.
Edge Color : Edge Weight
Edge Width : Edge Weight
Edge Alpha : Edge Weight
Vertex Radius : In-Degree

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[7] https://www.coodingdessign.com/database/remove-bookmark-lookup-sql-in-sixty-seconds-089/
[2] http://sqlfiddle.com/#!18/7ad28/8
[2] https://www.sqlskills.com/blogs/kimberly/the-tipping-point-query-answers/
[2] https://dba.stackexchange.com/questions/271166/how-can-i-capture-error-thrown-by-set-locktimeout-in-ola-hallengren
[1] https://blogs.msdn.microsoft.com/psssql/2017/06/29/sql-server-large-ram-and-db-checkpointing/
[1] https://bit.ly/lyIO9s_db_index_physical_stats
[1] https://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/
[1] https://nativealgorithms.com/team/
[1] https://www.brentozar.com/archive/2009/12/i-need-sqlhelp/
[1] https://stackoverflow.com/questions/63138635/adding-dummy-where-condition-brings-execution-plan-to-seek

Top URLs in Tweet in G1:
[1] https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15#to-rebuild-all-indexes-in-a-table

Top URLs in Tweet in G2:
[1] https://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/

Top URLs in Tweet in G3:
[2] https://dba.stackexchange.com/questions/271166/how-can-i-capture-error-thrown-by-set-locktimeout-in-ola-hallengren
[1] https://www.brentozar.com/archive/2009/12/i-need-sqlhelp/
[1] https://bit.ly/lyIO9s_db_index_physical_stats
[1] https://nativealgorithms.com/team/
[1] http://allen-mcguire.blogspot.com/2019/04/identify-and-retry-failed-backups-using.html

Top URLs in Tweet in G4:
[1] https://blogs.msdn.microsoft.com/psssql/2017/06/29/sql-server-large-ram-and-db-checkpointing/
[1] https://bytescout.com/blog/mssql-vs-postgresql.html
[1] https://bytescout.com/blog/how-to-increase-the-speed-of-sql-queries.html

Top URLs in Tweet in G5:
[7] https://www.coodingdessign.com/database/remove-bookmark-lookup-sql-in-sixty-seconds-089/

Top URLs in Tweet in G8:
[2] http://sqlfiddle.com/#!18/7ad28/8
[2] https://www.sqlskills.com/blogs/kimberly/the-tipping-point-query-answers/
[1] https://stackoverflow.com/questions/63138635/adding-dummy-where-condition-brings-execution-plan-to-seek

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[171] sqlhelp
[14] sql
[13] sqlserver
[9] databases
[7] 100daysofcode
[6] sqlfamily
[2] azure
[2] postgresql
[1] careerlimitingmove
[1] postgres



Top Hashtags in Tweet in G1:
[21] sqlhelp
[4] sql
[2] databases
[2] sqlserver
[1] programming
[1] sqlfamily
[1] mvpbuzz
[1] upgradeyourself
[1] freshers
[1] dbas

Top Hashtags in Tweet in G2:
[34] sqlhelp
[2] sqlfamily
[1] azure

Top Hashtags in Tweet in G3:
[55] sqlhelp
[1] sqlserver
[1] careerlimitingmove

Top Hashtags in Tweet in G4:
[21] sqlhelp
[2] sqlserver
[1] postgresql
[1] sqlfamily
[1] tutorial
[1] sql
[1] programminglife
[1] bytescout

Top Hashtags in Tweet in G5:
[7] sql
[7] sqlserver
[7] 100daysofcode
[7] databases
[7] sqlhelp

Top Hashtags in Tweet in G6:
[11] sqlhelp

Top Hashtags in Tweet in G7:
[1] postgresql
[1] postgres
[1] sqlhelp
[1] sql
[1] database

Top Hashtags in Tweet in G8:
[2] sqlfamily
[2] sqlhelp

Top Hashtags in Tweet in G9:
[4] sqlhelp

Top Hashtags in Tweet in G10:
[3] sqlhelp

Top Words
Top Words in Tweet in Entire Graph:
[173] #sqlhelp
[54] sql
[39] nalgorithms
[31] tag
[25] anyone
[25] community
[25] hash
[22] use
[21] database
[21] server

Top Words in Tweet in G1:
[21] #sqlhelp
[7] sql
[6] know
[5] anyone
[4] use
[4] #sql
[4] error
[4] server
[4] database
[3] wrong

Top Words in Tweet in G2:
[34] #sqlhelp
[9] sql
[6] ilb
[6] anyone
[6] server
[5] using
[5] workload
[5] use
[5] costs
[4] ip

Top Words in Tweet in G3:
[55] #sqlhelp
[38] nalgorithms
[22] community
[21] tag
[19] hash
[15] re
[14] people
[11] sql
[11] please
[8] server

Top Words in Tweet in G4:
[21] #sqlhelp
[7] backup
[6] same
[6] hash
[6] tag
[5] bdill
[5] restore
[5] both
[5] log
[5] sql

Top Words in Tweet in G5:
[7] remove
[7] bookmark
[7] lookup
[7] #sql
[7] sixty
[7] seconds
[7] #089
[7] #sqlserver
[7] pinal
[7] dave

Top Words in Tweet in G6:
[14] sql
[12] azure
[11] #sqlhelp
[9] restore
[6] database
[6] 100gb
[5] size
[5] storage
[5] db
[4] anyone

Top Words in Tweet in G7:
[2] postgresql

Top Words in Tweet in G8:
[4] #sqlhelp
[4] clause
[2] hi
[2] #sqlfamily
[2] please
[2] look
[2] help
[2] understanding
[2] adding
[2] greater

Top Words in Tweet in G9:
[4] #sqlhelp
[2] possible
[2] memory
[2] anyone
[2] database

Top Words in Tweet in G10:
[4] tag
[3] #sqlhelp
[3] help
[2] please
[2] use
[2] potential
[2] customers
[2] quest
[2] sql

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[28] nalgorithms,#sqlhelp
[24] hash,tag
[16] sql,server
[9] azure,sql
[7] remove,bookmark
[7] bookmark,lookup
[7] lookup,#sql
[7] #sql,sixty
[7] sixty,seconds
[7] seconds,#089

Top Word Pairs in Tweet in G1:
[3] #sql,#sqlhelp
[3] anyone,know
[3] sql,server
[2] schema,comparison
[2] catch,block
[2] #sqlhelp,anyone
[2] dp,300

Top Word Pairs in Tweet in G2:
[3] low,use
[2] cloud,witness
[2] witness,#sqlhelp
[2] happy,wrong
[2] wrong,#sqlhelp
[2] load,balancer
[2] anyone,experience
[2] experience,loss
[2] loss,sql
[2] sql,perf

Top Word Pairs in Tweet in G3:
[28] nalgorithms,#sqlhelp
[18] hash,tag
[8] sql,server
[5] sbsmool,#sqlhelp
[4] server,community
[4] many,thanks
[4] re,going
[4] pagerwho,sbsmool
[3] #sqlhelp,hashtag
[3] please,don

Top Word Pairs in Tweet in G4:
[6] hash,tag
[4] both,sides
[4] target,audience
[3] copyonly,backup
[3] bytescout,please
[2] reattach,#sqlhelp
[2] user,databases
[2] sides,#sqlhelp
[2] sql,server
[2] glennalanberry,bdill

Top Word Pairs in Tweet in G5:
[7] remove,bookmark
[7] bookmark,lookup
[7] lookup,#sql
[7] #sql,sixty
[7] sixty,seconds
[7] seconds,#089
[7] #089,#sqlserver
[7] #sqlserver,pinal
[7] pinal,dave
[7] dave,#100daysofcode

Top Word Pairs in Tweet in G6:
[9] azure,sql
[6] sql,database
[4] anyone,data
[4] data,experience
[4] experience,testing
[4] testing,various
[4] various,size
[4] size,azure
[4] database,restores
[4] restores,specifically

Top Word Pairs in Tweet in G8:
[2] hi,#sqlfamily
[2] #sqlfamily,please
[2] please,look
[2] look,help
[2] help,understanding
[2] understanding,adding
[2] adding,greater
[2] greater,condition
[2] condition,bring
[2] bring,index

Top Word Pairs in Tweet in G10:
[2] #sqlhelp,tag
[2] potential,customers

Top Replied-To
Top Replied-To in Entire Graph:
@nalgorithms
@jdanton
@sqldeployhelmet
@pagerwho
@bytescout
@sqluser786
@gbargsley
@zamorao
@tradney
@zrbrc

Top Replied-To in G2:
@sqluser786
@jdanton
@gbargsley
@crswit
@ceekng
@kenhemmerling
@n8gis
@sirsql
@sqlha
@shaunraustin

Top Replied-To in G3:
@nalgorithms
@pagerwho
@eric_swiggum
@sbsmool
@sql_handle
@paulrandal
@bytescout

Top Replied-To in G4:
@sqldeployhelmet
@bytescout
@bdill
@glennalanberry
@n8gis
@mrdenny
@sonipgca
@nalgorithms

Top Replied-To in G6:
@zamorao
@tradney
@jdanton

Top Replied-To in G8:
@utsavverma

Top Replied-To in G9:
@jasonhorner

Top Replied-To in G10:
@quest

Top Mentioned
Top Mentioned in Entire Graph:
@sqlpoolboy
@sbsmool
@psdbatools
@bdill
@azuresql
@sqlpedro
@paulrandal
@crswit
@ceekng
@glennalanberry

Top Mentioned in G1:

Top Mentioned in G2:
@azuresql
@psdbatools
@sqlpoolboy
@ceekng
@crswit
@kendra_little

Top Mentioned in G3:
@sbsmool
@sqlpedro
@paulrandal
@sqlpoolboy
@nalgorithms
@hugo_kornelis

Top Mentioned in G4:
@bdill
@glennalanberry

Top Mentioned in G6:
@sqlpoolboy

Top Mentioned in G7:
@postgresql
@postgresconf
@2ndquad

Top Mentioned in G9:
@jrb2971

Top Tweeters
Top Tweeters in Entire Graph:
@xaelbot
@codedailybot
@redianbot
@sql_handle
@jdanton
@nlognbot
@theinfernobot
@brento
@mrdenny
@sqlha

Top Tweeters in G1:
@retracement
@evelynhaddock
@madpiet
@dennes
@sqlferret
@sqlnightowl
@buddingeek
@moresunshine_1
@danielsilv9
@sqljudo

Top Tweeters in G2:
@jdanton
@sqlha
@sqlagentman
@underline_api
@sqlpoolboy
@kendra_little
@therockstardba
@gbargsley
@psdbatools
@shaunraustin

Top Tweeters in G3:
@sql_handle
@paulrandal
@sqltrooper
@sqlworldwide
@dirkhondong
@hugo_kornelis
@denisreznik
@sqlpedro
@sqlseeker77
@pagerwho

Top Tweeters in G4:
@mrdenny
@pshore73
@glennalanberry
@sequeldba
@sonipgca
@n8gis
@sqldeployhelmet
@bytescout
@bdill

Top Tweeters in G5:
@xaelbot
@codedailybot
@redianbot
@nlognbot
@theinfernobot
@dreegy
@coodignd

Top Tweeters in G6:
@_randolph_west
@gregor_suttie
@zamorao
@nocentino
@tradney

Top Tweeters in G7:
@2ndquad
@postgresconf
@postgresql
@santhoshvr97

Top Tweeters in G8:
@klunkysql
@kekline
@utsavverma

Top Tweeters in G9:
@jasonhorner
@nedotter
@jrb2971

Top Tweeters in G10:
@quest
@mmarie
@stridergdm


Tags:

We use necessary cookies to make our site work. We’d like to set additional cookies to understand site usage, make site improvements and to remember your settings. We also use cookies set by other sites to help deliver content from their services.