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   (RSS)
Showing page 1 of 45 (449 total posts)
  • SQL Server Hardware

    From Red-Gate website you can download (for free) the ebook SQL Server Hardware written by Glenn Berry (@GlennAlanBerry). This ebook will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on October 29, 2014
  • Execution plans, laundry, and a giveaway

    In just a week from now, SQL Saturday #337 will kick off in Portland, Oregon. And I will be there – the third time already for me to be speaking in Portland. For a European, Portland is not the most logical location. But the organization over there is a pretty smart bunch of people. They figure that being close to Seattle gives them a great ...
  • SQL Spatial: Getting “nearest” calculations working properly

    If you’ve ever done spatial work with SQL Server, I hope you’ve come across the ‘nearest’ problem. You have five thousand stores around the world, and you want to identify the one that’s closest to a particular place. Maybe you want the store closest to the LobsterPot office in Adelaide, at -34.925806, 138.605073. Or our new US office, at ...
    Posted to Rob Farley (Weblog) by rob_farley on August 14, 2014
  • SSIS Lookup transformation in T-SQL

    There is no equivalent to the SSIS Lookup transformation in T-SQL – but there is a workaround if you’re careful. The big issue that you face is about the number of rows that you connect to in the Lookup. SQL Books Online (BOL) says: If there is no matching entry in the reference dataset, no join occurs. By default, the Lookup transformation ...
    Posted to Rob Farley (Weblog) by rob_farley on July 8, 2014
  • SQL 2014 does data the way developers want

    A post I’ve been meaning to write for a while, good that it fits with this month’s T-SQL Tuesday, hosted by Joey D’Antoni (@jdanton) Ever since I got into databases, I’ve been a fan. I studied Pure Maths at university (as well as Computer Science), and am very comfortable with Set Theory, which undergirds relational database concepts. But I’ve ...
    Posted to Rob Farley (Weblog) by rob_farley on June 9, 2014
  • SQL TuneIn Zagreb 2014 – Session material

    I spent the last few days in Zagreb, Croatie, at the third edition of the SQL TuneIn conference, and I had a very good time here. Nice company, good sessions, and awesome audiences. I presented my “Understanding Execution Plans” precon to a small but interested audience on Monday. Participants have received a download link for the slide deck. On ...
  • Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

    Preamble This is the second in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in my big deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 26, 2014
  • Updated sp_indexinfo

    It was time to give sp_indexinfo some love. The procedure is meant to be the ''ultimate'' index information procedure, providing lots of information about all indexes in a database or all indexes for a certain table. Here is what I did in this update:Changed the second query that retrieves missing index information so it generates the index name ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 22, 2014
  • Columnstore Case Study #1: MSIT SONAR Aggregations

    Preamble This is the first in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in this deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an easy-to-consume ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 19, 2014
  • SQL Saturday Chicago (#291) - Clash of the Row Goals - Demos

    Thank you to everyone who joined me today at SQL Saturday Chicago for my ''Clash of the Row Goals'' session. I'm honored that so many people would attend a talk with such an incredibly arcane title -- and always glad to find a curious, interested, and intelligent audience. The demos I showed during the session are attached to this post. If you ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 26, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement