Comments Feed

Puzzle Me This: String Replacement Commented on: 43 weeks ago (April 10, 2015)

Here is my take at it.

DECLARE @Keyword NVARCHAR(1000) = N'wwAMxxAMyyAMzz',
@Source NVARCHAR(1000) = N'AM',
@Synonym NVARCHAR(1000) = N'AN';

DECLARE @Permutations INT...

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

Thank you Itzik for this excellent walk-through!

Identifying a Subsequence in a Sequence, Part 1 Commented on: 2 years 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: 2 years 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: 4 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: 4 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: 4 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: 4 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: 4 years ago (March 25, 2011) Where is my #3? ;-)

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 5, 2016
blog

The Solution to Large Quantities of Data

High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
SQL Server 2016 Reporting Services
Jan 25, 2016
Article

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....More
Microsoft Power BI
Dec 8, 2015
Article

It is Time to Migrate Power BI for Office 365 1

Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....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) ×