This blog explains the various methods that can be applied for representing NULL values while generating a XML document using T-SQL FOR XML statement. Based on your actual requirement you can opt for any of the methods to get the…
SSIS Tips: Performing Cross Join Using Merge Join Transform in SSIS
Question Can we perform cross join (cartesian product) operation using Merge Join transform in SSIS? Scenario The above question was asked in one of the social forums recently. I was able to give the response to this.I’m sharing the solution…
T-SQL Tips: Execute Individual Packages in Project Deployment Model using Dtexec
Question Can we execute individual packages included in a SSIS 2012 project configured in project deployment model using dtexec utility? Scenario The above question was the main topic of discussion in one of the recent casual conversations with my fellow…
T-SQL Tips: Solving FORMAT function woes for time datatype
Impetus The purpose of this blog is to clarify the confusion regarding the behavior of FORMAT function with the time datatype in SQL Server Scenario It all started with a discussion that happened in one of the groups. A person…
SQLServer Tips: Distributed Query Issues With ACE Provider in 64 bit
Here is another quick blog on solution for an issue you may face while working with ACE provider in 64 bit windows server ScenarioA colleague of mine came to me today morning with an issue. He was trying out few…
SQL Server Data Tools BI Installation Issues on Windows 10
This is a short blog to share the details of an issue that you may face while installing SQL Server Data Tools for BI (SSDT-BI) on Windows 10 ScenarioYou’ve a laptop or desktop which you upgraded to Windows 10 recently…
Guest Post: Shrink the SQL Database Log File!
For the first time I’m introducing a guest blogger through this post.Priyanka Chouhan has gladly volunteered to be the guest blogger for us. She has come up with an informative article on shrinking log file which you can read below.…
SSMS Tips: How to Get This Debug Button Away From My Execute Button?
This has been an annoying issue for me many times.The positioning of Debug button so close to Execute button in SQL Editor toolbar has caused me to hit Debug by mistake which would launch the debugger many times when all…
ANSI NULLS Behavioral Difference – Variables vs Literals
ImpetusThe impetus for writing this blog comes from a recent interesting discussion that happened in one of the groups.The topic of discussion was regarding ANSI NULL setting behavior. There is a difference in the way ANSI NULLS setting works while…
In Memory Tables vs Table Variables – Comparison
IntroductionRecently there was a casual discussion with one of my colleagues who was asking me regarding the newly introduced memory-optimized tables in SQL Server 2014. The discussion went through few aspects of memory-optimized tables and their comparison against table variables. This blog…