(Kris Wenzel) Both Joins and UNIONS can be used to combine data from two or more tables. Read this article to find out each command’s strengths and when to use them.
Tag: sql server
#0360 – SQL Server – sp_attach_db v/s CREATE DATABASE FOR ATTACH – Number of files limitation; Msg. 8144 (Procedure has too many arguments specified)
(Nakul Vachhrajani) This post has been a long time coming. I am an advocate of using newer T-SQL and administrative features if situation and compatibility related business requirements allow.
SQL SERVER – Script: Finding queries without JOIN Predicates
(Pinal Dave) I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time to take a pause f
What Is the Difference Between a Join and a UNION?
(Kris Wenzel) Both Joins and UNIONS can be used to combine data from two or more tables. Read this article to find out each command’s strengths and when to use them.
#0360 – SQL Server – sp_attach_db v/s CREATE DATABASE FOR ATTACH – Number of files limitation; Msg. 8144 (Procedure has too many arguments specified)
(Nakul Vachhrajani) This post has been a long time coming. I am an advocate of using newer T-SQL and administrative features if situation and compatibility related business requirements allow.
SQL SERVER – Script: Finding queries without JOIN Predicates
(Pinal Dave) I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time to take a pause f
Purging Entity Members in SQL Server Master Data Services
(Koen Verbeeck) I have an entity in SQL Server Master Data Services where the code value is not generated automatically. I deleted a member and now I want to add a new member with the same code, but instead I get an error. How is this possible and how can I resolve this?
Clustered Columnstore Index: Enforcing uniqueness constraint in table
(Sunil Agarwal) SQL Server introduced ‘updateable’ clustered columnstore index (CCI) starting with SQL Server 2014 to speed up analytics by orders of magnitude up to 100x while significantly reducing storage, typically 10x.
Azure BizTalk Services: Connecting to On-Premises Resources
(Matt Milner) By moving applications to Azure, you can’t always avoid the requirement for accessing data from applications that are based within your intranet. You have a wide range of choices for doing this.
Sort using Hierarchyid of SQL Server 2008
(Niladri Biswas) SQL Server 2008, introduced the hierarchyid. This is basically use for storing the hierarchical data. Though it’s been a long time that it got introduced, recent use of this feature and in this article experience of that is shared.