Databases

For building recursive queries In SQL Server 2005 we have to use a new functionality called Common Table Expressions. Let's see how we can retrieve all the employees that...

LAG - http://msdn.microsoft.com/en-us/library/hh231256.aspx USE AdventureWorks2012; GO SELECT BusinessEntityID, YEAR(QuotaDate) AS SalesYear, SalesQuota AS CurrentQuota, LAG(SalesQuota, 1,0) OVER (ORDER BY YEAR(QuotaDate)) AS PreviousQuota FROM Sales.SalesPersonQuotaHistory WHERE BusinessEntityID = 275...

If the datasources of the Merge Join block in SSIS aren't sorted the merge will not work correctly. Strange behavior will occur if the datasources aren't sorted equal by the...

NoSQL databases introduction and dominant features. A historical perspective to their appearance in a world dominated by relational model databases.

I had to recreate a table in SQL Server just because it was created with ANSI_NULLS ON Here you can check the requirements to create a persisted  computed column on...

Introdução O Sql Server possui um mecanismo de pesquisa de texto com base na indexação de colunas de tabelas numa base de dados chamado Full-Text Search. Este mecanismo de pesquisa...

Today, i needed to reset the Identity value for one column in the SQL Server database. I used the following commando to view the current identity value: ...

Last week I delivered a session at SharePoint Portuguese Community 36th event. My session was entitled SharePoint Tunning, focused on techniques used to improve the performance of a SharePoint farm. The main topics of the...

Following up on this article about querying JSON Data I would like to talk about how to improve searches on JSON data inside SQL Server. Starting SQL Server 2016...

This post will explain how to provision a database programmatically in a Azure SQL database and add it to an Azure SQL failover group. Introduction An Azure SQL Server failover group...