April 20, 2012 at 1:26 pm
SQLRNNR (4/20/2012)
Lynn Pettis (4/20/2012)
Sean Lange (4/20/2012)
Lynn Pettis (4/20/2012)
SQLRNNR (4/20/2012)
The Dixie Flatline (4/20/2012)
I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a 12-step program for you guys.I am there with you.
Actually, I think I need to work on my Won't Power. You know, I won't answer any more of that individuals questions. Obviously I am very weak in this area at the moment.
In my best Obi-Wan voice...
You will no longer help this individual...
They do not need your help...
Walk away as they are fine on their own..
Hmmm, On the weak minded only do the Jedi mind tricks work.
You did say you were weak.:Whistling:
Weak on won't power, not weak minded. :w00t:
April 20, 2012 at 2:50 pm
Time for another meeting.
"Hi, Lynn"
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 20, 2012 at 3:31 pm
The Dixie Flatline (4/20/2012)
Time for another meeting."Hi, Lynn"
hi Lynn!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 20, 2012 at 3:31 pm
The Dixie Flatline (4/20/2012)
Time for another meeting."Hi, Lynn"
After my quick foray this morning before leaving for work, I am staying away. I may read, but I am not getting involved with "he who is clueless."
April 20, 2012 at 6:56 pm
David Burrows (4/20/2012)
Lynn Pettis (4/20/2012)
Because once in while you think you see a light starting to go on. But then it flickers out again just as fast.Or maybe it was too dim to start with 😀
No, that apparently applies to the OP, not to the light.
Tom
April 21, 2012 at 8:01 am
Brandie Tarvin (4/20/2012)
Unrelated question:Has anyone heard of a company called Kaseya? They apparently do IT software, user conferences, and webinars, but I can't find much more out about them - reviews, etc.- (unless my Googlefu just sucks today). They have some interesting webinars coming up that I'm tempted to take, but since I've never heard of them before today, I'm leary that this might just be another spam marketeer pimping their own products.
Have a supplier who uses them for remote desktop support (they install/support various applications). They seemed very happy with it. Due to policy, we don't allow them to use it with us, so can't tell you much about it, but I know they said it gave them instant access to hundreds of clients successfully.
Not much of a help but my only contact with them.
Bex
April 21, 2012 at 10:45 am
SQL Kiwi (4/19/2012)
SQLRNNR (4/19/2012)
Thanks for double checking my code. Too bad my results were wrong. There has got to be a way of doing this.I agree, but we might have to wait for any future work that might be done to optimize the (very common) case of LAG and LEAD for the immediately preceding or following row only. As it is, these functions are implemented quite generically as LAST_VALUE with a RANGE 1 PRECEDING clause (you can see this in the query plan if you look closely).
On a separate point, the Itzik and Jeff solutions are optimal when merge is used for the semi-join. If you test them again, add OPTION (MAXDOP 1, MERGE JOIN, LOOP JOIN) to avoid the hash (which spills to tempdb). Parallelism adds little value on the demo (and merge doesn't parallelize very well in general anyway). I tried the following (which produces the optimal plan for me without hints):
SELECT
S.GapStart,
E.GapEnd
FROM
(
SELECT GapStart = gt.N + 1 FROM dbo.GapTest AS gt
WHERE NOT EXISTS (SELECT 1 FROM dbo.GapTest AS gt2 WHERE gt2.N = gt.N + 1)
) AS S
CROSS APPLY
(
SELECT TOP (1)
GapEnd = gt3.N
FROM dbo.GapTest AS gt3
WHERE
gt3.N > S.GapStart
ORDER BY gt3.N
) AS E
ORDER BY
S.GapStart;
I know code on the thread is frowned on but I'm feeling rebellious today. I don't come across gap/islands problems enough to really spend time on this.
I know I've been a bit busy lately, but to find my blog post discussed on The Thread was a quite a thrill. Paul, I'm going to add this to the perf testing to see how it does, and I'll put an update up soon. (Wish you had posted it on the blog remarks.....)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 21, 2012 at 10:48 am
The Dixie Flatline (4/19/2012)
Okay, I will apologize for bringing this up in the Thread. But I'm getting tired of writing private messages.Yes, Gail, I was at the last Summit in Seattle and attended the presentation you and Grant gave on Monday. Tuesday night, I was at the reception/casino night, intending to see Jeff get his award. Before the ceremony got started, I had a pulmonary embolism. Don't bother looking it up. It means multiple blood clots in both lungs, and it feels like a heart attack. I was stupid and didn't ask for help getting up to the aid station, but I made it on my own and they got me to the emergency room at a nearby hospital within 20 minutes. Even the other guys from my company didn't know where I was until the hospital called them the next day. Obviously I missed the rest of the week, which I greatly regret.
Long story short, I survived and it's ancient history now.
You were at Grant's/Gail's precon, and at the Red-Gate party, and I missed you? Dang, missed opportunity there.
Glad things have improved to where it's ancient history.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 21, 2012 at 8:14 pm
WayneS (4/21/2012)
I know I've been a bit busy lately, but to find my blog post discussed on The Thread was a quite a thrill. Paul, I'm going to add this to the perf testing to see how it does, and I'll put an update up soon. (Wish you had posted it on the blog remarks.....)
Ah Jeff deserves the credit for bringing the discussion here, not me. I didn't post the remarks and code in the comments because (a) the first time I read the post I missed the comments completely; and (b) I thought you'd see it here anyway, and it could have become silly copying everything over. Some reasoning like that anyway. The code I posted doesn't really do anything new, it just happens to produce the ideal merge/lookup plan for me without hints.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 22, 2012 at 9:49 am
The Dixie Flatline (4/20/2012)
venoym
Dixie: Ever heard of Empire?
Back in the DOS days, I wasted many an hour on Empire. Lately, my turn-based timewaster has been Civilization IV, but I uninstalled it and went cold-turkey. Right now I kill about half an hour at night playing (don't laugh please) the original DOS version of Sid Meier's Railroad Tycoon.
I loved that game especially since you could build your own land masses and place the cities. The first night that I played it was an all-nighter. The thing that broke my concentration on the game was the rooster across the street announcing that dawn had happened.
Another total awesome game was "Commanche" which featured the player flying in an RAH-67 Stealth Helicoper on various missions. A joystick made the play much more interesting and lifelike. I still have the original games and, someday, I'm going to see if I can get it working on a newer box.
--Jeff Moden
April 22, 2012 at 10:22 pm
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by others with their own and nothing works because of differences between the code (app vs application in a column name for instance).
What is particularly interesting is when the change needed is so very minor to code previously provided. And in this particular case, I wasn't even sure what would happen until I tried it, and it appeared to solve the problem but not quite the way the poster had envisioned.
April 22, 2012 at 10:58 pm
Lynn Pettis (4/22/2012)
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by others with their own and nothing works beacuse of differences between the code (app vs application in a column anme for instance).What is particularly interesting is when the change needed is so very minor to code previously provided. And in this particular case, I wasn't even sure what would happen until I tried it, and it appeared to solve the problem but not quite the way the poster had envisioned.
IMNERHO, it all comes to the old prayer: Oh Lord, give me the strength to change what can be changed, the patience to accept what cannot be changed, and the wisdom to know which is which.
April 22, 2012 at 11:34 pm
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by others with their own and nothing works beacuse of differences between the code (app vs application in a column anme for instance).What is particularly interesting is when the change needed is so very minor to code previously provided. And in this particular case, I wasn't even sure what would happen until I tried it, and it appeared to solve the problem but not quite the way the poster had envisioned.
IMNERHO, it all comes to the old prayer: Oh Lord, give me the strength to change what can be changed, the patience to accept what cannot be changed, and the wisdom to know which is which.
And then you have those questions that make absolutly no sense what-so-ever.
April 22, 2012 at 11:48 pm
http://qa.sqlservercentral.com/Forums/Topic1287903-392-1.aspx
no comment needed.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2012 at 11:50 pm
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by others with their own and nothing works beacuse of differences between the code (app vs application in a column anme for instance).What is particularly interesting is when the change needed is so very minor to code previously provided. And in this particular case, I wasn't even sure what would happen until I tried it, and it appeared to solve the problem but not quite the way the poster had envisioned.
IMNERHO, it all comes to the old prayer: Oh Lord, give me the strength to change what can be changed, the patience to accept what cannot be changed, and the wisdom to know which is which.
And then you have those questions that make absolutly no sense what-so-ever.
That comes under "what cannot be changed." Having read your postings over several years, I am positive you do have the wisdom to understand that.
Viewing 15 posts - 35,656 through 35,670 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply