sqlserver @managesqlserver
In ♥ with SQL Server and obsessed about performance Joined September 2016-
Tweets26
-
Followers15
-
Following2
-
Likes0
#sqlserver Selectivity for #sqlquery = (rows returned by a predicate / total rows input to the predicate) @SQLServer
#sqltidbit Predicate in a #sqlserver #query is that which is in a WHERE or JOIN clause, & evaluates to TRUE or FALSE @SQLServer
If all rows need be fetched from table, but ORDER BY has an indexed col,#sqlserver will do index scan, not table scan #sqltidbit @SQLServer
Very interesting ... if a table is small, indexes don't make sense #SQLserver #SQL @SQLServer #SQLtidbit
Why is a specific query plan chosen by @SQLServer when it executes a query?Here's a post on that: goo.gl/msuQId #SQLserver #SQL
Super useful list of #SQLserver system catalog queries goo.gl/V9BjKs worth creating a bookmark #SQL #SQLserverdba
A common mistake : Not okay to just copy/paste #SQL scripts for #SQLServer. Each script is to be tuned to the specific database. @SQLServer
Interesting to note : QUERY RESPONSE TIME = the time to get the 1st record TOTAL TIME = time to fetch all records #SQLServer #sqltoday
#SQLServer will have two copies of any Query Plan in memory ; one for serial executions and one for parallel ones! Interesting! #sqltoday
TDS (Tabular Data Stream) is the native protocol i.e. the way in which all SQL Server communication happens! #sqltoday #SQLServer
Ever thought what goes inside SQL Server? Here's something to see! youtu.be/9N6tTdlkE68 #SQLServer #sqlperformance #sqltoday
Tufayl @tufayl
229 Followers 1K Following SharePointer / Business Analyst / Solutions Architect - Senior IT Consultant
RLC @lopezcelani
145 Followers 3K Following
Steve Stedman @SqlEmt
11K Followers 2K Following SQL Server DBA, Owner/Founder at Stedman Solutions, LLC., Entrepreneur, Instructor, and Geek. Get your free SQL Joins poster here: https://t.co/ZEnsX3l1kp
Adeyemi Adedayo @cheifyemi
76 Followers 946 Following
Jason Squires @js_0505
807 Followers 794 Following I work with Azure/SQL Server/PowerShell. Love adventure, laughing and my family. Opinions are my own. He/Him. @[email protected]
mrìnalinï @mrin_sin
267 Followers 693 Following software engineer. Sometimes I draw things. instagram @_m_rin_sin_
Ahmed @CCIEx1
503 Followers 5K Following
Manoj Sharma @CapManojS
423 Followers 4K Following #Big Data #IoT #MS Azure #AWS #Cloud Computing #ServiceNow #BFSI #SaaS #IaaS #PaaS #DaaS #Machine Learning #Automation Engineering #Robot #Sparrow Framework
Oakwood Systems @OakwoodInsights
852 Followers 1K Following Oakwood = #MicrosoftSolutionsPartner #AzureCloud #ApplicationModernization #Data #Analytics #ManagedITServices
JimD Tech+Politics @JDonovan4VT
71 Followers 619 Following an expert in technology and SW solutions, dev engineer tracking political trends and insights; a former employee at State of VT - ADS #vermontlife #devops
TheMonk Tech @ThemonkTech
201 Followers 868 Following @TheMonkTech is one of the leading and rapidly Growing #Website #Designing and #Development #RemoteDBA service provider company in #Perth,#Australia , #India.
Alex Grimshaw @alzripper
710 Followers 153 Following CTO, UK Azure @Microsoft. Father to a child and an angel. Amazing lady's husband. Opinions are mine, RTs are not endorsements.
Oakwood Systems @OakwoodInsights
852 Followers 1K Following Oakwood = #MicrosoftSolutionsPartner #AzureCloud #ApplicationModernization #Data #Analytics #ManagedITServicesTrends for United States
You might like
