Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 19,951 through 19,965 (of 66,749 total)

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

Steve Jones - SSC Editor (10/6/2010)
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Up in the air here. Trying to work out a schedule that won't kill me and keep me married. I'd like to come, but we'll see.

It's a bit too far for me.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.

Where does one see the total posts on the forum?

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

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 4

Stefan Krzywicki (10/6/2010)
Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.
Where does one see the total posts on the forum?

Go to the forum page (http://www.sqlservercentral.com/Forums/Forum61-1.aspx)

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.

Look to the left of any post and you'll see what post number that was. I believe yours was 999384

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Luke L SSC-Dedicated Points: 35547 More actions · Answer 6

Look below your name, points etc on the left. You'll see post # ######. That was the number of your post, if yours was the most recently posted post, you know the number...

Granted it's a indentity column and there have been some removed so there are holes so to see the actual number, look at your profile in the user details section you'll see something like this...

Total Points: # point out of # total points. (#% of total)

The total points should be the total number of posts, as that is your forum user profile, while your individual total points includes Qotd performance, the larger total number to the right seems to not include it.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

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

Alvin Ramard (10/6/2010)
Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.
Look to the left of any post and you'll see what post number that was. I believe yours was 999384

HA! That'll teach me to look down more often. : -)

Thanks Alvin!

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

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

Steve Jones - SSC Editor (10/6/2010)
Stefan Krzywicki (10/6/2010)
Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.
Where does one see the total posts on the forum?
Go to the forum page (http://www.sqlservercentral.com/Forums/Forum61-1.aspx)

First thing I did was go look at the main page for the forums, but I just don't see a total there.

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 9

Stefan Krzywicki (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
Stefan Krzywicki (10/6/2010)
Alvin Ramard (10/6/2010)
Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.
Where does one see the total posts on the forum?
Go to the forum page (http://www.sqlservercentral.com/Forums/Forum61-1.aspx)
First thing I did was go look at the main page for the forums, but I just don't see a total there.

Also, if you go to the SSC home page and look at the Latest forum posts, hold the mouse over the latest post and look at the url. The url ends with the post number of that post. It may not be the latest, but it should be close.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 10

Steve Jones - SSC Editor

SSC Guru

Points: 736642

October 6, 2010 at 8:44 am

#1232636

It's "Replies"

19,5something in the attachment

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

Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

^{“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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

Chris Morris-439714 (10/6/2010)
Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

Steve, didn't you tell us a while back that it was a bigint?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 13

Chris Morris-439714 (10/6/2010)
Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

Numeric instead of Integar? Bad cowboy! Doesn't he know that extra byte could be given to starving orphans lost in the wilds of New York City?

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

GilaMonster (10/6/2010)
Anyone interested in tackling the 'truncate table is not logged and cannot be rolled back' myth for this month's T-SQL tuesday?
http://sankarreddy.com/2010/10/invitation-to-participate-in-t-sql-tuesday-11-misconceptions-in-sql-server/

That sounds like a fun one, unless you have dibs already...

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

WayneS SSC Guru Points: 95461 More actions · Answer 15

GilaMonster (10/6/2010)
... I have 3 table variable myths targeted.

Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can enhance it (and add it to the presentation that I'm making on this article!).

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2