corpus.blog
41554 blogs · [ { "id": "01a08794-be27-7131-a235-da124d6917c8", "title": "How Much Longer Does it Take To Update Statistics with FULLSCAN?", "url": "https://kendralittle.com/2017/06/14/how-much-longer-does-it-take-to-update-statistics-with-fullscan/", "published_at": "2017-06-14T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124e47fd07", "title": "When does a Snapshot Transaction Really Begin?", "url": "https://kendralittle.com/2017/06/12/when-does-a-snapshot-transaction-really-begin/", "published_at": "2017-06-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124ef23588", "title": "When does physical reads include read-ahead reads in SQL Server?", "url": "https://kendralittle.com/2017/06/07/does-physical-reads-include-read-ahead-reads-in-sql-server/", "published_at": "2017-06-07T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124ef97176", "title": "Top 5 Misleading SQL Server Performance Counters", "url": "https://kendralittle.com/2017/06/05/top-5-misleading-sql-server-performance-counters/", "published_at": "2017-06-05T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124f793b0e", "title": "Register for Upcoming Free Webcasts on Indexes, Stats Maintenance, Query Tuning, and More", "url": "https://kendralittle.com/2017/06/02/register-for-upcoming-free-webcasts-on-indexes-stats-maintenance-query-tuning-and-more/", "published_at": "2017-06-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124fb02419", "title": "Database Mirroring Counters Missing from Perfmon?", "url": "https://kendralittle.com/2017/05/31/database-mirroring-counters-missing-from-perfmon/", "published_at": "2017-05-31T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1250711bf3", "title": "Why I am Inspired to Start Up Live Webcasts Again", "url": "https://kendralittle.com/2017/05/26/why-im-inspired-to-start-up-live-webcasts-again/", "published_at": "2017-05-26T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1250d1c67d", "title": "Finding Queries that Cause Wait Stats in SQL Server", "url": "https://kendralittle.com/2017/05/25/finding-queries-that-cause-wait-stats-in-sql-server/", "published_at": "2017-05-25T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1250ea107a", "title": "When a Nonclustered Index and Statistics Make a Query Slower", "url": "https://kendralittle.com/2017/05/24/when-a-nonclustered-index-and-statistics-make-a-query-slower/", "published_at": "2017-05-24T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12518398f1", "title": "Removing Query Hints with Plan Guides (Dear SQL DBA Episode 43)", "url": "https://kendralittle.com/2017/05/18/removing-query-hints-with-plan-guides-dear-sql-dba-episode-43/", "published_at": "2017-05-18T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da125191e8ac", "title": "Perfmon: Batch Requests/sec counts whole batches, not statements", "url": "https://kendralittle.com/2017/05/16/perfmon-batch-requestssec-counts-whole-batches-not-statements/", "published_at": "2017-05-16T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1251ddd448", "title": "Batch Mode Hacks for Rowstore Queries in SQL Server", "url": "https://kendralittle.com/2017/05/11/batch-mode-hacks-for-rowstore-queries-in-sql-server/", "published_at": "2017-05-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12525a0ee8", "title": "New Course! Query Tuning with Hints & Optimizer Hotfixes", "url": "https://kendralittle.com/2017/05/10/new-course-query-tuning-with-hints-optimizer-hotfixes/", "published_at": "2017-05-10T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1252aa652a", "title": "SQLServer:Databases(_Total)\\Transactions/sec vs SQL Statistics\\Batch Requests/sec (video)", "url": "https://kendralittle.com/2017/05/08/sqlserverdatabases_totaltransactionssec-vs-sql-statisticsbatch-requestssec-video/", "published_at": "2017-05-08T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1253142d5e", "title": "Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)", "url": "https://kendralittle.com/2017/05/04/should-i-get-certified-as-a-dba-dear-sql-dba-episode-41/", "published_at": "2017-05-04T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1253b36fb2", "title": "Checking for the Existence of Global Temp Table in TSQL", "url": "https://kendralittle.com/2017/05/03/checking-for-the-existence-of-global-temp-table-in-tsql/", "published_at": "2017-05-03T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1253f3e7dd", "title": "Use Report View in Perfmon to Compare Database Counters (free video)", "url": "https://kendralittle.com/2017/05/01/use-report-view-in-perfmon-to-compare-database-counters-free-video/", "published_at": "2017-05-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1254b430f3", "title": "How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)", "url": "https://kendralittle.com/2017/04/27/how-does-a-dba-build-confidence-after-making-mistakes-dear-sql-dba-episode-40/", "published_at": "2017-04-27T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1255143a43", "title": "Error 1204: When SQL Server Runs Out of Locks", "url": "https://kendralittle.com/2017/04/26/error-1204-when-sql-server-runs-out-of-locks/", "published_at": "2017-04-26T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1255e5f282", "title": "Run perfmon.exe /sys to Remember Your Counters in Windows Perfmon (free video)", "url": "https://kendralittle.com/2017/04/24/run-perfmon-exe-sys-to-remember-your-counters-in-windows-perfmon-free-video/", "published_at": "2017-04-24T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c892925b80", "title": "Are Bad Statistics Making My Query Slow? (Dear SQL DBA Episode 39)", "url": "https://kendralittle.com/2017/04/20/are-bad-statistics-making-my-query-slow-dear-sql-dba-episode-39/", "published_at": "2017-04-20T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89353282a", "title": "Trace Flag 4199: No Per-Session Override if You Enable it Globally", "url": "https://kendralittle.com/2017/04/19/trace-flag-4199-no-per-session-override-if-you-enable-it-globally/", "published_at": "2017-04-19T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c893f7765d", "title": "Index Maintenance and Performance (Dear SQL DBA Episode 38)", "url": "https://kendralittle.com/2017/04/13/index-maintenance-and-performance-dear-sql-dba-episode-38/", "published_at": "2017-04-13T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c894228198", "title": "Will Optimize for Adhoc Workloads Save Memory?", "url": "https://kendralittle.com/2017/04/12/will-optimize-for-adhoc-workloads-save-memory/", "published_at": "2017-04-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c894e999b2", "title": "Poster in the works: SSMS Shortcuts Explained by Cats", "url": "https://kendralittle.com/2017/04/10/poster-in-the-works-ssms-shortcuts-explained-by-cats/", "published_at": "2017-04-10T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8956b2ade", "title": "Lock Timeouts & Memory (Dear SQL DBA Episode 37)", "url": "https://kendralittle.com/2017/04/06/lock-timeouts-memory-dear-sql-dba-episode-36/", "published_at": "2017-04-06T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8964227df", "title": "Selectively EnableTrace Flag 4199 and QUERY_OPTIMIZER_HOTFIXES in SQL Server 2016", "url": "https://kendralittle.com/2017/04/05/selectively-enabletrace-flag-4199-and-query_optimizer_hotfixes-in-sql-server-2016/", "published_at": "2017-04-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c896fcfbc5", "title": "Reviving Healthy Work Habits: Toggl and Weekly Highlights", "url": "https://kendralittle.com/2017/04/03/reviving-healthy-work-habits-toggl-and-weekly-highlights/", "published_at": "2017-04-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89769f53c", "title": "Which Locks Count Toward Lock Escalation?", "url": "https://kendralittle.com/2017/04/03/which-locks-count-toward-lock-escalation/", "published_at": "2017-04-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c897f01e19", "title": "Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)", "url": "https://kendralittle.com/2017/03/30/why-is-my-transaction-log-growing-in-my-availability-group-dear-sql-dba-episode-36/", "published_at": "2017-03-30T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8980cffb1", "title": "The Case of the Blocking Online Index Create- the Shared Lock that Would Not Quit", "url": "https://kendralittle.com/2017/03/28/the-case-of-the-blocking-online-index-create-a-shared-lock-that-wouldnt-quit/", "published_at": "2017-03-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c898e94c78", "title": "New weekly newsletter: a SQL Server quiz, poll or cartoon each week", "url": "https://kendralittle.com/2017/03/27/new-weekly-newsletter-a-sql-server-quiz-poll-or-cartoon-each-week/", "published_at": "2017-03-27T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c899669493", "title": "New Freebie Course: SSMS Shortcuts & Secrets", "url": "https://kendralittle.com/2017/03/23/new-freebie-course-ssms-shortcuts-secrets/", "published_at": "2017-03-23T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8996adf79", "title": "When SQL Server Does NOT Use Write Ahead Logging (Dear SQL DBA Episode 35)", "url": "https://kendralittle.com/2017/03/23/when-sql-server-does-not-use-write-ahead-logging-dear-sql-dba-episode-35/", "published_at": "2017-03-23T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89a019181", "title": "Columnstore Index Returns Zero Rows... Which is One Row", "url": "https://kendralittle.com/2017/03/21/columnstore-index-returns-zero-rows-which-is-one-row/", "published_at": "2017-03-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89a805345", "title": "Time for an Interview: What accomplishment are YOU most proud of?", "url": "https://kendralittle.com/2017/03/20/time-for-an-interview-what-accomplishment-are-you-most-proud-of/", "published_at": "2017-03-20T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89b118e4f", "title": "Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)", "url": "https://kendralittle.com/2017/03/16/using-a-tail-log-backup-in-a-sql-server-migration-dear-sql-dba-episode-34/", "published_at": "2017-03-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89bc57841", "title": "Data Type Mismatches Do Not Always Cause a Bad Implicit Conversion and Index Scan", "url": "https://kendralittle.com/2017/03/15/data-type-mismatches-dont-always-cause-a-bad-implicit-conversion-and-index-scan/", "published_at": "2017-03-15T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89cbd152b", "title": "Why Indexes Reduce Locks for Update and Delete Queries", "url": "https://kendralittle.com/2017/03/14/why-indexes-reduce-locks-for-update-and-delete-queries/", "published_at": "2017-03-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89d6bb927", "title": "Stack Dumps in SQL Server (Dear SQL DBA Episode 33)", "url": "https://kendralittle.com/2017/03/09/stack-dumps-in-sql-server-dear-sql-dba-episode-33/", "published_at": "2017-03-09T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89d6d9078", "title": "Overindexing: Missing Index DMVs and the Database Tuning Advisor", "url": "https://kendralittle.com/2017/03/08/overindexing-missing-index-dmvs-and-the-database-tuning-advisor/", "published_at": "2017-03-08T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89df08eae", "title": "How to Quickly Tell if an Execution Plan has Multiple Missing Index Requests", "url": "https://kendralittle.com/2017/03/07/how-to-quickly-tell-if-an-execution-plan-has-multiple-missing-index-requests/", "published_at": "2017-03-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89e3c4965", "title": "New Course: Tuning Problem Queries in Table Partitioning", "url": "https://kendralittle.com/2017/03/02/new-course-tuning-problem-queries-in-table-partitioning/", "published_at": "2017-03-02T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89eadf269", "title": "WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)", "url": "https://kendralittle.com/2017/03/02/wal-the-concept-that-makes-recovery-models-backups-make-sense-dear-sql-dba-episode-32/", "published_at": "2017-03-02T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89ee79d19", "title": "DBCC CLONEDATABASE Does NOT Clone Index Usage Statistics", "url": "https://kendralittle.com/2017/02/28/dbcc-clonedatabase-does-not-clone-index-usage-statistics/", "published_at": "2017-02-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c89fb324de", "title": "The BabbyNames Sample Database - Now on GitHub", "url": "https://kendralittle.com/2017/02/28/the-babbynames-sample-database-now-on-github/", "published_at": "2017-02-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a03b2191", "title": "Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)", "url": "https://kendralittle.com/2017/02/23/will-the-cloud-eat-my-dba-job-dear-sql-dba-episode-31/", "published_at": "2017-02-23T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a0b2b1fd", "title": "Understanding avg_total_user_cost and avg_user_impact in Missing Index Requests", "url": "https://kendralittle.com/2017/02/22/understanding-avg_total_user_cost-and-avg_user_impact-in-missing-index-requests/", "published_at": "2017-02-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a1a9af5e", "title": "Adding Partitions to the Lower End of a Left Based Partition Function", "url": "https://kendralittle.com/2017/02/21/adding-partitions-to-the-lower-end-of-a-left-based-partition-function/", "published_at": "2017-02-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a1a9bc09", "title": "Confused by sp_who2 (Dear SQL DBA Episode 30)", "url": "https://kendralittle.com/2017/02/16/confused-by-sp_who2-dear-sql-dba-episode-30/", "published_at": "2017-02-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a27150b1", "title": "The Top 3 Mistakes I Made Fighting Blocking", "url": "https://kendralittle.com/2017/02/16/the-top-3-mistakes-i-made-fighting-blocking/", "published_at": "2017-02-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a32dae0a", "title": "New online course: Troubleshooting Blocking & Deadlocks for Beginners (Free!)", "url": "https://kendralittle.com/2017/02/14/new-online-course-troubleshooting-blocking-deadlocks-for-beginners/", "published_at": "2017-02-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a381d5f4", "title": "Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)", "url": "https://kendralittle.com/2017/02/09/should-i-learn-fulltext-indexing-dear-sql-dba-episode-29/", "published_at": "2017-02-09T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a41daddd", "title": "Understanding Left vs. Right Partition Functions (with Diagrams)", "url": "https://kendralittle.com/2017/02/07/understanding-left-vs-right-partition-functions-with-diagrams/", "published_at": "2017-02-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a441d404", "title": "Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes (Dear SQL DBA Episode 28)", "url": "https://kendralittle.com/2017/02/02/index-types-heaps-primary-keys-clustered-and-nonclustered-indexes-dear-sql-dba-episode-28/", "published_at": "2017-02-02T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a44669ca", "title": "Which Filegroup is that Partition Using? How Many Rows Does It Have?", "url": "https://kendralittle.com/2017/01/31/which-filegroup-is-that-partition-using-how-many-rows-does-it-have/", "published_at": "2017-01-31T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a53ebba5", "title": "What is that Garbage in my Execution Plan? (Dear SQL DBA Episode 27)", "url": "https://kendralittle.com/2017/01/26/whats-that-garbage-in-my-execution-plan-dear-sql-dba-episode-26/", "published_at": "2017-01-26T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a5508f00", "title": "How to Find Queries Using an Index (and Queries Using Index Hints)", "url": "https://kendralittle.com/2017/01/24/how-to-find-queries-using-an-index-and-queries-using-index-hints/", "published_at": "2017-01-24T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a571198d", "title": "Why You Should Switch in Staging Tables Instead of Renaming Them (Dear SQL DBA Episode 26)", "url": "https://kendralittle.com/2017/01/19/why-you-should-switch-in-staging-tables-instead-of-renaming/", "published_at": "2017-01-19T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a6140928", "title": "Bug: Incorrect modification_counter for Column Stats on Tables with a Clustered Columnstore Index", "url": "https://kendralittle.com/2017/01/17/bug-incorrect-modification_counter-for-column-stats-on-tables-with-a-clustered-columnstore-index/", "published_at": "2017-01-17T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a6720264", "title": "How to Query Histogram Target XML in Extended Events", "url": "https://kendralittle.com/2017/01/12/how-to-query-histogram-target-xml-in-extended-events/", "published_at": "2017-01-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a7513cad", "title": "Administering COTS databases (ISVs / Third Party Vendors)", "url": "https://kendralittle.com/2017/01/10/administering-cots-databases-isvs-third-party-vendors/", "published_at": "2017-01-10T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a815fb5f", "title": "Configure Fields and Predicates for Multiple X-Events", "url": "https://kendralittle.com/2017/01/05/configure-fields-and-predicates-for-multiple-x-events/", "published_at": "2017-01-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a8a7eb84", "title": "Parallelism and tempdb data file usage in SQL Server", "url": "https://kendralittle.com/2017/01/03/parallelism-and-tempdb-data-file-usage-in-sql-server/", "published_at": "2017-01-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a985dac4", "title": "Columnstore Indexes and Computed Columns in SQL Server 2016", "url": "https://kendralittle.com/2016/12/29/columnstore-indexes-and-computed-columns-in-sql-server-2016/", "published_at": "2016-12-29T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8a9bffb4d", "title": "Tracing Deadlock Graphs: Extended Events or Server Side Trace", "url": "https://kendralittle.com/2016/12/27/tracing-deadlock-graphs-extended-events-or-server-side-trace/", "published_at": "2016-12-27T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8aa137c2e", "title": "Collecting the Blocked Process Report (XEvents and Server Side Trace)", "url": "https://kendralittle.com/2016/12/22/collecting-the-blocked-process-report-xevents-and-server-side-trace/", "published_at": "2016-12-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8aa3f732b", "title": "Actual Time Statistics in Execution Plans: Elapsed CPU Time and more", "url": "https://kendralittle.com/2016/12/20/actual-time-statistics-in-execution-plans-elapsed-cpu-time-and-more/", "published_at": "2016-12-20T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ab2ac187", "title": "Limiting Downtime for Schema Changes (Dear SQL DBA Episode 25)", "url": "https://kendralittle.com/2016/12/15/limiting-downtime-for-schema-changes-dear-sql-dba-episode-25/", "published_at": "2016-12-15T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ac298c29", "title": "Index Create and Last Modified Dates in SQL Server", "url": "https://kendralittle.com/2016/12/13/index-create-and-last-modified-dates-in-sql-server/", "published_at": "2016-12-13T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ac594328", "title": "Does Truncate Table Reset Statistics?", "url": "https://kendralittle.com/2016/12/08/does-truncate-table-reset-statistics/", "published_at": "2016-12-08T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8acd709af", "title": "When Did SQL Server Last Update That Statistic? How Much Has Been Modified Since? And What Columns are in the Stat?", "url": "https://kendralittle.com/2016/12/06/when-did-sql-server-last-update-that-statistic-how-much-has-been-modified-since-and-what-columns-are-in-the-stat/", "published_at": "2016-12-06T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8adb41190", "title": "Signs Your SQL Server is Running with Scissors (Dear SQL DBA Episode 24)", "url": "https://kendralittle.com/2016/12/01/signs-your-sql-server-is-running-with-scissors-dear-sql-dba-episode-24/", "published_at": "2016-12-01T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ae3c15da", "title": "Learn to Tune Indexes in Lisbon on March 9, 2017", "url": "https://kendralittle.com/2016/11/30/learn-to-tune-indexes-in-lisbon-march-9-2017/", "published_at": "2016-11-30T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8aec2db9a", "title": "How to Tune Indexes for a Stored Procedure", "url": "https://kendralittle.com/2016/11/29/the-best-way-to-tune-indexes-for-a-stored-procedure/", "published_at": "2016-11-29T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8af2cc771", "title": "Why is My Query Faster the Second Time it Runs? (Dear SQL DBA Episode 23)", "url": "https://kendralittle.com/2016/11/25/why-is-my-query-faster-the-second-time-it-runs-dear-sql-dba-episode-23/", "published_at": "2016-11-25T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8af3ec79b", "title": "Should I change the locks configuration in SQL Server?", "url": "https://kendralittle.com/2016/11/22/should-i-change-the-locks-configuration-in-sql-server/", "published_at": "2016-11-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8af9cc69f", "title": "Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)", "url": "https://kendralittle.com/2016/11/17/should-i-upgrade-to-sql-server-2016-dear-sql-dba-episode-22/", "published_at": "2016-11-17T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b08a35c9", "title": "SQL Server 2016 SP1: Features Added to Standard, Web, Express, Local DB Editions", "url": "https://kendralittle.com/2016/11/16/sql-server-2016-sp1-features-added-to-standard-web-express-local-db-editions/", "published_at": "2016-11-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b12d9f7e", "title": "Downgrading the SQL Server Edition of a Dev Environment", "url": "https://kendralittle.com/2016/11/15/downgrading-the-sql-server-edition-of-a-dev-environment/", "published_at": "2016-11-15T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b1e15c97", "title": "Filtered Indexes: Rowstore vs Nonclustered Columnstore", "url": "https://kendralittle.com/2016/11/10/filtered-indexes-rowstore-vs-nonclustered-columnstore/", "published_at": "2016-11-10T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b27c5839", "title": "Shrinking SQL Server Data Files - Best Practices, and Why It Sucks", "url": "https://kendralittle.com/2016/11/08/shrinking-sql-server-data-files-best-practices-and-why-it-sucks/", "published_at": "2016-11-08T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b2bab476", "title": "Adaptive Query Processing (Dear SQL DBA Episode 21)", "url": "https://kendralittle.com/2016/11/03/whats-adaptive-query-processing-dear-sql-dba-episode-21/", "published_at": "2016-11-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b2d550af", "title": "SQL Server Query Store - Filegroups and Adhoc Workloads", "url": "https://kendralittle.com/2016/11/01/sql-server-query-store-filegroups-and-adhoc-workloads/", "published_at": "2016-11-01T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b2e707e7", "title": "Thoughts from the SQLPASS Summit Wednesday Keynote, 2016", "url": "https://kendralittle.com/2016/10/26/thoughts-from-the-sqlpass-summit-wednesday-keynote-2016/", "published_at": "2016-10-26T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b3bd877f", "title": "Wildcard vs Regular Expressions - Lucene Query in Azure Search", "url": "https://kendralittle.com/2016/10/25/wildcard-vs-regular-expressions-lucene-query-in-azure-search/", "published_at": "2016-10-25T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b49bbec3", "title": "Where do You Get Your Creativity? (Dear SQL DBA Episode 20)", "url": "https://kendralittle.com/2016/10/20/where-do-you-get-your-creativity-dear-sql-dba-episode-20/", "published_at": "2016-10-20T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b5769436", "title": "Decoding Key and Page WaitResource for Deadlocks and Blocking", "url": "https://kendralittle.com/2016/10/17/decoding-key-and-page-waitresource-for-deadlocks-and-blocking/", "published_at": "2016-10-17T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b64e51cf", "title": "Should You Rebuild or Reorganize Indexes on Large Tables? (Dear SQL DBA Episode 19)", "url": "https://kendralittle.com/2016/10/13/should-you-rebuild-or-reorganize-indexes-on-large-tables-dear-sql-dba-episode-19/", "published_at": "2016-10-13T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b73200d8", "title": "Books to Learn SQL Server Performance Tuning and Database Design", "url": "https://kendralittle.com/2016/10/11/books-to-learn-sql-server-performance-tuning-and-database-design/", "published_at": "2016-10-11T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b82f0f77", "title": "Can I Use Statistics to Design Indexes? (Dear SQL DBA Episode 18)", "url": "https://kendralittle.com/2016/10/06/can-i-use-statistics-to-design-indexes-dear-sql-dba-episode-18/", "published_at": "2016-10-06T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b865de0d", "title": "Last Minute Coupon Code for 2016 SQLPASS Summit", "url": "https://kendralittle.com/2016/10/05/last-minute-coupon-code-for-2016-sqlpass-summit/", "published_at": "2016-10-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b8f31baa", "title": "Track Query Tuning Progress and History in Plan Explorer", "url": "https://kendralittle.com/2016/10/04/track-query-tuning-progress-and-history-in-plan-explorer/", "published_at": "2016-10-04T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8b9cf8552", "title": "Setting up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)", "url": "https://kendralittle.com/2016/09/29/setting-up-free-blocking-alerts-and-deadlock-monitoring-dear-sql-dba-episode-17/", "published_at": "2016-09-29T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ba7ea031", "title": "Measuring Query Duration: SSMS vs SQL Sentry Plan Explorer", "url": "https://kendralittle.com/2016/09/27/measuring-query-duration-ssms-vs-sql-sentry-plan-explorer/", "published_at": "2016-09-27T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bb745a98", "title": "Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)", "url": "https://kendralittle.com/2016/09/22/indexing-foreign-keys-guidelines/", "published_at": "2016-09-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bc0762b4", "title": "Index Tuning Decision Tree for SQL Server", "url": "https://kendralittle.com/2016/09/20/index-tuning-decision-tree-for-sql-server/", "published_at": "2016-09-20T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bced8ac4", "title": "Deadlock Code for the WideWorldImporters Sample Database", "url": "https://kendralittle.com/2016/09/13/deadlock-code-for-the-wideworldimporters-sample-database/", "published_at": "2016-09-13T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bd904329", "title": "Unique Constraints vs Unique Indexes", "url": "https://kendralittle.com/2016/09/08/unique-constraints-vs-unique-indexes/", "published_at": "2016-09-08T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bde2e1d1", "title": "Estimated vs. Actual Number of Rows in Nested Loop Operators", "url": "https://kendralittle.com/2016/09/06/estimated-vs-actual-number-of-rows-in-nested-loop-operators/", "published_at": "2016-09-06T00:00:00+00:00" } ] posts Claim your blog
Back to kendralittle.com
Blog · corpus.blog/blogs/kendralittle.com/posts

kendralittle.com

kendralittle.com

2017

How Much Longer Does it Take To Update Statistics with FULLSCAN?original ↗
14 Jun 2017
When does a Snapshot Transaction Really Begin?original ↗
12 Jun 2017
When does physical reads include read-ahead reads in SQL Server?original ↗
7 Jun 2017
Top 5 Misleading SQL Server Performance Countersoriginal ↗
5 Jun 2017
Register for Upcoming Free Webcasts on Indexes, Stats Maintenance, Query Tuning, and Moreoriginal ↗
2 Jun 2017
Database Mirroring Counters Missing from Perfmon?original ↗
31 May 2017
Why I am Inspired to Start Up Live Webcasts Againoriginal ↗
26 May 2017
Finding Queries that Cause Wait Stats in SQL Serveroriginal ↗
25 May 2017
When a Nonclustered Index and Statistics Make a Query Sloweroriginal ↗
24 May 2017
Removing Query Hints with Plan Guides (Dear SQL DBA Episode 43)original ↗
18 May 2017
Perfmon: Batch Requests/sec counts whole batches, not statementsoriginal ↗
16 May 2017
Batch Mode Hacks for Rowstore Queries in SQL Serveroriginal ↗
11 May 2017
New Course! Query Tuning with Hints & Optimizer Hotfixesoriginal ↗
10 May 2017
SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)original ↗
8 May 2017
Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)original ↗
4 May 2017
Checking for the Existence of Global Temp Table in TSQLoriginal ↗
3 May 2017
Use Report View in Perfmon to Compare Database Counters (free video)original ↗
1 May 2017
How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)original ↗
27 Apr 2017
Error 1204: When SQL Server Runs Out of Locksoriginal ↗
26 Apr 2017
Run perfmon.exe /sys to Remember Your Counters in Windows Perfmon (free video)original ↗
24 Apr 2017
Are Bad Statistics Making My Query Slow? (Dear SQL DBA Episode 39)original ↗
20 Apr 2017
Trace Flag 4199: No Per-Session Override if You Enable it Globallyoriginal ↗
19 Apr 2017
Index Maintenance and Performance (Dear SQL DBA Episode 38)original ↗
13 Apr 2017
Will Optimize for Adhoc Workloads Save Memory?original ↗
12 Apr 2017
Poster in the works: SSMS Shortcuts Explained by Catsoriginal ↗
10 Apr 2017
Lock Timeouts & Memory (Dear SQL DBA Episode 37)original ↗
6 Apr 2017
Selectively EnableTrace Flag 4199 and QUERY_OPTIMIZER_HOTFIXES in SQL Server 2016original ↗
5 Apr 2017
Reviving Healthy Work Habits: Toggl and Weekly Highlightsoriginal ↗
3 Apr 2017
Which Locks Count Toward Lock Escalation?original ↗
3 Apr 2017
Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)original ↗
30 Mar 2017
The Case of the Blocking Online Index Create- the Shared Lock that Would Not Quitoriginal ↗
28 Mar 2017
New weekly newsletter: a SQL Server quiz, poll or cartoon each weekoriginal ↗
27 Mar 2017
New Freebie Course: SSMS Shortcuts & Secretsoriginal ↗
23 Mar 2017
When SQL Server Does NOT Use Write Ahead Logging (Dear SQL DBA Episode 35)original ↗
23 Mar 2017
Columnstore Index Returns Zero Rows... Which is One Roworiginal ↗
21 Mar 2017
Time for an Interview: What accomplishment are YOU most proud of?original ↗
20 Mar 2017
Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)original ↗
16 Mar 2017
Data Type Mismatches Do Not Always Cause a Bad Implicit Conversion and Index Scanoriginal ↗
15 Mar 2017
Why Indexes Reduce Locks for Update and Delete Queriesoriginal ↗
14 Mar 2017
Stack Dumps in SQL Server (Dear SQL DBA Episode 33)original ↗
9 Mar 2017
Overindexing: Missing Index DMVs and the Database Tuning Advisororiginal ↗
8 Mar 2017
How to Quickly Tell if an Execution Plan has Multiple Missing Index Requestsoriginal ↗
7 Mar 2017
New Course: Tuning Problem Queries in Table Partitioningoriginal ↗
2 Mar 2017
WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)original ↗
2 Mar 2017
DBCC CLONEDATABASE Does NOT Clone Index Usage Statisticsoriginal ↗
28 Feb 2017
The BabbyNames Sample Database - Now on GitHuboriginal ↗
28 Feb 2017
Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)original ↗
23 Feb 2017
Understanding avg_total_user_cost and avg_user_impact in Missing Index Requestsoriginal ↗
22 Feb 2017
Adding Partitions to the Lower End of a Left Based Partition Functionoriginal ↗
21 Feb 2017
Confused by sp_who2 (Dear SQL DBA Episode 30)original ↗
16 Feb 2017
The Top 3 Mistakes I Made Fighting Blockingoriginal ↗
16 Feb 2017
New online course: Troubleshooting Blocking & Deadlocks for Beginners (Free!)original ↗
14 Feb 2017
Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)original ↗
9 Feb 2017
Understanding Left vs. Right Partition Functions (with Diagrams)original ↗
7 Feb 2017
Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes (Dear SQL DBA Episode 28)original ↗
2 Feb 2017
Which Filegroup is that Partition Using? How Many Rows Does It Have?original ↗
31 Jan 2017
What is that Garbage in my Execution Plan? (Dear SQL DBA Episode 27)original ↗
26 Jan 2017
How to Find Queries Using an Index (and Queries Using Index Hints)original ↗
24 Jan 2017
Why You Should Switch in Staging Tables Instead of Renaming Them (Dear SQL DBA Episode 26)original ↗
19 Jan 2017
Bug: Incorrect modification_counter for Column Stats on Tables with a Clustered Columnstore Indexoriginal ↗
17 Jan 2017
How to Query Histogram Target XML in Extended Eventsoriginal ↗
12 Jan 2017
Administering COTS databases (ISVs / Third Party Vendors)original ↗
10 Jan 2017
Configure Fields and Predicates for Multiple X-Eventsoriginal ↗
5 Jan 2017
Parallelism and tempdb data file usage in SQL Serveroriginal ↗
3 Jan 2017

2016

Columnstore Indexes and Computed Columns in SQL Server 2016original ↗
29 Dec 2016
Tracing Deadlock Graphs: Extended Events or Server Side Traceoriginal ↗
27 Dec 2016
Collecting the Blocked Process Report (XEvents and Server Side Trace)original ↗
22 Dec 2016
Actual Time Statistics in Execution Plans: Elapsed CPU Time and moreoriginal ↗
20 Dec 2016
Limiting Downtime for Schema Changes (Dear SQL DBA Episode 25)original ↗
15 Dec 2016
Index Create and Last Modified Dates in SQL Serveroriginal ↗
13 Dec 2016
Does Truncate Table Reset Statistics?original ↗
8 Dec 2016
When Did SQL Server Last Update That Statistic? How Much Has Been Modified Since? And What Columns are in the Stat?original ↗
6 Dec 2016
Signs Your SQL Server is Running with Scissors (Dear SQL DBA Episode 24)original ↗
1 Dec 2016
Learn to Tune Indexes in Lisbon on March 9, 2017original ↗
30 Nov 2016
How to Tune Indexes for a Stored Procedureoriginal ↗
29 Nov 2016
Why is My Query Faster the Second Time it Runs? (Dear SQL DBA Episode 23)original ↗
25 Nov 2016
Should I change the locks configuration in SQL Server?original ↗
22 Nov 2016
Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)original ↗
17 Nov 2016
SQL Server 2016 SP1: Features Added to Standard, Web, Express, Local DB Editionsoriginal ↗
16 Nov 2016
Downgrading the SQL Server Edition of a Dev Environmentoriginal ↗
15 Nov 2016
Filtered Indexes: Rowstore vs Nonclustered Columnstoreoriginal ↗
10 Nov 2016
Shrinking SQL Server Data Files - Best Practices, and Why It Sucksoriginal ↗
8 Nov 2016
Adaptive Query Processing (Dear SQL DBA Episode 21)original ↗
3 Nov 2016
SQL Server Query Store - Filegroups and Adhoc Workloadsoriginal ↗
1 Nov 2016
Thoughts from the SQLPASS Summit Wednesday Keynote, 2016original ↗
26 Oct 2016
Wildcard vs Regular Expressions - Lucene Query in Azure Searchoriginal ↗
25 Oct 2016
Where do You Get Your Creativity? (Dear SQL DBA Episode 20)original ↗
20 Oct 2016
Decoding Key and Page WaitResource for Deadlocks and Blockingoriginal ↗
17 Oct 2016
Should You Rebuild or Reorganize Indexes on Large Tables? (Dear SQL DBA Episode 19)original ↗
13 Oct 2016
Books to Learn SQL Server Performance Tuning and Database Designoriginal ↗
11 Oct 2016
Can I Use Statistics to Design Indexes? (Dear SQL DBA Episode 18)original ↗
6 Oct 2016
Last Minute Coupon Code for 2016 SQLPASS Summitoriginal ↗
5 Oct 2016
Track Query Tuning Progress and History in Plan Exploreroriginal ↗
4 Oct 2016
Setting up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)original ↗
29 Sept 2016
Measuring Query Duration: SSMS vs SQL Sentry Plan Exploreroriginal ↗
27 Sept 2016
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)original ↗
22 Sept 2016
Index Tuning Decision Tree for SQL Serveroriginal ↗
20 Sept 2016
Deadlock Code for the WideWorldImporters Sample Databaseoriginal ↗
13 Sept 2016
Unique Constraints vs Unique Indexesoriginal ↗
8 Sept 2016
Estimated vs. Actual Number of Rows in Nested Loop Operatorsoriginal ↗
6 Sept 2016
Previous Next