SQL Server Education (by the geeks, for the geeks)
If you want to identify non parameterized queries that are hogging your SQL Server plan cache then you are at the right place. sys.dm_exec_query_stats DMV becomes very handy when we are …
Read MoreIn this blog post, we will see how deadlocks can happen in SQL Server due to Bookmark Lookups. Let’s create a dummy table WideWorldImporters & associated indexes. This will be our …
Read MoreIn our previous blog posts, we have seen how to find fragmented indexes in a database and how to defrag them by using rebuild/reorganize. While creating or rebuilding indexes, we can …
Read MoreIn our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how to defrag indexes. According to Microsoft guidelines, …
Read MoreWe do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the data will get spread across the disc …
Read MoreBefore we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice is to have a clustered index on …
Read MoreIn this blog post, we will see how SQL Server optimises Tempdb logging for faster CRUD operations. For the purpose of this tutorial, we will perform the same operations in a …
Read MoreThe phrase Sargability is quite popular in SQL Server world. Wikipedia says: “In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine …
Read MoreWhile SQL Server runs on Linux, the SQL Server Analysis Service (SSAS) is a different service intended for Microsoft SQL Server – so addressing the hardware configuration requires a bit of …
Read MoreFollow DataPlatformGeeks on LinkedIn and remain updated on our upcoming virtual events and webinars. April is here and we are ready with our webinars and virtual events. Week of Apr 6 …
Read More