Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 19,801 through 19,815 (of 66,815 total)

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

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

The Dixie Flatline (10/4/2010)
Have saw, will travel. See you in 2 hours, Alvin.

Will you do the Mem-PASS presentation on Oct 14th? I won't be able to after you take my brain, at least I don't think I'll be able to. :doze:

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]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

CirquedeSQLeil (10/4/2010)
The Dixie Flatline (10/4/2010)
Have saw, will travel. See you in 2 hours, Alvin.
Is this the making of SAW CXLIV?

You have to admit, Bob's moniker makes for a good serial killer nickname too...

too bad about Alvin, I liked him....

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Alvin, taking your brain may have to wait until I can find a store that carries capers.

Do we still have an open date that needs a presenter?

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

The Dixie Flatline (10/4/2010)
Alvin, taking your brain may have to wait until I can find a store that carries capers.
Do we still have an open date that needs a presenter?

I'm still looking for Oct 14th. The DBA I work with just volunteered to talk about performance tuning on Nov 11th. He can't do Oct 14th. I heard the word honeymoon somewhere in his excuse.

Funny you should have mentioned capers. I come from a part of Nova Scotia called Cape Breton Island. The word "Capers" is often used to refer to people from there. 🙂

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]

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 5

I mentioned capers because of a surreal scene from the movie/book "Hannibal", but that makes my search irrelevant.

Packing now.

(I haven't volunteered for the 14th because I may have a conflict. Let me get back to you later this week.)

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 6

For those interested , attached is the script i used at sqlbits.

All pretty self explanatory really, i choose the tally split function to demonstrate

A) You cant trust the %tage of batch value in SSMS

B) Show parrallelism

Rather than just brut performance 😉

As you may see it is 99-newtally

I have scripts of 01 thru 07 to demonstrate ranking functions , cte , "It depends" ( Thanks Bob) and other bits and pieces. They didnt really fit in so didn't make the cut , but should be good for a more "dev" based audience.

As i say the other part of my session was based on my FIFO query, more of an interactive version of Kathi Kellenberger's analysis.

http://www.simple-talk.com/sql/performance/set-based-speed-phreakery-the-fifo-stock-inventory-sql-problem/

Clear Sky SQL
My Blog[/url]

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

For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx

There are days I just don't want to know...

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

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

GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx
There are days I just don't want to know...

I had to reply to that one.

I replied with http://lmgtfy.com/?q=How+to+use+Internet+Search+Engine

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]

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

I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

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

WayneS SSC Guru Points: 95461 More actions · Answer 10

Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx
There are days I just don't want to know...
I had to reply to that one.
I replied with http://lmgtfy.com/?q=How+to+use+Internet+Search+Engine

I prefer to use the url= tag, and put some simple text to click on. Something like

I think this link would help you out.

At least I get a double-bit of pleasure out of it! 😀

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

Chad Crawford SSChampion Points: 11610 More actions · Answer 11

Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

Thanks,

Chad

WayneS SSC Guru Points: 95461 More actions · Answer 12

GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

I'd do it after. That way, in case you got the wrong one, you can still delete it.

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 13

GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx
There are days I just don't want to know...

I'm apparently rather grumpy today. I had started writing a parody of how to hack a SQL server maliciously to drop a table, with the ending caveat "Of course, if you're the actual DBA, you should know how to open up HELP-Search and lookup delete database".

I deleted it halfway through.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

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

WayneS (10/4/2010)
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx
There are days I just don't want to know...
I had to reply to that one.
I replied with http://lmgtfy.com/?q=How+to+use+Internet+Search+Engine
I prefer to use the url= tag, and put some simple text to click on. Something like
I think this link would help you out.
At least I get a double-bit of pleasure out of it! 😀

I would have done it your way if I had remembered how. I editted my reply and fixed it.

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]

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

Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

All sessions, video, presenter's voice and desktop capture, plus ppt files.

It's not a DVD. The 2008 one was 6 DVDs

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