Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 38,536 through 38,550 (of 66,712 total)

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

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

And then you get this:

Shadab Shah (12/23/2012)
I create a table as CREATE TABLE DEMO (A INT)
Then i deleted it as follow
DELETE DEMO
I tried to again recreate the table using the same above statement, But it gave me the following error message
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'DEMO' in the database.
Now over here i am trying to understand when i deleted the table using delete how is it showing me the error message.

The answer you want to give is: Put down the mouse and step away from the keyboard.

For those interested in a link, http://www.sqlservercentral.com/Forums/Topic1399787-392-1.aspx

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Jeff Moden (12/23/2012)
I don't know about the rest of you, but the amount of SPAM posts on SSC seems to be growing. I even got SPAMmed on my PM just now.

Three times so far.

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

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

Jeff Moden (12/23/2012)
I don't know about the rest of you, but the amount of SPAM posts on SSC seems to be growing. I even got SPAMmed on my PM just now. Just in case any of you folks want a date with "Rebeca", here's what they PM'd me with... 😉
Hello Dearest,
My name is Rebeca.How are you?
I Hope you are fine and in
perfect Health.
i came across your profile
and deemed it
necessary to write
you immediately.
Am too curious to know you more.
Could you
please reciprocate
to my message by dropping mail
on my yahoo id
(rebecadesmond4love@yahoo.com)so
we can introduce our-self
better on yahoo media
and also share the passion
of love together.
I will be waiting for your
email because i have
a suitable and vital thing
to tell you. Have a nice
day and God bless you,
I will send you my picture
as soon as i receive your mail:
thanks your new friend. Rebeca......
rebecadesmond4love@yahoo.com

Rebeca must be going after only the top posters because I haven't gotten one of her love letters yet.

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

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

Anyone with links to RAID 10 vs RAID 5, please post them here.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

dwain.c (12/24/2012)
Rebeca must be going after only the top posters because I haven't gotten one of her love letters yet.

Heh... maybe I should start carrying a fish around in my Avatar. 😛

MERRY CHRISTMAS EVERYONE!!!

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Merry Christmas Everybody

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

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

Merry Christam everyone.

We are having a White Christmas here. It has been snowing since 6:00 PM and is still snowing now.

Brandie Tarvin SSC Guru Points: 173063 More actions · Answer 8

SQLRNNR (12/20/2012)
Anybody else not receiving the topic notifications from SSC?

Proof the world actually did try to end... and failed miserably at it since notifications started going out again. 😀

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: 173063 More actions · Answer 9

I hope everyone enjoyed their holidays and got what they wanted for Christmas. I ended up with cookies and a portable scanner (all good IMHO). And I went to see The Hobbit yesterday too. Not bad. Loved Sylvester McCoy's part. He did a brilliant job.

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: 1004504 More actions · Answer 10

Box set of Star Trek: The Next Generation DVDs. All seasons.

You guys don't need me for the next month or so, do you?

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

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

GilaMonster (12/26/2012)
Box set of Star Trek: The Next Generation DVDs. All seasons.
You guys don't need me for the next month or so, do you?

Now now, the pilot only SEEMS like it lasts a month or so.

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

EL Jerry SSCertifiable Points: 7063 More actions · Answer 12

Hi all!!!

I hope everybody had a very Merry Christmas.

Can someone with more experience on SSIS provide some guidance here?

I will thank you so much.

Saludos,

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

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

WordPress users, can you answer some questions for me? http://www.sqlservercentral.com/Forums/Topic1400585-61-1.aspx.

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.

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 14

SQLRNNR (12/23/2012)
L' Eomot Inversé (12/23/2012)
Lynn Pettis (12/22/2012)
Constantly amazed by the number of people who think that full backups truncate the transaction log. Where do they get such ideas?
That's a clear sign that you are over-optimistic about the average DBA's willingness to put in enough effort to understand how backups and transaction logs work.
They pull such ideas out of nonsense that they find on the web; they find the nonsense on the web because it's easier to ask google to find something dumbed down than to endure the pain or reading proper documentation.
They are to lazy to be productively lazy (which is what all competent engineers are - getting it right first time is a sign of supreme laziness combined with an awareness that it's less pain to do a task once than half a doxzen times).
so efficiently lazy vs incompetently lazy

This reminds me of the old Army proverb:

Give the hardest job to the laziest man because he finds the easiest way to do it.

Jason Wolfkill

Chad Crawford SSChampion Points: 11610 More actions · Answer 15

Sweet awesomeness: Dr. Who Stamps

I spent 10 minutes trying to figure out how to send all my friends a letter from the UK, finally realized that the easiest (and cheapest) is going to be to get the stamps and just include one in addition to the regular postage (as a "decoration" rather than postage). Can't wait until March!

Chad