SQL Server – Identify Unused Indexes

Within SQL Server an index is used to optimise the reading of data from the database. However the side effect of having such an index is reduced write speed for inserts and updates. This is because SQL Server will need to update and maintain the index. Running the below SQL…

Azure SQL Database View Running Transactions / Blocking

With the Azure SQL Database, sometimes you want to view the current running transactions. Unfortunately there is no GUI as such like there is with normal SQL Server (right click, “Activity Monitor”), however it can be grabbed by executing sys.dm_exec_requests. The following SQL is very useful as it shows details…

Dynamics NAV RTC – Page Slow to Load – Flowfields

With Microsoft Dynamics Nav, it is possible to add a “FlowField” to a table. This flow field is then calculates an aggregate of an underlying table. Typical uses are to perform the following calculations: Sum Average Min Max Count Additionally, the following non-aggregate functions are available: Lookup Exists Typical values…