Comments Feed

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

Thank you Itzik for this excellent walk-through!

Identifying a Subsequence in a Sequence, Part 1 Commented on: 27 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: 27 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: 2 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: 2 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-...

Clarifications Regarding TSQL Challenge: Packing Date and Time Intervals Commented on: 3 years ago (February 8, 2011) Wow! A 14 second solution.
Maybe it's time to reveal "Itzik 1"? :-)




Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Management Studip Options screenshot
Aug 5, 2014
blog

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....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) ×