This is the second part of my two-part article on windowing functions in SQL Server 2012. In Part 1, I explained the new running and sliding aggregation capabilities added to the OVER clause in SQL Server 2012. In this post, I’ll explain the new T-SQL analytic windowing functions. All of these functions operate using the [...]
Also posted in SQL Server | Tagged SQL Server 2012 |
The first windowing capabilities appeared in SQL Server 2005 with the introduction of the OVER clause and a set of ranking functions (ROW_NUMBER, RANK, DENSE_RANK, and NTILE). The term “window,” as it is used here, refers to the scope of visibility from one row in a result set relative to neighboring rows in the same [...]
Also posted in SQL Server | Tagged SQL Server 2012 |
This month, Microsoft awarded 143 exceptional technical community leaders with the Most Valuable Professional (MVP) title and re-awarded 764 MVPs worldwide. Tallan is thrilled to announce that Lenni Lobel has been recognized as an MVP in SQL Server!
According to the Microsoft MVP Award Program Blog, there are more than 100 million social and technical community [...]
Also posted in SQL Server | Tagged SQL, SQL Server |
FILESTREAM is a powerful feature in SQL Server that stores varbinary(max) column data (BLOBs) in the file system (where BLOBs belongs) rather than in the database’s structured file groups (where BLOBs kill performance). This feature was first introduced in SQL Server 2008, and is now being expanded with the new FileTable feature coming in SQL [...]
With SQL Server Denali CTP3 released just two weeks ago, I’ve been ramping up fast as I write the new edition of Tallan’s SQL Server book (Programming Microsoft SQL Server 2012, O’Reilly) and prepare for upcoming presentations at the NJSQL User Group (Sep 20) and the SDC event in the Netherlands (Oct 2/3). I recently [...]
One useful feature in SQL Server is something called the OVER clause. The OVER clause has been available since SQL Server 2005 and allows you to perform window functions over a set of data. SQL Server provides two types of window functions: aggregate window functions and ranking window functions. I will explain what aggregate [...]
Also posted in SQL Server | Tagged SQL, SQL Server, TSql |
I had a situation today where I have a stored procedure that is structured as follows:
1 CREATE PROCEDURE _Entity_GetByKeywordTypeDateRange(
2 @keyword varchar(255) = null,
3 @typeA bit = 0,
4 @typeB bit = 0,
5 @typeC bit = [...]
Metadata Management- Fun stuff, right? Depending on what your relationship to an organization’s data is, it can have many different meanings. Database developers and administrators tend to focus on technical metadata, which provides descriptive information on table structures, job streams, ETL mappings, data lineage, etc.
Business users have a need for metadata as well. Attribute definitions, [...]
In the month of July we’re going to be holding a FREE, half-day, hands-on workshop on MDX and Analysis Services around the country.
If you’re in the Los Angeles, New York City or Hartford, CT areas, come join us. We’ll be deconstructing real-world examples and in the process explaining important things to consider in how Analysis Services handles [...]
Also posted in Analysis Services |