A puzzling situation (my T-SQL Tuesday entry). This entry is an actual puzzle. Here I’m asking you to do the impossible (or at least the computationally difficult). Solve for ???:
Good luck
Solution next week.
BTW, Don’t even try to attack this using a brute force approach. Even if you could test 1000 values a millisecond it would take like a whole decade to crack it.
Dumb pun. I’m at a conference at Seattle. These MVPs (minus Ricardo Manalban) are displaying the book they helped put together "SQL Server MVP Deep Dives" with profits going to the charity WarChild
An open letter to delinquent SQL bloggers.
I accept your apologies which you thoughtfully expressed in posts such as here, here, here, here, here and here. You expressed desires to make amends and reconcile with me and I truly hope you were sincere.
I know that mistakes were made and there are regrets on both sides. But I think pointing fingers would be counterproductive at this stage.
So today, on behalf of SQL Blog readers, I hereby accept your apologies and forgive you all.
Together I think we can get through this difficult time. I think it’s best now if we focus on the present. And I think with patience, time and more consistent blog posts, I will not only forgive, but forget.
Sincerely,
Michael J. Swart
Database Whisperer
All kidding aside. It’s no biggie. I really never miss the lack of posts from any particular author in my RSS feed aggregator. I just mark such apology-posts as read and get on with the day.
DECLARE @strings TABLE (id INT IDENTITY(1,1), val NVARCHAR(MAX)); INSERT @strings(val) VALUES ('When using a left outer join,'), ('you'), ('put the condition'), ('in the outer join clause and not'), ('in the where clause. In effect'), ('all rows are returned and no'), ('filtering out '), ('is done.'), ('You can see that all rows are '), ('returned, both primes and'), ('non-primes'); DECLARE @primes TABLE (id INT) INSERT @primes VALUES(2), (3), (5), (7), (11); -- a query with a proper left join SELECT p.id, s.val FROM @strings s LEFT OUTER JOIN @primes p ON s.id = p.id ORDER BY s.id; -- a query with the condition in the where clause SELECT p.id, s.val FROM @strings s LEFT OUTER JOIN @primes p ON 1 =1 WHERE s.id = p.id ORDER BY s.id; |
Kinda reminds me of those Mad Magazine fold-ins.
… in comic form!
http://www.sqlmag.com/Article/ArticleID/102089/102089.html
Jeff James, Editor-in-Chief at SQL Server Magazine, mentioned a particular guide in the “New Products” section of the May 2009 Issue.
Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you.
In this post, I mentioned some of the more interesting acronyms or abbreviations that I’ve come across like:
Here’s a few other interesting ones that I forgot to mention:
SQL Server has its own share of jargon. Some cool sounding words, some not so much.
Here are some words that you will never hear me pronounce:
Here are some words that I am always looking for excuses to pronounce.
I’m sure you can think of a few of your own. Email me or comment if you have pet words (or pet-peeve words).
A T-SQL script I came up with that displays the Mandelbrot set. (Tip: Hit Ctrl-T before executing)
SET NOCOUNT ON;
--populate
;WITH Numbers ([row]) AS
(
SELECT TOP 100 CAST(ROW_NUMBER() OVER (ORDER BY NEWID()) AS FLOAT) [row]
FROM sys.columns
)
SELECT A.row AS x,
B.row AS y,
0 AS iter,
A.row AS iterx,
B.row AS itery,
'.' AS symbol
INTO #GRID
FROM Numbers A, Numbers B
WHERE B.[row] <= 24
GO
-- scale
UPDATE #GRID
SET x = x * 3.0 / 100.0 - 2,
y = y * 2.0 / 24.0 - 1,
iterx = x * 3.0 / 100.0 - 2,
itery = y * 2.0 / 24.0 - 1
GO
--iterate
UPDATE #GRID
SET iterx = iterx*iterx - itery*itery + x,
itery = 2*iterx*itery + y,
iter = iter+1
WHERE iterx*iterx+itery*itery <= 2*2
GO 257
UPDATE #GRID SET symbol = CHAR(64+(iter%26)) WHERE NOT iter = 257
GO
--print
WITH concatenated (y, c) AS
(
SELECT G2.y,
(SELECT SUBSTRING(G.symbol, 1, 1) AS [data()] FROM #GRID G WHERE G.y = G2.y FOR XML PATH('')) c
FROM (SELECT DISTINCT y FROM #GRID) AS G2
)
SELECT REPLACE(c, ' ', '') FROM concatenated ORDER BY y
GO
DROP TABLE #GRID
Wikipedia’s entry on the Mandelbrot set.
Powered by WordPress
