Are the posted questions getting worse?

Question

Are the posted questions getting worse?

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

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

GilaMonster (10/6/2010)
Paul White NZ (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top?http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No, what makes you think it might have been?
Reading over it after I posted it read (to me) almost like a tirade rather than an explanation.
The misconceptions concerning shrinking versus truncating logs might make for a better '2sday' blog post than 'truncate table cannot be rolled back'. Both have been covered very many times, and yet both persist...:(
I've written twice on that already (blog post and article). Not touching it again (until it's time to rewrite my tran log article here). If you want it, take it. I have 3 table variable myths targeted.

So many good articles for 2sday coming from the thread today.

How about the myth about DBCC Timewarp?

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

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

CirquedeSQLeil (10/6/2010)
How about the myth about DBCC Timewarp?

What myth? 😀

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: 738683 More actions · Answer 3

I just checked. Almost everything in the db for forums is an int, so we're fine.

As an FYI, we have about 5GB of data in the forum database.

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

Steve Jones - SSC Editor (10/6/2010)
I just checked. Almost everything in the db for forums is an int, so we're fine.
As an FYI, we have about 5GB of data in the forum database.

int? We're good for a few more weeks then. 😛

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 5

Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

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

Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

LOL

I haven't had to face that yet so I can't comment, well, looks like I just did.

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]

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 7

Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

That sentence is WAY too long:

Wow, loading data into Access is a Royal PITA

"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

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

Grant Fritchey (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
That sentence is WAY too long:
Wow, loading data into Access is a Royal PITA

Still too long.

Access is a Royal PITA

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 9

Grant Fritchey (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
That sentence is WAY too long:
Wow, loading data into Access is a Royal PITA

You've got me there!

You know, the older versions of Access were at least usable (from 2 on). I haven't had to touch 2007 before this job and it is like Microsoft decided it was too useful or that the target audience was a bunch of brain damaged tapirs.

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

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

CirquedeSQLeil (10/6/2010)
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...

No, I'm debunking 3 table variable myths.

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

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

WayneS (10/6/2010)
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!).

Two yes, one no, though I'm planning to debunk one of the ones you did in a very different way.

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

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

Steve Jones - SSC Editor (10/6/2010)
As an FYI, we have about 5GB of data in the forum database.

Only? I thought there's be quite a bit more than that.

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

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

1mm posts, most are bytes long. Not a lot of space in use there.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 14

Wow the site and thread have been busy today. < 500 posts for 1 million.

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

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

Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

I think that's because nobody ever considered that this was a possibility. Why are you being forced to do this?

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