Learn more about SQL Server tools

   
   



















































SQL Server Developer Tips and Tricks


Latest SQL Server Tips
Query Folding in Power Query to Improve Performance
Power Query, an Excel add-in from the Power BI family, allows you to extract and manipulate data from various sources. When you define transformations on the data, it is possible that those transformations are sent back to the source, in order to improve performance. This feature is called query folding and itís very important for in Power Query. In this tip we will discuss query folding, how you can take advantage from it and how to make sure qu
What's Trending?
Query Folding in Power Query to Improve Performance
Power Query, an Excel add-in from the Power BI family, allows you to extract and manipulate data from various sources. When you define transformations on the data, it is possible that those transformations are sent back to the source, in order to improve performance. This feature is called query folding and itís very important for in Power Query. In this tip we will discuss query folding, how you can take advantage from it and how to make sure qu
SQL Server Tutorials
SQL Server Webcasts
Improving SQL Server Performance by Writing Faster T-SQL Code
Stored procedures and functions are the mainstay of SQL Server coding. In this session you will learn techniques to locate problematic code and to improve the performance of procedures and functions.

Step one is to discover where the time is going using standard server traces, code that analyzes the trace, and the new SQL Server Extended Events. Once we know where the time is going we will look at strategies to improve performanc
All Categories

 
Sponsor Information