Tag: Field

Five Tips on Understanding SQL Server Better

Being a developer I often find myself in situations where I need to troubleshoot SQL queries that are not performing well and generally need optimizations. I would like to share some interesting tips on how SQL Server handles queries and what execution plans might be better than others. A query execution plan is an ordered set of steps that are used to access the data in SQL server. If you are working with SQL Server Management Studio once you have started a new query window click the following button  (or CTRL + M) so you can enable execution plans. In the examples below I will be using tables from AdventureWorks database which is a sample database provided by Microsoft.

Read More »

3 Steps to See if You are Web Client Ready

If you are involved in the Microsoft Dynamics world, in any capacity, chances are you have heard the latest buzzword “web client” quite a bit as of late. However, there are three key factors everyone should know about the web client before you call your VAR and tell them you are ready.  

Read More »