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,0444,0454,0464,0474,048»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, July 8, 2013 9:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:41 PM
Points: 1,061, Visits: 2,573
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! @=)


Let's eat Grandma!


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1471244
Posted Monday, July 8, 2013 9:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:41 PM
Points: 1,061, Visits: 2,573
If you haven't seen this already, you're due for some Monday-morning laughs!

EDIT: Fixed the hyperlink. D'oh!


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1471247
Posted Monday, July 8, 2013 10:17 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 6:53 PM
Points: 31,177, Visits: 15,623
Notifications working for people? Seem like the queue might be stuck.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1471264
Posted Monday, July 8, 2013 10:47 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 @ 6:30 AM
Points: 40,184, Visits: 36,591
Ignoring my mail, so hadn't noticed. No notifications today.


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 #1471283
Posted Monday, July 8, 2013 10:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 13,082, Visits: 12,546
Steve Jones - SSC Editor (7/8/2013)
Notifications working for people? Seem like the queue might be stuck.


None here.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1471289
Posted Monday, July 8, 2013 12:37 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 35,366, Visits: 31,902
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...

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.


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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1471320
Posted Monday, July 8, 2013 5:04 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 505, Visits: 1,691
wolfkillj (7/8/2013)
If you haven't seen this already, you're due for some Monday-morning laughs!


Good Lord, someone made The Thread recursive!

Is there a punishment for that?






Post #1471391
Posted Monday, July 8, 2013 5:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1471394
Posted Monday, July 8, 2013 6:06 PM


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 @ 6:30 AM
Points: 40,184, Visits: 36,591
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 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 #1471398
Posted Monday, July 8, 2013 7:24 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: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
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...

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.


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 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 #1471406
« Prev Topic | Next Topic »

Add to briefcase «««4,0444,0454,0464,0474,048»»»

Permissions Expand / Collapse