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 » sql   (RSS)
Showing page 2 of 16 (152 total posts)
  • 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
  • Converting Points to a Path

    Suppose your SQL table has a bunch of spatial points (geographies if you like) with an order in which they need to appear (such as time) and you want to convert them into a LineString, or path. One option is to convert the points into text, and do a bunch of string manipulation. I’m not so keen on that, even though it’s relatively ...
    Posted to Rob Farley (Weblog) by rob_farley on January 22, 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
  • String length and SARGability

    CONVERT_IMPLICIT isn’t the only problem with getting data types wrong. You might have the right type, but what if the length is wrong? This post will look at both getting the type wrong and getting the length wrong too. Let’s do some testing. We’ll need a table with indexes. I’d normally use one of the AdventureWorks versions for this, but as ...
    Posted to Rob Farley (Weblog) by rob_farley on September 22, 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
  • TVPs in SSIS

    Almost two years ago, I wrote about a method to use Table-Valued Parameters in SQL 2005 – or basically any environment that doesn’t support them natively. The idea was to use a View with an ‘instead of’ trigger. Essentially, the trigger acts as a stored procedure, which is then used to be able to handle all the rows however you want. That could ...
    Posted to Rob Farley (Weblog) by rob_farley on August 28, 2013
  • Ultimate query tuning

    Infinitely better. 100% of the reads removed. Roughly 4000 (okay, 3890), down to zero. None. Let me explain... Obviously if there’s data being returned, there are reads needed. And obviously there is some CPU needed for SQL to be given a query and do anything at all. Luckily for me, performance of a query is typically evaluated using the ...
    Posted to Rob Farley (Weblog) by rob_farley on August 19, 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
  • A TOP Query

    For the blog post that I’ll publish tomorrow, I wrote a query that I thought needed a blog post all of its own. This is that post. The query was this one. Its results aren’t that interesting, it’s just a list of dates with a random number between 0 and 99. Just some sample data that I thought I’d use. SELECT TOP ...
    Posted to Rob Farley (Weblog) by rob_farley on March 11, 2013
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement