Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 41,191 through 41,205 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Thanks for the compliment Ed. :blush:

_______________________________________________________________

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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Submitted on the site. There's a WYSIWYG editor.

Turnaround, 2-4 weeks. None are hard, and many of you could knock one out in an evening, but you might want to think about it.

In general, most are 1-2 pages, designed to hit a specific item I've seen multiple newbies ask about.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Congrats

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 4

Well done!

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jasona.work SSC Guru Points: 50117 More actions · Answer 5

Let me think about it, I might try writing it up first, see how I like it and how long it takes to get it done...

I do like to think that I write nice, coherent, easy to follow directions, so this might be a good fit for me.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 6

Time for some begging. If any of you will be in the Boston area Monday, October, 28 and would be willing to speak at the Seacoast SQL User group up in Portsmouth, NH (about an hour north of Boston depending on traffic) let me know. Actually if any of you have a time you know you'll be in the area and you are willing to speak let me know and if we are meeting I'll try to get you in. I know some of you live in New England and others work for companies in New England and are in the area sometimes. You can PM me here or, many of you have my personal email already and can use that.

Jack Corbett
Consultant - Straight Path Solutions
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

Dwain Camps SSC Guru Points: 86948 More actions · Answer 7

Super achievement Sean!

Your posts, helpfulness and patience have been an inspiration to me.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

Nice work, Sean. You've crafted some exceptional work in them there 10,000 posts and I reckon you've raised the bar for the overall quality of code especially for the "low hanging fruit", which, if it isn't addressed early, appears to attract shelf-stacker coders.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Congratulations! Before you know it you may pass me. 😀

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 10

I opened a MS Connect item yesterday. There were two previous reports of this that were closed because MS couldn't reproduce the issue. If you've had this problem, could you please upvote, comment, and add that you've experienced this issue with SSMS job activity monitor?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 11

Excellent! Makes me realise I have a long way to go.

____________________________________________________

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/61537

jasona.work SSC Guru Points: 50117 More actions · Answer 12

Had an interesting last couple days...

Yesterday a department managed to completely jack their Sharepoint site permissions (@ 11:30am) and finally they told the Sharepoint farm admin around 2:30-3pm...

Had to back up their current DB, restore into QA for the SP Admin, then restore a backup, stopping at ~11:30am.

That took until 7pm to finish restoring...

Then today another app owner (not Sharepoint) messed up a historical table in a DB (deleted a bunch of records he didn't intend to,) so I needed to restore a copy of that DB to QA. Unfortunately (well, not really, as you'll see) the Commvault system hadn't taken a backup since last night on the server in question. So, restore the most recent Commvault backup and leave the DB recovering, take a TLog backup of the "broken" DB (copy_only) and restore said TLog backup with stopat.

Then start installing a new SQL08R2 server for a new QA Sharepoint farm...

I *LIKE* sort of busy days like this, it keeps me out of trouble!

:hehe:

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 13

http://www.liveleak.com/view?i=424_1378224156

Let's stick Jeff in this interview 😉

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 14

Item not found?

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

There was an extra br in Steve's url

http://www.liveleak.com/view?i=424_1378224156

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events