Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,0454,0464,0474,0484,049»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, July 8, 2013 7:25 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 3,605, Visits: 5,201
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 mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1471407
Posted Monday, July 8, 2013 8:07 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 3,605, Visits: 5,201
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 mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1471410
Posted Monday, July 8, 2013 8:23 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, June 11, 2014 5:42 PM
Points: 33,007, Visits: 15,132
Looks like notifications are working. Not sure if something broke loose or got fixed.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1471418
Posted Monday, July 8, 2013 8:25 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, July 4, 2014 11:42 AM
Points: 4,354, Visits: 3,383
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.
Post #1471419
Posted Tuesday, July 9, 2013 2:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 13,208, Visits: 10,075
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1471472
Posted Tuesday, July 9, 2013 5:03 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:17 AM
Points: 8,513, Visits: 9,001
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
Post #1471537
Posted Tuesday, July 9, 2013 7:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 6:13 AM
Points: 1,694, Visits: 19,550

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




____________________________________________________

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

Never approach a goat from the front, a horse from the rear, or a fool from any direction.
Post #1471610
Posted Tuesday, July 9, 2013 8:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 11, 2014 3:41 PM
Points: 1,208, Visits: 2,508
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
Blog: SQLSouth
Twitter: @SQLSouth
Post #1471656
Posted Tuesday, July 9, 2013 9:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:42 AM
Points: 42,349, Visits: 35,409
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1471677
Posted Tuesday, July 9, 2013 9:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 6:34 AM
Points: 7,108, Visits: 6,274
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! @=)


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1471684
« Prev Topic | Next Topic »

Add to briefcase «««4,0454,0464,0474,0484,049»»»

Permissions Expand / Collapse