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 » T-SQL Tuesday » sql   (RSS)
Showing page 1 of 4 (34 total posts)
  • Tricks in T-SQL and SSAS

    This past weekend saw the first SQL Saturday in Melbourne. Numbers were good – there were about 300 people registered, and the attendance rate seemed high (though I didn’t find out the actual numbers). Looking around during the keynote, I didn’t see many empty seats in the room, and I knew there were 300 seats, plus people continued to arrive as ...
    Posted to Rob Farley (Weblog) by rob_farley on April 7, 2014
  • Scans are better than Seeks. Really.

    There are quite a few reasons why an Index Scan is better than an Index Seek in the world of SQL Server. And yet we see lots of advice saying that Scans are bad and Seeks are good. Let’s explore why. Michael Swart (@MJSwart) is hosting T-SQL Tuesday this month, and wants people to argue against a popular opinion. Those who know me and have heard ...
    Posted to Rob Farley (Weblog) by rob_farley on March 11, 2014
  • Victims of success

    I feel like every database project has major decisions now, which are remarkably fundamental to the direction that’s going to be taken. And it’s almost as if new options appear with ever-increasing frequently. Consider a typical database project, involving a transactional system to support an application, with extracts into a data warehouse ...
    Posted to Rob Farley (Weblog) by rob_farley on February 10, 2014
  • Waiting, waiting…

    “It just runs slow these days” I’m sure you’ve heard this, or even said it, about a computer that’s a few years old. We remember the days when the computer was new, and it seemed to just fly – but that was then, and this is now. Change happens, things erode, and become slower. Cars, people, computers. I can accept that cars get slower. They lose ...
    Posted to Rob Farley (Weblog) by rob_farley on December 9, 2013
  • Cloud – the forecast is improving

    There is a lot of discussion about “the cloud”, and how that affects people’s data stories. Today the discussion enters the realm of T-SQL Tuesday, hosted this month by Jorge Segarra. Over the years, companies have invested a lot in making sure that their data is good, and I mean every aspect of it – the quality of it, the security of it, the ...
    Posted to Rob Farley (Weblog) by rob_farley on November 11, 2013
  • Not-so-dirty SQL hacks

    Using a hammer to push in a screw isn’t a good idea, no matter how good the hammer is. We all know that. and yet there are times when we get frustrated at the ‘right tool’ and opt for the one that will work. Unfortunately, there are plenty of examples in the IT space – the topic of which is this month’s T-SQL Tuesday, hosted by Rick Krueger ...
    Posted to Rob Farley (Weblog) by rob_farley on September 9, 2013
  • 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
1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement