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,1504,1514,1524,1534,154»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Sunday, September 29, 2013 6:32 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 @ 8:25 AM
Points: 43,016, Visits: 36,177
*sigh*





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 #1499810
Posted Monday, September 30, 2013 5:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 15,735, Visits: 28,137
hisakimatama (9/27/2013)
Rawr! I did it! Worked a full 8 hours on the stupid query that made me quite grumpy yesterday, converting it into a much better SQL statement and routing it through SSRS instead. Execution time for the report on a heavy-workload project is about 10 seconds, so not overly bad; previously, the same project took 10-15 minutes, so this is much, much better. Kicked the NOLOCK junk out of the query, too, which seemed like it was there to offset the completely unnecessary burden created by the DISTINCT. Would've liked to solve the problem faster, but figuring the logic of the query out was infinitely less intuitive than I would've liked .

Grant, it looks like the guy you were mentioning earlier has backed off on his stance on NOLOCK, so I don't think I need to DBCC TIMEWARP back to when his horse was still alive to give it a valid beating at present. Would you like me to chime in over there anyhow? I can round up a fresh batch of hamster poo for fuel for added accuracy


It can't hurt. Someone else will find that thread through searches. They might as well see that it's a true thing in production.


----------------------------------------------------
"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 #1499946
Posted Monday, September 30, 2013 5:51 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 15,735, Visits: 28,137
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!


Congrats Granddad.


----------------------------------------------------
"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 #1499948
Posted Monday, September 30, 2013 6:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 7,210, Visits: 6,351
Grant Fritchey (9/30/2013)
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!


Congrats Granddad.


Congrats, indeed.


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 #1499950
Posted Monday, September 30, 2013 6:47 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 4,326, Visits: 3,369
Brandie Tarvin (9/30/2013)
Grant Fritchey (9/30/2013)
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!


Congrats Granddad.


Congrats, indeed.

Congratulations, Lynn. I hope mother and baby are both doing well.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1499965
Posted Monday, September 30, 2013 6:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 11,308, Visits: 13,097
Jeff Moden (9/28/2013)
GilaMonster (9/28/2013)
Jeff Moden (9/27/2013)
Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that no one responded to...


After googling, i have learnt to open a new clr stored procedure project to convert rtf format. But as i told, i have no knowledge..So could you please guide me from here?


First, I congratulate everyone for not responding to that post because even I have my limits and had to make a conscious effort to not respond to it with less than subtle hints about using tools they don't know anything about and maybe a rant about having other people do their job for them.

The economy must be picking up because I'm seeing more and more "I have no knowledge {of SQL}" types of posts across the board. Apparently, more and more people are getting themselves hired with "no knowledge". I blame the interviewers for this type of thing.

Have you folks observed the same kind of thing over the last month or so or is it just me?


Have you seen the myriad of dynamic SQL related questions the last few days?


Heh... between that and TempDB questions (and some of the answers, apparently... 50MB) by people who have "no knowledge", it's been a real hoot.


I would say that it depends on where you are. In New England the unemployment rate is ~2% in IT and there are a lot of SQL Server jobs open. I'd also venture to say that the 2% are probably not top-notch or are new graduates who have unrealistic compensation expectations for their first job. Employers are still trying to low-ball people, which is why positions stay open in New England. No ones moving to a new job without a decent increase.

Also in the US, pretty much all the consultants I know have enough work and are actually looking for help in many cases. Case in point is Brent Ozar Unlimited adding an employee.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1499966
Posted Monday, September 30, 2013 6:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 11,308, Visits: 13,097
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!


Congrats grampa! I'm hoping I'm at least 10 more years before being a grandfather.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1499968
Posted Monday, September 30, 2013 6:55 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 @ 8:25 AM
Points: 43,016, Visits: 36,177
Wish it was like that here. Was an unexpected slump late May, early June. I'm not the only one seeing it. Have two friends, one has just found his first contract since March, the other has accepted a crap job that he hates because it's all he could find.


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 #1499975
Posted Monday, September 30, 2013 6:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 11,308, Visits: 13,097
GilaMonster (9/27/2013)
Thursday at Summit is going to be sooo funny. Just saying...


Okay, I need some more info on this one. I don't see anything on the schedule that funny going on Thursday.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1499983
Posted Monday, September 30, 2013 7:19 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 @ 8:25 AM
Points: 43,016, Visits: 36,177
Jack Corbett (9/30/2013)
GilaMonster (9/27/2013)
Thursday at Summit is going to be sooo funny. Just saying...


Okay, I need some more info on this one. I don't see anything on the schedule that funny going on Thursday.


I didn't say there was something funny on the Thursday schedule.



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

Add to briefcase «««4,1504,1514,1524,1534,154»»»

Permissions Expand / Collapse