Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,956 through 20,970 (of 66,815 total)

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

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

Waving to Grant across the interwebs while listening to him present on execution plans!

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.

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

And if you know execution plans, Red Gate has a Storage Compress webinar running now showing how SQL Storage Compress can work with Standard edition to compress data files

http://is.gd/goyuG

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 3

Jack Corbett (10/28/2010)
Steve Jones - SSC Editor (10/27/2010)
BTW, SSC usually has a blogger at the blogger table during the PASS Summit. Usually it's me, someone that can take notes during keynotes and post them. Since I won't be there....
any of you rapid posters want to lug a laptop to the keynote each day and take some notes and post a blog? One a day is fine, more are better, but up to you.
Ping me if you want the spot.
I'm not sure how much time I'll have. I'm part of the O.C. so may have a group with me on Tuesday and I'm doing Ambassador duty on Wednesday morning for the keynote. I could help on Thursday, but I think that is Dr. DeWitt's day and last year his keynote was WAY over my head, so if this year is anything like it I'm not sure I'd have anything coherent. Let me know if you need someone though and I'll do it.

I wonder who is my OC. I know it is not @KarlaKay. Is it you?

-Roy

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

Roy Ernest (10/28/2010)
I wonder who is my OC. I know it is not @KarlaKay. Is it you?

Nope not me. Hopefully your OC will be contacting you. Last I knew there weren't enough volunteers for every newbie to have an OC. Let me reach out to some people at PASS and see if I can find out if you have one. If not, you are more than welcome to join my group, although if you just connect with the Threadizens and Twitter folks you'll have plenty of people to connect you to others and show you the ropes.

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 6

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in the "Write for us" link so you don't have much to do to put it out there.

Jeff, using SQL 2008. Download your document, extracted the code and ran your final T-SQL statement:

--===== SUM the data for each month and sort the month names correctly.

-- This one uses the full name of each month but doesn't sort.

--Underline added by this poster after running test

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >= '2010' AND SomeDateTime < '2011'

GROUP BY DATENAME(mm,SomeDateTime)

ORDER BY CAST(DATENAME(mm,SomeDateTime) + ' 1900' AS DATETIME)

;

Result:

Month Amount

January 213665.0272

February 195819.2182

March 211982.3151

April 203193.0472

May 214721.4149

June 207117.3762

July 215776.2994

August 217355.827

September 201470.5969

October 213793.1216

November 200701.9644

December 208130.2764

Sure looks sorted to me, by month that is, NOT amount. Or am I missunderstanding your comments?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 7

GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!

Excellent! always good to have caps go up.

I recently analyzed my cell phone data, curious what the 1GB and 2GB plans from other carriers would mean. I use a little under 200MB a month, so less than I thought.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 8

Jack Corbett (10/28/2010)
Roy Ernest (10/28/2010)
I wonder who is my OC. I know it is not @KarlaKay. Is it you?
Nope not me. Hopefully your OC will be contacting you. Last I knew there weren't enough volunteers for every newbie to have an OC. Let me reach out to some people at PASS and see if I can find out if you have one. If not, you are more than welcome to join my group, although if you just connect with the Threadizens and Twitter folks you'll have plenty of people to connect you to others and show you the ropes.

I will be hanging around the Threadizens more than Twitter folks I guess. I have known the Threadizens more than the twitterazies.

-Roy

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 9

bitbucket-25253 (10/28/2010)
Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in the "Write for us" link so you don't have much to do to put it out there.
Jeff, using SQL 2008. Download your document, extracted the code and ran your final T-SQL statement:
--===== SUM the data for each month and sort the month names correctly.
-- This one uses the full name of each month but doesn't sort.
--Underline added by this poster after running test
SELECT [Month] = DATENAME(mm,SomeDateTime),
Amount = SUM(SomeAmount)
FROM #MyHead
WHERE SomeDateTime >= '2010' AND SomeDateTime < '2011'
GROUP BY DATENAME(mm,SomeDateTime)
ORDER BY CAST(DATENAME(mm,SomeDateTime) + ' 1900' AS DATETIME)
;
Result:
Month Amount
January 213665.0272
February 195819.2182
March 211982.3151
April 203193.0472
May 214721.4149
June 207117.3762
July 215776.2994
August 217355.827
September 201470.5969
October 213793.1216
November 200701.9644
December 208130.2764
Sure looks sorted to me, by month that is, NOT amount. Or am I missunderstanding your comments?

Somedays it just doesn't pay to copy and paste (especially that early in the day). Thanks for the catch, Ron.

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

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 10

jcrawf02 (10/28/2010)
Jeff Moden (10/27/2010)
Great idea. As a side bar... you may not be able to tell the last time a table was accessed but... you should be able to tell the last time one of the indexes on the table was used which would equate to the same thing.
Not the way I code :hehe: Indexes are for weenies

:-D:-P:-D:-P:-D:-P

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

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 11

Grant Fritchey (10/28/2010)
Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Grant Fritchey (10/27/2010)
Look for the tall bald guy in a red vest.
Or the hairy legs under a short ~~skirt~~ kilt
GAH!!!! 😀
Oh squid boy, you know you like it.
What was that old saying, submarines go out to see with 120 men and come back with...

Heh... I've got enough hair on my legs to weave a kilt and he calls me "boy". 😛

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

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 12

Tom.Thomson (10/28/2010)

Jeff Moden (10/27/2010)
If you wanted a small jingle... (sung to the tune of "Row, Row, Row Your Boat")
You shouldn't mention that in an SQL forum: "Row" is unspeakable, think of columns and sets instead. :hehe:

It just sounded so much better than "Record, Record, Record Your Boat" as others may say. 😀

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

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

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

GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!

AWESOME! Time to start watching some shows! @=)

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.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 14

FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.

Now I'm obsessing about my latest project, trying to tweak it. Odd thing is, I removed an ORDER BY clause, thinking it'd make a SORT go away (which it did) but it increased the query time by 1 second. ???

Anyway, having fun with the new stuff I learned listening to Grant. Really really really recommend his session for PASS-going folks.

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.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 15

Brandie Tarvin (10/28/2010)
GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!
AWESOME! Time to start watching some shows! @=)

I was more thinking of hitting MSDN downloads and DNRTV. 😉

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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