내가 좋아할 만한 콘텐츠
#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
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
United States 트렌드
- 1. Lakers 44.5K posts
- 2. Spurs 36.7K posts
- 3. Doug Dimmadome 9,254 posts
- 4. Godzilla 20.4K posts
- 5. Michigan 122K posts
- 6. Marcus Smart 2,167 posts
- 7. Wemby 5,397 posts
- 8. Sherrone Moore 63.2K posts
- 9. #Survivor49 5,183 posts
- 10. Dolly Parton 2,449 posts
- 11. Erika 177K posts
- 12. Jim Ward 9,594 posts
- 13. PETA 25K posts
- 14. #PorVida 1,508 posts
- 15. #AEWDynamite 26.8K posts
- 16. Stephon Castle 3,718 posts
- 17. Gabe Vincent 1,157 posts
- 18. Gainax 3,920 posts
- 19. Candace 219K posts
- 20. Captain Qwark 6,467 posts
Something went wrong.
Something went wrong.