http://www.windowsitpro.com/authors/author/author/5779340/rss/5779340en-USSun, 27 May 2012 07:51:53 GMTSun, 27 May 2012 07:51:53 GMThttp://www.windowsitpro.com/article/tsql/tsql-best-practices-141537
By Itzik Ben-Gan
Itzik continues his discussion of T-SQL best practices; he discusses cloud compatibility, date and time best practices, the importance of writing in a standard way, and performance-related best practices.]]>Itzik Ben-GanTue, 22 May 2012 10:07:00 GMThttp://www.windowsitpro.com/article/tsql/tsql-best-practices-141537http://www.windowsitpro.com/article/tsql/tsql-best-practices-141536
By Itzik Ben-Gan
Some T-SQL best practices include thinking in a relational way, always remembering NULLs and the three-valued-logic, realizing the full implications of using the NOLOCK hint and therefore avoiding it, and adopting good coding practices.]]>Itzik Ben-GanFri, 20 Apr 2012 10:05:00 GMThttp://www.windowsitpro.com/article/tsql/tsql-best-practices-141536http://www.windowsitpro.com/article/tsql/understanding-query-plans-141850
By Itzik Ben-Gan
A key element in query tuning is using the execution plan to determine the reasons for poor query performance. SQL Server provides rich information about query plans in the graphical as well as XML forms of plans.]]>Itzik Ben-GanMon, 19 Mar 2012 05:00:00 GMThttp://www.windowsitpro.com/article/tsql/understanding-query-plans-141850http://www.windowsitpro.com/article/tsql/tsql-windows-functions-part-3-141036
By Itzik Ben-Gan
Itzik wraps up his discussion of SQL Server 2012’s window functions by focusing on optimization. He provides indexing guidelines for optimal performance, and he describes cases with especially optimal treatment, cases that compute the difference between two cumulative values, cases that expand all frame rows, and cases in which the optimizer can use an in-memory spool versus an on-disk spool.]]>Itzik Ben-GanThu, 26 Jan 2012 11:18:00 GMThttp://www.windowsitpro.com/article/tsql/tsql-windows-functions-part-3-141036http://www.windowsitpro.com/article/tsql/sql-server-2012-window-functions-141022
By Itzik Ben-Gan
SQL Server 2012 enhances support for window aggregate functions. In part 2 of this series, Itzik discusses window offset functions and window distribution functions.]]>Itzik Ben-GanTue, 13 Dec 2011 09:54:00 GMThttp://www.windowsitpro.com/article/tsql/sql-server-2012-window-functions-141022http://www.windowsitpro.com/article/tsql/sql-server-2012-window-functions-140228
By Itzik Ben-Gan
SQL Server 2012 enhances support for window aggregate functions by introducing window order and frame clauses, support for offset functions, and support for window distribution functions. In this article, Itzik introduces the concept of windowing; he describes the elements involved in window specifications, and he covers window aggregate functions.]]>Itzik Ben-GanMon, 21 Nov 2011 15:32:00 GMThttp://www.windowsitpro.com/article/tsql/sql-server-2012-window-functions-140228http://www.windowsitpro.com/article/tsql/string-manipulation-tips-techniques-part-2-139782
By Itzik Ben-Gan
Itzik explains how to handle type conversions when you need to convert a character string value to another type, in both SQL Server 2008 and SQL Server Denali.]]>Itzik Ben-GanWed, 26 Oct 2011 12:00:00 GMThttp://www.windowsitpro.com/article/tsql/string-manipulation-tips-techniques-part-2-139782http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/denali-tsql-glance-enhanced-functions-140785
By Itzik Ben-Gan
Itzik describes new T-SQL scalar functions in SQL Server Denali CTP 3.]]>Itzik Ben-GanSun, 02 Oct 2011 05:03:04 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/denali-tsql-glance-enhanced-functions-140785http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/semicolon-140706
By Itzik Ben-Gan
Not terminating T-SQL statements with a semicolon is on a deprecation path.]]>Itzik Ben-GanMon, 26 Sep 2011 00:48:54 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/semicolon-140706http://www.windowsitpro.com/article/tsql/string-manipulation-tips-techniques-part-1-136427
By Itzik Ben-Gan
Learn about some common string manipulation tasks, such as counting occurrences of a substring within a string, verifying an exact number of occurrences of a substring within a string, and replacing multiple contiguous spaces with a single space.]]>Itzik Ben-GanWed, 14 Sep 2011 10:35:00 GMThttp://www.windowsitpro.com/article/tsql/string-manipulation-tips-techniques-part-1-136427http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/improved-support-window-functions-sql-server-denali-ctp3-140423
By Itzik Ben-Gan
Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3.]]>Itzik Ben-GanWed, 31 Aug 2011 17:42:23 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/improved-support-window-functions-sql-server-denali-ctp3-140423http://www.windowsitpro.com/article/sql-server/license-plates-challenge-136376
By Itzik Ben-Gan
Itzik presents a real-world T-SQL challenge that involves generating a sequence of license plates.]]>Itzik Ben-GanTue, 16 Aug 2011 11:16:00 GMThttp://www.windowsitpro.com/article/sql-server/license-plates-challenge-136376http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/solution-tsql-table-truncation-challenge-140061
By Ben-Gan, Itzik
Itzik provides the solution to last week’s table truncation challenge.]]>Ben-Gan, ItzikWed, 03 Aug 2011 12:47:40 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/solution-tsql-table-truncation-challenge-140061http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/tsql-challenge-table-truncation-140026Fri, 29 Jul 2011 15:40:20 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/tsql-challenge-table-truncation-140026http://www.windowsitpro.com/article/sql-server/SQL Server 2005 Apply -136248
By Itzik Ben-Gan
More advanced uses of the APPLY table operator include efficient parallelism of queries, reuse of column aliases, aggregate over columns, unpivoting, and inlining scalar functions.]]>Itzik Ben-GanMon, 25 Jul 2011 14:00:00 GMThttp://www.windowsitpro.com/article/sql-server/SQL Server 2005 Apply -136248http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/solutions-tsql-challenge-reoccurring-visits-139751
By Itzik Ben-Gan
Itzik covers solutions to last week’s puzzle – Reoccurring Visits.]]>Itzik Ben-GanThu, 07 Jul 2011 14:00:00 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/solutions-tsql-challenge-reoccurring-visits-139751http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/tsql-challenge-reoccurring-visits-139666
By Itzik Ben-Gan
Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website.]]>Itzik Ben-GanWed, 29 Jun 2011 09:44:57 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/tsql-challenge-reoccurring-visits-139666http://www.windowsitpro.com/article/tsql/SQL-Server-2005-Apply-129874
By Itzik Ben-Gan
The APPLY table operator accepts two table expressions as input and applies the right table expression to each row from the left, allowing correlations from the right table expression to refer to attributes from the left side. Itzik describes three forms of APPLY: CROSS APPLY, OUTER APPLY, and implicit APPLY.]]>Itzik Ben-GanMon, 20 Jun 2011 15:07:00 GMThttp://www.windowsitpro.com/article/tsql/SQL-Server-2005-Apply-129874http://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/free-e-book-on-dq-and-mdm-by-sarka-and-mauri-136857
By Itzik Ben-Gan
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.]]>Itzik Ben-GanThu, 02 Jun 2011 10:29:00 GMThttp://www.windowsitpro.com/blog/puzzled-by-t-sql-blog-15/tsql/free-e-book-on-dq-and-mdm-by-sarka-and-mauri-136857http://www.windowsitpro.com/article/sql-server/Sidebar-How-to-Tell-What-the-Default-Cache-Value-is--129206
By Itzik Ben-Gan
SIDEBAR: How to Determine the Default Cache Value in SQL Server Denali]]>Itzik Ben-GanTue, 24 May 2011 16:04:00 GMThttp://www.windowsitpro.com/article/sql-server/Sidebar-How-to-Tell-What-the-Default-Cache-Value-is--129206