SQL Server Education (by the geeks, for the geeks)
Hi Friends, SQL Server uses histograms from statistics objects to estimate cardinality of a query and this helps SQL Server to produce an optimal execution plan. Query optimizer has to inspect …
Parameter sniffing in SQL Server Read MoreHello Geeks and welcome to the Day 71 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_merge_requests – Day 71 – One DMV a Day Read MoreHello Geeks and welcome to the Day 70 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_hash_index_stats – Day 70 – One DMV a Day Read MoreHello Geeks and welcome to the Day 69 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_object_stats – Day 69 – One DMV a Day Read MoreHi Friends, When we update any data which has to modify and update existing non-clustered index using per row is also known as SQL Server narrow plans. In per row operations …
SQL Server narrow plans (per-row) Read MoreHello Geeks and welcome to the Day 68 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_checkpoint_stats – Day 68 – One DMV a Day Read MoreHello Geeks and welcome to the Day 67 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_checkpoint_files – Day 67 – One DMV a Day Read MoreHi Friends, I wish to congratulate our new SQL Rock-stars of SQLServerGeeks.com; (not in any specific Order) Manohar Punna Ahmad Osama Kanchan Bhattacharyya Prince Rastogi They have shown a new …
SQL Rockstars completed Half-century for SQL series Read MoreHello Geeks and welcome to the Day 66 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_xtp_transaction_stats – Day 66 – One DMV a Day Read MoreHello Geeks and welcome to the Day 65 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_db_xtp_transactions – Day 65 – One DMV a Day Read More