THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL » t-sql tuesday   (RSS)
Showing page 2 of 4 (38 total posts)
  • Filegroups and Non-Clustered Indexes

    Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday, hosted this month by Jen McCown. SQL Server holds data, and that data is stored physically in files. Of course, in the database world we think of the data as living in tables*, so naturally there must be some sort of mapping between the ...
    Posted to Rob Farley (Weblog) by rob_farley on March 11, 2013
  • Behind the scenes of PowerShell and SQL

    Every year, PowerShell increases its stranglehold on the Windows Server system and the applications that run upon it – with good reason too. Its consistent mechanisms for interaction between its scripting interface and the underlying systems make it easy for people to feel comfortable, and there is a discoverability that has been lacking in many ...
    Posted to Rob Farley (Weblog) by rob_farley on February 11, 2013
  • Joins in single-table queries

    Tables are only metadata. They don’t store data. I’ve written something about this before, but I want to take a viewpoint of this idea around the topic of joins, especially since it’s the topic for T-SQL Tuesday this month. Hosted this time by Sebastian Meine (@sqlity), who has a whole series on joins this month. Good for him – it’s a great ...
    Posted to Rob Farley (Weblog) by rob_farley on December 10, 2012
  • When someone deletes a shared data source in SSRS

    SQL Server Reporting Services plays nicely. You can have things in the catalogue that get shared. You can have Reports that have Links, Datasets that can be used across different reports, and Data Sources that can be used in a variety of ways too. So if you find that someone has deleted a shared data source, you potentially have a bit of a horror ...
    Posted to Rob Farley (Weblog) by rob_farley on October 8, 2012
  • Tricks? In T-SQL?

    Four years ago, I was preparing to speak at TechEd Australia. I’d been asked to give a session on “T-SQL Tips and Tricks”, but I’d pushed back and we’d gone with “T-SQL Tips and Techniques” instead. I hadn’t wanted to show Tricks, because despite being a fan of ‘magicians’ (like Tommy Cooper) I feel like the trickery should disappear with the ...
    Posted to Rob Farley (Weblog) by rob_farley on August 13, 2012
  • MERGE gives better OUTPUT options

    MERGE is very cool. There are a ton of useful things about it – mostly around the fact that you can implement a ton of change against a table all at once. This is great for data warehousing, handling changes made to relational databases by applications, all kinds of things. One of the more subtle things about MERGE is the power of the OUTPUT ...
    Posted to Rob Farley (Weblog) by rob_farley on June 11, 2012
  • Analytic functions – they’re not aggregates

    SQL 2012 brings us a bunch of new analytic functions, together with enhancements to the OVER clause. People who have known me over the years will remember that I’m a big fan of the OVER clause and the types of things that it brings us when applied to aggregate functions, as well as the ranking functions that it enables. The OVER clause was ...
    Posted to Rob Farley (Weblog) by rob_farley on April 9, 2012
  • Be the surgeon

    It’s a phrase I use often, especially when teaching, and I wish I had realised the concept years earlier. (And of course, fits with this month’s T-SQL Tuesday topic, hosted by Argenis Fernandez) When I’m sick enough to go to the doctor, I see a GP. I used to typically see the same guy, but he’s moved on now. However, when he has been able to ...
    Posted to Rob Farley (Weblog) by rob_farley on March 12, 2012
  • APPLY – not exactly set-based

    In my last post, I showed a technique for dealing with working columns when writing T-SQL. The idea was around using APPLY to be able to push values from the existing set through calculations (but preferably not scalar functions, of course), producing new columns which can be used further down the query, even in the WHERE and GROUP BY clauses. ...
    Posted to Rob Farley (Weblog) by rob_farley on January 9, 2012
  • A T-SQL Tip: Working calculations

    T-SQL Tuesday again and this month is on T-SQL Tips (thanks Allen!). In some ways it’s a tough topic, because there are things I don’t really consider tips that other people do, and vice-versa. This one’s legitimate though: Using CROSS APPLY for working columns in calculations. Let me give you an example. Back in 2009, I wrote a blog post on ...
    Posted to Rob Farley (Weblog) by rob_farley on December 12, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement