SQL – Page 11 – Pardaan.com

NAV2015: MODIFYALL behaviour on SQL Server

I’ve just spent an evening on something that I noticed earlier in one of my projects that wasn’t clear to me. And when you don’t understand something? You write blogposts, right? Bron : Waldo's Blog Lees meer...

27 January 2015

Dynamics NAV & BC Tips & tricks

Using SQL Server Extended Events to produce a Blocked Process Report

Blocking in SQL Server is a mixed blessing! It is a SQL Server’s way of ensuring data integrity which is a basic requirement for any database management system but when users encounter a lot of blocking it makes the application appear slow and sometimes unusable. Therefore,…

26 January 2015

Dynamics NAV & BC Tips & tricks

Restore fails with error “The media set has 2 media families but only 1 are provided. All members must be provided.”

I was trying to restore a SQL backup (.bak) file of NAV2013R2 and got this error message. Bron : Mohana's Dynamics NAV Blog Lees meer...

1 January 2015

Dynamics NAV & BC Tips & tricks

High Performance SQL Views Using WITH(NOLOCK)

Every now and then you find a simple way to make everything much faster. We often find customers creating data warehouses or OLAP cubes even though they have a relatively small amount of data (a few gigs) compared to their server memory. If you have more…

16 July 2014

Dynamics NAV & BC Tips & tricks

SQL kill inactive NAV sessions

// KILL SQL INACTIVE SESSIONS FOR NAV APPLICATIONS // ONLY FOR SLEEPING SESSIONS a very Simple SQL Stored Procedure to 'kill' sql inactive sessions idle (sleeping) for 10 minutes related to "Nav Client" applications Bron : Around Dynamics NAV World Lees meer...

16 July 2014

Dynamics NAV & BC Tips & tricks

Synchronize metadata, please…

One of new procedures/functions we have in NAV 2013 R2 is “metadata synchronization”. It is process when object (table) description done in C\SIDE by NAV developer is applied to SQL object (object structure in SQL becomes the same as we have in NAV object designer). Bron…

8 July 2014

Dynamics NAV & BC Tips & tricks

AR Aging Report in SQL For Dynamics NAV

I had posted a while back the Inventory Valuation sql query that can be used to run the report on sql server. SQL reports run much faster than NAV report because sql is doing all the data crunching and aggregation. Below is the sql statement for…

7 July 2014