July 8, 2013 at 12:37 pm
L' Eomot InversΓ© (7/7/2013)
jasona.work (7/5/2013)
Koen Verbeeck (7/5/2013)
jasona.work (7/5/2013)
You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...I could've driven a golf ball across the parking lot without worrying about hitting a car...
Going to be a lllooonnnggg day I think...
Today I was sitting in the lunch room with just 1 other colleague.
But I like working during the summer holiday: less traffic and less people nagging on my head π
Anyway, been absent of the thread for quite some time due to some deadlines. Did I miss anything?
I think a few dozen pages ago, Gail announced she was going to switch to using NoSQL and MySQL and Steve announced he was going to switch the back-end of the site over to Oracle...
But other than that, no, nothing really...
:hehe:
You missed the really important one: Jeff suggested a new fast way of solving some accumulation problems using nested non-static cursors over triangular joins. :hehe:
You forgot the important part where it used recursive CLR self-relaizing triggers that called PowerShell to run it on a surrogate server to control the process using multiple separate cascading threads to return vectored MARS to be saved in files to be imported by SSIS and displayed using SSRS. π
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2013 at 5:42 pm
Jeff Moden (7/8/2013)
You forgot the important part where it used recursive CLR self-relaizing triggers that called PowerShell to run it on a surrogate server to control the process using multiple separate cascading threads to return vectored MARS to be saved in files to be imported by SSIS and displayed using SSRS. π
SSIS made the list. YES!
:{>
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics
July 8, 2013 at 6:06 pm
wolfkillj (7/8/2013)
If you haven't seen this already, you're due for some Monday-morning laughs!
Something broke with that link...
http://www.buzzfeed.com/daves4/jokes-only-nerds-will-understand
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2013 at 7:24 pm
Jeff Moden (7/8/2013)
L' Eomot InversΓ© (7/7/2013)
jasona.work (7/5/2013)
Koen Verbeeck (7/5/2013)
jasona.work (7/5/2013)
You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...I could've driven a golf ball across the parking lot without worrying about hitting a car...
Going to be a lllooonnnggg day I think...
Today I was sitting in the lunch room with just 1 other colleague.
But I like working during the summer holiday: less traffic and less people nagging on my head π
Anyway, been absent of the thread for quite some time due to some deadlines. Did I miss anything?
I think a few dozen pages ago, Gail announced she was going to switch to using NoSQL and MySQL and Steve announced he was going to switch the back-end of the site over to Oracle...
But other than that, no, nothing really...
:hehe:
You missed the really important one: Jeff suggested a new fast way of solving some accumulation problems using nested non-static cursors over triangular joins. :hehe:
You forgot the important part where it used recursive CLR self-relaizing triggers that called PowerShell to run it on a surrogate server to control the process using multiple separate cascading threads to return vectored MARS to be saved in files to be imported by SSIS and displayed using SSRS. π
And you missed the post where CELKO was actually nice to someone!
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
July 8, 2013 at 7:25 pm
Steve Jones - SSC Editor (7/8/2013)
Notifications working for people? Seem like the queue might be stuck.
Queue is definitely still stuck, although I did just receive one notification on this thread and that's what brought me here.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
July 8, 2013 at 8:07 pm
dwain.c (7/8/2013)
Steve Jones - SSC Editor (7/8/2013)
Notifications working for people? Seem like the queue might be stuck.Queue is definitely still stuck, although I did just receive one notification on this thread and that's what brought me here.
I think the notifications have all come through now.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
July 8, 2013 at 8:23 pm
Looks like notifications are working. Not sure if something broke loose or got fixed.
July 8, 2013 at 8:25 pm
Steve Jones - SSC Editor (7/8/2013)
Looks like notifications are working. Not sure if something broke loose or got fixed.
There are probably two bugs that coincidentally compensate each other. π
July 9, 2013 at 2:14 am
Brandie Tarvin (7/8/2013)
Koen Verbeeck (7/6/2013)
It was closed the week we were there for maintenance...Wait. You were there for maintenance and it was closed ... so you couldn't do your maintenance?
(Grammar humor strikes again! @=)
Yeah sure, laugh with the non-native English speaker π
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 5:03 am
Koen Verbeeck (7/9/2013)
Brandie Tarvin (7/8/2013)
Koen Verbeeck (7/6/2013)
It was closed the week we were there for maintenance...Wait. You were there for maintenance and it was closed ... so you couldn't do your maintenance?
(Grammar humor strikes again! @=)
Yeah sure, laugh with the non-native English speaker π
You shouldn't tease and tweak us like that, Koen.
Given that Flemish is a Germanic language with supposedly a lot of grammar and syntax in common with English and German, and German is further from English than Flemish is, it seems interesting that only tiny changes in the English wording (apart from vocab change, of course) to get "Es war der Woche geschlossen, in denen wir dort fΓΌr Wartungsarbeiten waren" in German. My German is very rusty, so I guess that may not be quite right; the tiny changes consist in moving "geschlossen" to the end of its clause, "waren" to the end of its subordinate clause and restoring the elided "for which" (in denen) that is normally omitted in informal English. I think that in informal German waren would come immediately after "dort", but my schooling was of course in formal German and my acquaintance with informal German was too long ago, so I'm playing safe. Now I can't see how the German would be interpreted any way other that the way Brandie interpreted your English, so I strongly suspect that if it were written that way in Flemish the same interpretation would be natural too. So I suspect you are pulling our leg with your non-native speaker comment. Now if I spoke Dutch that suspicion might be confirmed, or denied - but I don't even know enough Dutch to understand how smileys work in the written form of that language.
Anyway, educated Flemish and Dutch people have a great advantage over most Americans and English when interpreting written English: their knowledge of the language's vocabulary, syntax, and grammar is usually far better that that of the typical English or American university graduate, because they learn it in school; the teaching of English grammar and syntax in most schools in Britain and the USA was abandoned as being far too difficult for the poor little kiddies decades ago.
Tom
July 9, 2013 at 7:30 am
Strange, but there seems to be a number of old threads being answered
http://www.sqlservercentral.com/Forums/Topic950491-145-1.aspx
http://www.sqlservercentral.com/Forums/Topic334022-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic512190-338-1.aspx
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537July 9, 2013 at 8:34 am
GilaMonster (7/8/2013)
wolfkillj (7/8/2013)
If you haven't seen this already, you're due for some Monday-morning laughs!Something broke with that link...
http://www.buzzfeed.com/daves4/jokes-only-nerds-will-understand
Yep, I fixed it. Seems that if one encloses the URL in double quotes in the opening tag (e.g., url="someurl.com"), clicking the link just opens the current page.
At first, I thought Gail must be psychic to know which page I was trying to link, but I'm only slightly less impressed that she thought it worth viewing the source code of the page to figure it out!
Jason Wolfkill
July 9, 2013 at 9:03 am
wolfkillj (7/9/2013)
At first, I thought Gail must be psychic to know which page I was trying to link, but I'm only slightly less impressed that she thought it worth viewing the source code of the page to figure it out!
I hit 'quote' on your post.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 9:07 am
GilaMonster (7/9/2013)
wolfkillj (7/9/2013)
At first, I thought Gail must be psychic to know which page I was trying to link, but I'm only slightly less impressed that she thought it worth viewing the source code of the page to figure it out!I hit 'quote' on your post.
HUSH, Gail. That trick is supposed to be a secret of the SQL Conspiracy! @=)
Viewing 15 posts - 40,456 through 40,470 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply