Browse by Tags
All Tags »
SQL Server (
Get this RSS feed)
This is often an issue when you get a SQL Backup from a customer to analyse. Off course you can create a user on SQL and change the password, but it is easier. Navision stores the users into two tables. User and 'Windows Login', The first table is for database logins, the latter for Windows Logins...
This tip is about the SQL Server Management studio again. Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL. The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users. Let's look...
In my previous tip ( http://dynamicsuser.net/blogs/mark_brummel/archive/2009/06/13/tip-6-find-locked-records.aspx) I showed you how to find which exact records are locked and 'proved' row locking with the 'LOCKTABLE' command. But even then you can eperience another fact. Sometimes SQL...
Sometimes, when you investigate performance issues you see users blocking each other on small tables with good indexes and small locks. In that case it can be very interesting to know exactly which record in the table is locked and which records are available. That is what this tip is about. Most hardcore...
BE CAREFUL : NEVER IMPLEMENT A HOTFIX IF IT IS NOT NESSESAIRY THIS IS A VERY NEW HOTFIX AND IT MIGHT CONTAIN ERRORS For everyone who is involved in the art of performance tuning of the Dynamics NAV (Navision) product on SQL Server 2005 I would like to focus some attention on this hotfix. Slow performance...
After all the theory about VSift in my previous blog posts now a tip about how to tune VSIFT. Before I continue first this. VSift is not a bad technology but the implementation in NAV has one big downside. The good old SIFT levels have disapeared. In older versions of NAV there was a SIFT Level property...
With the introduction of VSIFT, a new perception was introduced. There are no more Zero SIFT records. More about VSift in http://dynamicsuser.net/blogs/mark_brummel/archive/2009/04/12/vsift-the-day-after.aspx With the classic SIFT it was possible to have SIFT records that did not contain any totals....
This time another tip on how to use the SQL Management Studio. Dynamics NAV (Navision) keeps a copy of all tables on SQL server for each company you create, no matter if the table is populated or not. This way of creating tables can lead to a long list of tables in the SQL Management Studio. Expanding...
Some time ago a new technology for SIFT was introduced. SIFT is a technology that makes it possible in NAV to use the flowfields with the powerfull flowfilter technology. It stands for Sum Index Flow Techology. In the classic database the flowfield data was kept at index level. SQL does not have these...
Time for some tips about how to use the SQL Server Management Studio. This is a really great tool which should be more used by NAV DBA's. First tip is how to include column headers when copying query results. This is something we often use when analysing systems remotely. When opening the management...
That's the question. It's about two years ago since I started working with Liberty Grove Software, a certified upgrade service center. I've helped them establish a european office. Since that time we've done about 12 upgrades together. Upgrades has always been a problem in the Navision...
Hi all, Hynek at SQL Perform asked me to publish something about a myth being spread by some Microsoft specialists. MYTH: "Make sure that the order of the fields used for filtering is the same as order of these fields in the key." REALITY: Certainly the order of the filtering does NOT matter...
Just recently SQL 2008 got status RTM and is ready to use in production systems. At SQL Perform we are always very careful with new releases and eager to test them for performance, reliability and management capabilities. What better way to start than with your own database. So we installed SQL 2008...
As promised I have some results from the tests. So we compared HP ML 370 with 14 SAS disks dedicated to a HP DL380 with data on a HP MSA2000 SAS SAN running on VMWare with the same amounts of disks. The DL380 is running on VMWare. The OS is on a shared storrage with the OS of the other VMWare machines...
SQL and NAV is hot these days. More and more knowledge becomes available and more companies and freelancers start helping customers tuning their databases. Most of the problems exist in "older" databases. Especialy early version 3 databases have difficulties performing. Fortunalely version...
More Posts
Next page »