SQL Stash
Repeatable Reads
RSSTwitterFacebookLinkedIn
  • About Me

FIRST_VALUE and LAST_VALUE – New SQL Functions

By Simon On July 21, 2011 · Add Comment · In T-SQL
Here’s something that many people have been requesting for sometime. The next version of SQL Server (codename Denali, but I suspect will end up being called SQL Server 2012) now support FIRST_VALUE() and LAST_VALUE(). Bizarrely database like MS Access (yes Access) have supported this for years. This is very useful. Often when aggregating data you [...]
[Continue Reading...]

Denali and High Availability

By Simon On May 12, 2011 · Add Comment · In SQL Server
Denali has been around in CTP for a while now and MS are making a big play about HA (High Availability). High Availability has been put into two distinct groups, database and instance. The difference being that database is the actual database with data being available “somewhere” – be it your primary server or another. [...]
[Continue Reading...]

Using Common Table Expressions to find the Top item within an aggregate

By Simon On May 10, 2011 · 4 Comments · In T-SQL
Common Table Expressions (CTE) were introduced into SQL Server 2005. The primary purpose was to perform recursive queries – a big plus feature to SQL Server. However they can also be used for many other purposes too. A problem I was recently presented with was to take a common GROUP BY query that showed sales [...]
[Continue Reading...]

Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

By Simon On May 5, 2011 · Add Comment · In Certification
Today I took and passed the 70-451 exam. I took the prerequisite exam 70-433 a few days prior. So I now have the certification of MCITP, but what does that mean? I didn’t do any prep work for either exam other than reading the “skills measured” section on the MS site. I felt confident of [...]
[Continue Reading...]

Comma Separating Data

By Simon On May 3, 2011 · Add Comment · In T-SQL
A typical conversation with a product manager: Product Manager: “Hey SQL Dev guy – you know that report split by x” SQL Dev guy: “I do” Product Manager: “Well can you add an extra split by y?” SQL Dev guy: “Easy, but the report will be nonsense” Product Manager: “Err, you what?” SQL Dev Guy: [...]
[Continue Reading...]
  • Categories

    • Certification
    • SQL Server
    • T-SQL
  • Recent Posts

    • FIRST_VALUE and LAST_VALUE – New SQL Functions
    • Denali and High Availability
    • Using Common Table Expressions to find the Top item within an aggregate
  • Recent Comments

    • T-SQL Tuesday #18 Wrapup | Bob Pusateri - The Outer Join on Using Common Table Expressions to find the Top item within an aggregate
    • simon on Using Common Table Expressions to find the Top item within an aggregate
    • Bob Pusateri on Using Common Table Expressions to find the Top item within an aggregate
    • Naomi on Using Common Table Expressions to find the Top item within an aggregate
  • Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
  • About Me
SQL Stash