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,1594,1604,1614,1624,163»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, October 01, 2013 5:54 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: Today @ 2:24 AM
Points: 3,591, Visits: 5,100
<Ctrl-Alt-Delete>US Federal Government</Ctrl-Alt-Delete>

Could be the best thing to happen in years.

Living in Thailand, I'm hoping our government follows suit.



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 #1500631
Posted Tuesday, October 01, 2013 11:39 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:49 AM
Points: 22,506, Visits: 30,220
Sean Lange (10/1/2013)
Stefan Krzywicki (10/1/2013)
I now know why people hire wedding planners. Wow, this is a lot of work.


haha. I picked the band, the food and the tuxedos. Other than that the phrase most often heard from me around those planning my wedding was "tell me where to stand". My wife and mother in-law spent countless hours fretting over all the details. In the end it was worth the effort they put into it though. It has been 11 years (this month) and we still hear from relatives how much fun our wedding was.


Yes, I didn't have much say in the planning of my wedding back in 86, nor much say in the divorce in 11. Looking forward to the reconciliation when I redeploy to the States from Afghanistan!



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1500656
Posted Wednesday, October 02, 2013 1:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,207, Visits: 9,172
L' Eomot Inversé (10/1/2013)
Ed Wagner (10/1/2013)
jasona.work (10/1/2013)
Thanks. I initially held off on doing that, kind of felt like bringing gun to a hammer fight...

First of all, there's nothing wrong with being over-armed. Need I refer you back to the spud gun?

Second, report them. I don't even use the MS forums because of the degrading and rude garbage I've seen posted, not to mention that they don't even get to the answer. I know this is only my experience alone, but they left a strong impression.

I think its about ten and a half years since I gave up on MS forums. Quite apart from the total absence of useful response and the predominance of self-aggrandisement and bullying, letting your email address be visible in there was a guaranteed opening for a deluge of spam (thank heavens for disposable addresses). They may have improved since. Or not.


They have improved a bit (not regarding layout though). You sign in with the Microsoft Live ID, so your email is not visible.
I only speak from experience in the SSIS forum, but that one is quite useful. There are more MVPs and SSIS experts lurking on that forum than here for example.
From time to time though you have those persons from a certain country in the east trying to score as much points as possible, leading to ridiculous answers or just answers repeating other answers.




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 #1500667
Posted Wednesday, October 02, 2013 1:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,207, Visits: 9,172
On topic:

http://www.sqlservercentral.com/Forums/Topic1500646-1292-1.aspx




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 #1500673
Posted Wednesday, October 02, 2013 5:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:05 PM
Points: 1,148, Visits: 6,249


Wow.
Servers dedicated to a dataset.
Never worked somewhere where that was an option.
I feel like asking if the data sets come from the same database and it is beng replicated to the other servers.
Post #1500732
Posted Wednesday, October 02, 2013 6:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:07 AM
Points: 14,802, Visits: 27,277
GilaMonster (10/1/2013)
Grant Fritchey (10/1/2013)
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Paul White (10/1/2013)
GilaMonster (10/1/2013)
And if you want details, come to the WIT lunch on the Thursday.

I'll be there. A bit scared, probably, but I'll be there.


Good.

I'll probably be late to the WIT lunch. I have a commitment in the Community Zone for part of the lunch.


I'm on the panel this year, so being late is not an option. Don't know what nuggets of wisdom they expect me to impart, but whatever...


I'm at the official bloggers table for the WIT Lunch. Not sure what that means, but you lot had best keep in line. That's all I'm saying.


There's a blogger's table at lunch now? Isn't that going a little far?


Yeah, probably. But they asked, so I said yes.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1500741
Posted Wednesday, October 02, 2013 7:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 10, 2014 9:10 AM
Points: 2,694, Visits: 6,895
Lynn Pettis (10/1/2013)
Sean Lange (10/1/2013)
Stefan Krzywicki (10/1/2013)
I now know why people hire wedding planners. Wow, this is a lot of work.


haha. I picked the band, the food and the tuxedos. Other than that the phrase most often heard from me around those planning my wedding was "tell me where to stand". My wife and mother in-law spent countless hours fretting over all the details. In the end it was worth the effort they put into it though. It has been 11 years (this month) and we still hear from relatives how much fun our wedding was.


Yes, I didn't have much say in the planning of my wedding back in 86, nor much say in the divorce in 11. Looking forward to the reconciliation when I redeploy to the States from Afghanistan!


Great luck to you!


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1500769
Posted Wednesday, October 02, 2013 8:08 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 4:00 PM
Points: 35,967, Visits: 30,258


Oh my. I hope that's not what they're teaching in "university" now.


--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."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(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 #1500786
Posted Wednesday, October 02, 2013 8:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 11,990, Visits: 11,007
Jeff Moden (10/2/2013)


Oh my. I hope that's not what they're teaching in "university" now.


If you have read any of the other posts by that person you would know that if they actually went to "university" they didn't learn anything. There have been numerous threads about using dynamic sql, all of which have had some of us responding to cease and desist with the approach being taken. All in all quite scary to say the least.


_______________________________________________________________

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 #1500798
Posted Wednesday, October 02, 2013 8:45 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 20,462, Visits: 14,092
Jeff Moden (10/2/2013)


Oh my. I hope that's not what they're teaching in "university" now.


It is probably a university course. It is not too far from what one of my courses was. Yeah, the professor was unqualified and the content shallow at best, but the course was required.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1500801
« Prev Topic | Next Topic »

Add to briefcase «««4,1594,1604,1614,1624,163»»»

Permissions Expand / Collapse