THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 53 (528 total posts) < 1 second(s)
  • re: The SSIS tuning tip that everyone misses

    36M rows is quite a bit, but 18 batches isn't many. Hopefully there aren't too many things like Sorts in there. I would suggest you explore general tuning, as the difference between performance for pulling 2M compared to 36M probably isn't going to produce a very different plan.
    Posted to Rob Farley (Weblog) by Rob Farley on July 22, 2016
  • Finally, SSMS will talk to Azure SQL DW

    Dont get me started on how I keep seeing people jump into Azure SQL DW without thinking about the parallel paradigm. SQL DW is to PDW, the way that Azure SQL DB is to SQL Server. If you were happy using SQL Server for your data warehouse, then SQL DB may be just fine. Certainly you should get your head around the MPP (Massively Parallel ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 12, 2016
  • re: Why isn’t my filtered index being used?

    Oh Matt - I'm totally in favour of using views to help developers make good decisions about predicates they should use. :)
    Posted to Rob Farley (Weblog) by Rob Farley on June 21, 2016
  • Some recent posts

    Its T-SQL Tuesday, but this isnt actually my post! Regular readers might remember that I posted about Number of Rows Read a while back, and in that post, I mentioned that SQL Sentry should consider having a warning in Plan Explorer. Well, they put that feature in, and asked me if I could write about it. So I did. But this wasnt a standard ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 13, 2016
  • Exploring custom visuals in Power BI

    One of my favourite things about Power BI is its extensibility. For ages I would hear about how good some other self-service reporting platforms were, and how things in the Microsoft space were lacking. Power View, in particular, was frustratingly limited in what you could do with it, and I felt somewhat disappointed. It was good as a data ...
    Posted to Rob Farley (Weblog) by Rob Farley on May 10, 2016
  • re: PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition

    Yes, Eric. If you make a Unicode file, it won't work. It must be ASCII / UTF8.
    Posted to Rob Farley (Weblog) by Rob Farley on April 12, 2016
  • re: Reasons to upgrade SQL Server

    Hi Tony, This is a temporary thing only, I understand. Email me at rob at if you are affected by it and I can help. Rob
    Posted to Rob Farley (Weblog) by Rob Farley on April 12, 2016
  • Reasons to upgrade SQL Server

    With SQL Server 2005s extended support ending today, it seems appropriate to write a post about My Favourite SQL Server Feature for T-SQL Tuesday this month, hosted by Jens Vestergaard (@vestergaardj). The thing is that when I consider reasons to upgrade from SQL Server 2005, I see a ton of features that could be leveraged in later versions. ...
    Posted to Rob Farley (Weblog) by Rob Farley on April 11, 2016
  • re: How to make text searching go faster

    No worries, and thanks for supporting it.
    Posted to Rob Farley (Weblog) by Rob Farley on March 25, 2016
  • re: How to make text searching go faster

    Yes, Saeid. Lots of situations. Nice article - I wasn't aware of it. I presented this as one of my T-SQL Tips at TechEd AU back in 2008, but it wasn't new then either. Interesting that you refer to Brent's article on Sargability - he refers to one of mine in his, and was in the audience for my SQLBits session on it in 2010, which you can see at ...
    Posted to Rob Farley (Weblog) by Rob Farley on March 25, 2016
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement