THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » performance » T-SQL Tuesday   (RSS)
Showing page 1 of 2 (11 total posts)
  • Looking back, or looking forward?

    Sometimes I only blog for T-SQL Tuesday. I don’t want to break my run of blogging for each one just yet, but I do wonder sometimes. The reason I’m reflecting is that what we’ve done in the past will so often affect what we do in the future. The musician Sting tells us that “History will teach nothing”, but he’s trying to address the idea of being ...
    Posted to Rob Farley (Weblog) by rob_farley on August 12, 2013
  • When is a SQL function not a function?

    Should SQL Server even have functions? (Oh yeah – this is a T-SQL Tuesday post, hosted this month by Brad Schulz) Functions serve an important part of programming, in almost any language. A function is a piece of code that is designed to return something, as opposed to a piece of code which isn’t designed to return anything (which is known as a ...
    Posted to Rob Farley (Weblog) by rob_farley on November 7, 2011
  • Joins without JOIN

    I’m now doing two sessions at the SQL Saturday event in Portland. I had been scheduled to do a single session (on indexes), but got an email yesterday asking if I could do another one as well. So now I’m going to do a session earlier in the day about Joins. Yes, JOINs. Nice co-incidence to find that this month’s T-SQL Tuesday, hosted by Stuart ...
    Posted to Rob Farley (Weblog) by rob_farley on October 3, 2011
  • T-SQL Tuesday #20 : T-SQL Best Practices

    T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and then after all the submissions are in, writes a summary of all of the entries. This encourages people to participate in the community more ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 12, 2011
  • My biggest recommendation for people learning T-SQL

    It’s not quite a Best Practice, but it’s something that I see as very important. It makes the difference between someone who might be quite good at T-SQL, and someone who can go past the rest and become one of those people who get asked to solve other people’s T-SQL problems. It’s easy – you read the plans. You see, the plans explain to you ...
    Posted to Rob Farley (Weblog) by rob_farley on July 11, 2011
  • The blocking nature of aggregates

    I wrote a post recently about how query tuning isn’t just about how quickly the query runs – that if you have something (such as SSIS) that is consuming your data (and probably introducing a bottleneck), then it might be more important to have a query which focuses on getting the first bit of data out. You can read that post here.  In ...
    Posted to Rob Farley (Weblog) by rob_farley on March 7, 2011
  • Table? No such thing…

    No really – hear me out. Of course you create tables, and you query tables, and we say that data is stored in tables. The table is (rightly) a fundamental part of relational theory. But I find that when I think about queries and how they run, I need to approach the system thinking about the indexes that I’m querying, not the tables. When you ...
    Posted to Rob Farley (Weblog) by rob_farley on September 13, 2010
  • Spatial data from shapefiles (for T-SQL Tuesday #006)

    I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of said data. Given that it’s about one the larger types, this post should also count towards Michael Coles’ T-SQL Tuesday on BLOB data. I wrote recently about my experience with exploded data, but what I ...
    Posted to Rob Farley (Weblog) by rob_farley on May 10, 2010
  • T-SQL Tuesday #4: I/O, You Know

    It's time for the fourth T-SQL Tuesday, managed this time by Mike Walsh. I almost missed this deadline completely, since I didn't see the announcement at all. I wrote to Adam to ask if there even was an event this month, since I wasn't able to get into my own blog site (www.SQLBlog.com) for a week, and he pointed me to Mike's site. I'm wondering ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 9, 2010
  • T-SQL Tuesday - Query Cost

    In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday, hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally In and Out of disk and memory – my thoughts come very much to query cost. If I run set ...
    Posted to Rob Farley (Weblog) by rob_farley on March 8, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement