Converting a Vertical Table to an Horizontal Table in SQL Server
Today I've encountered a vertical table in an SQL Database and I wanted to transform it to an horizontal one. A vertical table is described as an EAV model.
Imagine...
SQL Persisted Computed Column ANSI_NULLS
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...
How to Access the Previous Row and Next Row value in SELECT statement?
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...
Strange behavior with “Merge Join” in SSIS
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...
SharePoint Tunning Session
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...
Reset Identity value
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: ...
Full-Text Search: Actualizar múltiplos cátalogos de pesquisa
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...
Recursive Queries in SQL Server 2005
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...
Webcasts: SOA, WSE, Biztalk
Os webcasts da MS são das formas mais interessantes de ter overviews rápidos de determinada tecnologia ou tema. De entre os webcasts dos próximos dias, seleccionei os seguintes, que...