More in T-SQL

  • Nov 17, 2011

    What's a good use for a UNIQUE filtered index? 3

    Learn more about SQL Server UNIQUE filtered indexes and a minor limitation you'll need to know about....More
  • Oct 2, 2011

    SQL Server 2012 T-SQL at a Glance: New and Enhanced Functions

    Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
  • Sep 25, 2011

    Semicolon 3

    Not terminating T-SQL statements with a semicolon is on a deprecation path....More
  • Microsoft SQL Server Database Properties Auto Close screenshot
    Sep 8, 2011

    Worst Practice: Allowing AutoClose on SQL Server Databases 1

    Simply stated, allowing or enabling AutoClose on production SQL Server databases is a worst practice. What is AutoClose and why is it bad? AutoClose is a database option or setting—set on a database by database basis (meaning that it can’t be controlled at the server level)....More
  • Aug 31, 2011

    Improved Support for Window Functions in SQL Server 2012 CTP3

    Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3....More
  • Aug 9, 2011

    Book Review: Microsoft SQL Server 2008 R2 Administration Cookbook

    I read lots of books on SQL Server. In fact, I’m probably the Imelda Marcos of SQL Server books in some ways – as I’m constantly collecting and reading them....More
  • Aug 3, 2011

    Solution to TSQL Table Truncation Challenge

    Itzik provides the solution to last week’s table truncation challenge....More
  • Jul 29, 2011

    TSQL Challenge - Table Truncation - 29 Jul 2011 5

    Itzik provides a challenge to perform fast clearing of the data from a table that has an indexed view defined on it....More
  • Jul 7, 2011

    Solutions to TSQL Challenge – Reoccurring Visits 22

    Itzik covers solutions to last week’s puzzle – Reoccurring Visits....More
  • Jun 29, 2011

    TSQL Challenge – Reoccurring Visits 8

    Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More
  • Jun 22, 2011

    Forcing Collation in the WHERE Clause - 22 Jun 2011

    The ability to granularly define collation settings can be a huge win when it comes to the need to localize data—because it allows you localize at the lowest level possible and avoid some of the ugliness that can come from working with more ‘advanced’ collations at a higher level....More
  • Jun 2, 2011

    Free e-book on DQ and MDM by Sarka and Mauri

    Download your free copy of a new e-book about Data Quality and Master Data Management for Microsoft SQL Server 2008 R2 by Dejan Sarka and Davide Mauri....More
  • May 31, 2011

    Bug or Feature: REPLACE Puzzle 5

    Itzik discusses certain behavior of the REPLACE function that might seem like a bug to some....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
business people around a table and laptop
Oct 9, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
Oct 2, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×