/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 joeydantoni.com
Using SQL Sentry Plan Explorer to Shed Light on Estimated Execution Plans - The SQL Herald
| | matthewmcgiffen.com
When do Statistics get updated? - Matthew McGiffen Data
2.4 parsecs away

Travel
| | Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when statistics get updated - and where we might have to update them ourselves. This post details in what scenarios statistics get updated, as well as the thresholds used for automatic updating of statistics.
| | erikdarling.com
The Art Of The SQL Server Stored Procedure: Wrapper Stored Procedures - Darling Data
3.4 parsecs away

Travel
| | [AI summary] The article discusses wrapper stored procedures in SQL Server, their advantages and disadvantages, and when to use them versus dynamic SQL.
| | sqlnikon.com
Virtual Book Club: SQL Server Execution Plans, Chapter 4 - SQLNikon
2.0 parsecs away

Travel
| | [AI summary] The author reviews Chapter 4 of the SQL Server book 'SQL Server Execution Plans,' discussing complex query concepts, execution strategies, and personal insights into T-SQL optimization.
| | www.lucasnotes.com
Fixing User Login Mapping | Lucas Notes
19.2 parsecs away

Travel
| SQL Server DBA notes about databases, programming, system administration, and troubleshooting.