Comments Feed

Find a Minimum Missing Value Commented on: 1 week ago (November 14, 2014)

Slightly less cost. Reduce the WHERE clause like this

WITH C AS
(
SELECT col1, LEAD(col1, 1, 0) OVER(ORDER BY col1) AS nxt
FROM dbo.T1
)
SELECT TOP (1)...

Identifying a Subsequence in a Sequence, Part 3 Commented on: 19 weeks ago (July 15, 2014)

Thank you Itzik for this excellent walk-through!

Identifying a Subsequence in a Sequence, Part 1 Commented on: 42 weeks ago (February 6, 2014)

See my set-based solution in second part of this article.
1.5 seconds and 14 000 reads.

Identifying a Subsequence in a Sequence, Part 2 Commented on: 42 weeks ago (February 6, 2014)

Hi Itzik.

The problem is just another Relational Division; Ordered Relational Division. My solution finishes in just 1.5 seconds and uses about 14000 reads.

DECLARE @Items INT = (...

What's a good use for a UNIQUE filtered index? Commented on: 3 years ago (November 21, 2011) I use it to enforce data integrity in our data warehouse. Currently there are two business systems feeding the DW with data, and some tables (like Orders.SalesDetail) containts data from both systems...
Use T-SQL to Generate a Sequence Commented on: 3 years ago (August 22, 2011) Itzik, let me know if you got my script by email. //Peter
Solutions to TSQL Challenge – Reoccurring Visits Commented on: 3 years ago (July 14, 2011) Not bad Mr Celko. Not bad at all. It's clever to build a "dual date" cte holding yesterday's and today's dates. Add "sum(today_flg) as NumVisits," to the final output...
TSQL Challenge – Reoccurring Visits Commented on: 3 years ago (July 6, 2011) Here is my stats with 100,000+ row sample data using same date interval as original (8 row(s) affected) Table 'Worktable'. Scan count 0, logical reads 0. Table 'DailyVisits'. Scan...
Solutions to Packing Date and Time Intervals Puzzle Commented on: 3 years ago (March 25, 2011) Where is my #3? ;-)

SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS Commented on: 3 years ago (March 1, 2011) It would be a really nice feature if this could be combined with this request

http://connect.microsoft.com/SQLServer/feedback/details/470881/allow-more-than-one-resultset-to-be-stored-with-...

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
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Availability Groups screenshot
Nov 11, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
Stretch SQL Server into Azure
Nov 5, 2014
blog

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....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) ×