SQL in the Wild

A discussion on SQL Server


Archive for the 'Syndication' Category

Full backups, the log chain and the COPY_ONLY option.

• Tuesday, March 8th, 2011

Posted in Admin, SQL Server, Syndication | 12 Comments »


And now for a completely inappropriate use of SQL Server

• Tuesday, February 22nd, 2011

Posted in Artificial Intelligence, SQL Server, Syndication | 4 Comments »


Are int joins faster than string joins?

• Tuesday, February 15th, 2011

Posted in Performance, SQL Server, Syndication | 20 Comments »


Quest Webcast: Dos and Don’ts of Database corruption

• Monday, February 14th, 2011

Posted in Corruption, SQL Server, Syndication | No Comments »


Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »


Upcoming presentations

• Friday, January 28th, 2011

Posted in Community, Syndication | No Comments »


Distincting an IN subquery

• Tuesday, January 18th, 2011

Posted in Performance, SQL Server, Syndication | 7 Comments »


Capturing the Execution Plan

• Tuesday, January 4th, 2011

Posted in Execution Plans, SQL Server, Syndication | 9 Comments »


Do IF statements cause recompiles?

• Tuesday, December 14th, 2010

Posted in Execution Plans, SQL Server, Syndication | 2 Comments »


Recompiles

• Thursday, November 18th, 2010

Posted in Execution Plans, SQL Server, Syndication | 2 Comments »


« Previous Entries
Next Entries »
  •  Subscribe in a reader

    Copyright policy
  • Popular Posts
    • Catch-all queries
    • Deleting the transaction log
    • Execution plan operations - joins
    • On Counts
    • Exists vs IN
    • Index columns, selectivity and equality predicates
  • Categories
    • SQL Server
      • Admin
      • Corruption
      • Indexes
      • Internals
      • Execution Plans
      • Performance
      • T-SQL
    • Personal
      • Artificial Intelligence
      • Career
      • Roleplaying
    • Conferences
    • Community
    • General
    • Misc
    • Rants


  • Microsoft MVP

    SQLServerPedia award

    SQLServerPedia award


  • Now Reading

    View Full Library

    Reading (4)

    • Sailing to Sarantium: Book One of the Sarantine Mosaic
      Sailing to Sarantium: Book One of the Sarantine Mosaic by Guy Gavriel Kay
    • Masters of Fantasy
      Masters of Fantasy by Unknown
    • Artificial Intelligence for Games, Second Edition
      Artificial Intelligence for Games, Second Edition by Ian Millington, John Funge
    • EXPOSE 6: The Finest Digital Art in the Known Universe
      EXPOSE 6: The Finest Digital Art in the Known Universe by Unknown

    Planned (16)


    • A Song for Arbonne by Guy Gavriel Kay

    • The Last Light of the Sun by Guy Gavriel Kay

    • The Heart of Valor: A Confederation Novel (Valor Novel) by Tanya Huff

    • The Judging Eye (The Aspect-Emperor) by R. Scott Bakker

    • Mary Stewart’s Merlin Trilogy by Mary Stewart

    Finished (146)


    • The Stars, Like Dust by Isaac Asimov

    • Airframe: A Novel by Michael Crichton

    • The Night Watch (Watch, Book 1) by Sergei Lukyanenko

    • Star Rigger’s Way by Jeffrey A. Carver

    • Hex and the City (Nightside, Book 4) by Simon R. Green

    • Synthesis (Star Trek: Titan #6) by James Swallow
    Now Reading
    Redux

  • SQL in the Wild is proudly powered by WordPress and ChaoticSoul (by Bryan Veloso)