Profile

Cover photo
Nathan Hart
401 followers|284,520 views
AboutPostsPhotosYouTubeReviews

Stream

Nathan Hart

Shared publicly  - 
 
Excellent...
It took me a few years to come around on Community, but after enjoying a five-day, five-season binge of the off-kilter sitcom a few months back, you can most assuredly list me among Greendale Community College’s biggest supporters.…
1
Add a comment...

Nathan Hart

commented on a video on YouTube.
Shared publicly  - 
 
A fourth episode? What is this wizardry?
1
Add a comment...
 
Final episode from our Denver trip. We drove in a snow storm...for 1200 miles. Yeah?
 
DriftwoodProse has to drive home from Estes Park but there's a
snowstorm in the way...the whole time. But we stop for a few more road side attractions, get delicious burgers in Des Moines, and make a pilgrimage for myself in high school.
View original post
1
Add a comment...
 
DriftwoodProse in Denver!: http://youtu.be/I_jdBbnRVGM

Video 2 from our trip!
3
Add a comment...

Nathan Hart

Shared publicly  - 
 
Cue the "it's happening gif". March 17 is the new October 19.
"Community" is back March 17, but why have us tell you? Better to hear it from the (remaining) cast themselves.
2
Add a comment...

Nathan Hart

Shared publicly  - 
 
 
PARIS—Following the fatal terrorist attack Wednesday at the offices of French newspaper Charlie Hebdo, sources confirmed this afternoon that it is sadly not yet clear whether this very article will ultimately put human lives at risk. 
20 comments on original post
1
Add a comment...
Have him in circles
401 people
Carol Gray's profile photo
Emil Oakley's profile photo
Solomon Seal's profile photo
kiara Mcneil's profile photo
Mokhled Alqahtani's profile photo
Jake Smith's profile photo
Mark Orr's profile photo
M. Robert Winkler's profile photo
Matt Boswell's profile photo
 
 
NASA Astronaut Mike Fincke and ESA (European Space Agency)​ Astronaut Luca Parmitano reflect on the inspiration that actor Leonard Nimoy’s character Mr. Spock in the television series Star Trek had on scientists, engineers, space explorers and fans around the globe.

Read more: http://www.nasa.gov/content/nasa-remembers-leonard-nimoy/index.html
23 comments on original post
2
Add a comment...
 
It was snowing, I ran anyway. I felt the need to talk about it.
 
It's snowing, but when has that ever stopped anyone? Today my training program to run 7 miles, so I did, despite another round of winter weather. Join me on my journey through all my favorite landmarks so I know how far I've run and let's talk a bit about how to help yourself on long runs.
View original post
2
Laura C Schuster's profile photoNathan Hart's profile photo
2 comments
 
I'm pretty sure it hasn't been two months yet, so you've got time.
Add a comment...

Nathan Hart
moderator

Pop  - 
 
It was the first mega-Tuesday of the year with new releases from the Decemberists, Belle & Sebastian, Sleater-Kinney, Fall Out Boy and more. But this is the video and perhaps songs I'll obsess over for a while.
 
Well this is undeniably fantastic. 
View original post
1
Add a comment...

Nathan Hart

Discussion  - 
 #BT
 
I'm looking for someone who may be able to help me understand why this works to improve performance.

I have a large table (10mil+ records), however I only need to pull out specific records for what I'm doing. In order to do this, I've setup a loop based a the clustered index, which is a artificial key. This subset is selected in a subquery with my other conditions. This all looks something like...

SELECT [Fields]
FROM (
    SELECT [fields]
    FROM [bigtable]
    WHERE rowid>@rowid AND rowid<=@rowid+@span
    ) BT
    INNER JOIN TableA A ON BT.[Fields]=A.[Fields w/ Clustered Index]
    CROSS APPLY FunctionB(BT.[Fields]) B
    INNER JOIN TableC C ON B.[Field]=C.[Field w/ Clustered]
        AND BT.[DateFields] BETWEEN C.[DateFields]

When this is run on it's own, it uses two hash matches (BT-A, then BT-B, or the table B uses). However, when I make a simple change to my subquery to SELECT TOP (@span), since the most results we'll ever get is equal to @span, it switches to using nested loops for the joins and performance improves at least 10x.

I just want to understand why the addition of the TOP (@span) has this impact.

Thank you!
1
Decks Imus's profile photoSaurabh Sinha's profile photoNathan Hart's profile photo
4 comments
 
The big table has about 75 fields and the join logic changes for each measure, so we'd either need 40 indexes on roughly 5 columns each, or one all encompassing on about 30 fields. The PK is never used in filtering. I use the subquery because it forces a clustered index scan instead of a full table scan. You are correct on the function, it contains business logic and can't be removed. Not using BETWEEN because of the way I set up the @rowid and @span logic, because BETWEEN is inclusive, it would check @rowid twice - the previous loop and the current loop. This could be fixed easily enough by iterating @rowid by @rowid+@span+ 1, but I don't see the difference. Is there any notable difference between using two compare operators and BETWEEN (which is effective the same thing)?
Add a comment...

Nathan Hart

Shared publicly  - 
 
Part 1 of our trip!
1
Add a comment...

Nathan Hart

Shared publicly  - 
 
Cartoonists from all over the world mourn in the wake of a Paris shooting that killed as many as 12 people, many of whom are members of Charlie Hebdo.
2
Add a comment...
People
Have him in circles
401 people
Carol Gray's profile photo
Emil Oakley's profile photo
Solomon Seal's profile photo
kiara Mcneil's profile photo
Mokhled Alqahtani's profile photo
Jake Smith's profile photo
Mark Orr's profile photo
M. Robert Winkler's profile photo
Matt Boswell's profile photo
Basic Information
Gender
Male
Looking for
Networking
Birthday
September 25
Story
Tagline
Hey - it's that guy.
Introduction
SSRS Report Specialist by day, ridiculous multitasker (or, uncontrollable ADD) by night.  Let's talk - music, football, roller coasters?  Let's program!  Or, if you really want to get my excited, let's build a database.
Links
Contributor to
Amazing Mexican food, nothing short of amazing. Everything.
Public - 2 months ago
reviewed 2 months ago
Everything about the decor says "we're historic, so we don't have to update". The waitstaff wear full suits but the menus are single pages in a plastic sheet. They fall somewhere between stuck in the past and family friendly attraction and nothing about that works. We were in a small room and as it filled up with other families, it became very loud. Knowing the history, that the restaurant bought surrounding buildings as they expanded, it's very clear they've never done any remodeling to maximize their dining space. Some may call it character, but we were fairly put off by it. However, from the shrimp cocktail (a must!!!) through our delicious steaks, the food was some of the best we've had anywhere, so overall it still comes out on top.
• • •
Public - a year ago
reviewed a year ago
Had El Burrito Loco last night and it was as good as ever, they are a very consistent Mexican restaurant in the area. The Chile Relleno is an excellent side dish, the rice is never dried out. Personally, I'm a big fan of Armando's Quesadilla, but they have a great variety so everyone can get what they want. Enjoy!
Food: ExcellentDecor: ExcellentService: Good
Public - 2 years ago
reviewed 2 years ago
5 reviews
Map
Map
Map
Awesome. Online ordering is quick, simple and they're always at our door within ten minutes. Great sandwiches, quick service. Win.
Food: ExcellentDecor: ExcellentService: Excellent
Public - 2 years ago
reviewed 2 years ago
Good pizza, online ordering and delivery (the only Jet's in the area to do that, to my knowledge). List Dr. Pepper on the site, but it's Mr. Pibb.
Food: Very GoodDecor: Very GoodService: Good
Public - 2 years ago
reviewed 2 years ago