Comments Feed

Find a Minimum Missing Value Commented on: 15 weeks 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: 33 weeks ago (July 15, 2014)

Thank you Itzik for this excellent walk-through!

Identifying a Subsequence in a Sequence, Part 1 Commented on: 1 year 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: 1 year 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: 4 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
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries 1

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 16, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups 1

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....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) ×