Harsha's

Wednesday, October 7, 2015

Nice article about partitioning

Table Partitioning
Posted by Harsha Vardhan Lella at 1:31 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, October 5, 2015

Physical Joins

Nice articles from msdn blogs. Credits to Craig Freedman

Nested Loop Joins


Merge Joins


Hash Joins



Posted by Harsha Vardhan Lella at 10:46 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Facebook Badge

Harsha Vardhan Lella

Create Your Badge

About Me

My photo
Harsha Vardhan Lella
Strong SQL Server Database/BI Developer with extensive experience in designing database applications using SQL Server Technologies (Worked on SQL Server 2005/2008/2008R2/2012) Strong in T-SQL coding (Stored Procedures, Triggers, Functions, Views, Table partitioning) and Database architecting Core Areas of Expertise: T-SQL Programming, Query optimization, Reporting Services (SSRS) and Integration Services (SSIS) Very good experience in taking the role as a team player/lead the project/work alone on project depending on the team's requirement Technical Skills: SQL Server from 2005 until 2012 Team Foundation Server (2010) Visual Studio IDE (2005/2008/2010) Integration Services Reporting Services Programming Skills: T-SQL (expertise experience) VB.NET (Beginner) SCOPE scripting language (Used to retrieve data from COSMOS. Microsoft exclusive)
View my complete profile

Blog Archive

  • ►  2020 (3)
    • ►  December (1)
    • ►  June (2)
  • ►  2018 (1)
    • ►  October (1)
  • ►  2016 (2)
    • ►  August (1)
    • ►  July (1)
  • ▼  2015 (6)
    • ►  December (2)
    • ▼  October (2)
      • Nice article about partitioning
      • Physical Joins
    • ►  August (1)
    • ►  March (1)
  • ►  2014 (1)
    • ►  March (1)
  • ►  2013 (4)
    • ►  March (3)
    • ►  February (1)
  • ►  2012 (3)
    • ►  October (1)
    • ►  June (1)
    • ►  March (1)
  • ►  2011 (13)
    • ►  September (5)
    • ►  August (3)
    • ►  July (3)
    • ►  June (2)
  • ►  2010 (6)
    • ►  September (6)

Visitors
Picture Window theme. Powered by Blogger.