내가 좋아할 만한 콘텐츠
#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
#sqltidbit : In @SQLServer if a #sqlquery predicate doesn't match an index, it might do a range/scan operation. This is called 'residual'.
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
For #SQLServer to efficiently match a Plan to a SQL Statement, your object reference better be fully qualified. goo.gl/ohdwhd
SQL Server is real smart! I love that it doesn't cache the plans of queries which run < 1/100th of a second! #SQL #sqlserver #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
Query Plan's a favorite in #SQLServer ! One limitation is the levels of nesting in your Plan XML! Is it >128? Sorry! Out of luck! #sqltoday
United States 트렌드
- 1. Baker 29.2K posts
- 2. Cowboys 72.2K posts
- 3. 49ers 30.9K posts
- 4. Fred Warner 10.2K posts
- 5. Packers 27.3K posts
- 6. Panthers 73.2K posts
- 7. Tez Johnson 2,652 posts
- 8. Zac Taylor 2,767 posts
- 9. Bucs 9,142 posts
- 10. Niners 4,830 posts
- 11. Titans 22.4K posts
- 12. Browns 64.4K posts
- 13. #FTTB 3,862 posts
- 14. Yoshi 32.9K posts
- 15. Ravens 64.2K posts
- 16. Dolphins 46.6K posts
- 17. Cam Ward 2,172 posts
- 18. #Bengals 2,796 posts
- 19. #KeepPounding 8,257 posts
- 20. Geno Smith 2,072 posts
Something went wrong.
Something went wrong.