Are the posted questions getting worse?

Question

Are the posted questions getting worse?

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Luis Cazares (4/14/2016)
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?
How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
Yes he did. Then the OP moved on to his loop to split strings. I referred him to Jeff's article and I'm curious on where it'll go.
IMO, people that can't understand INSERT INTO...SELECT shouldn't be coding ~~splitters~~ in T-SQL.

+100

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

jeff.mason (4/14/2016)
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.
Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from
(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
That made my head hurt.

if that could work, I wonder what the tree would look like.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Sean Lange (4/14/2016)
Grant Fritchey (4/14/2016)
Sean Lange (4/14/2016)
Oh that's right. It should be
;select
BURN IT WITH FIRE!!!!
Of course you do realize that all the same people that still start a cte with a semicolon will start doing this with select statements once it it required to terminate every statement. I am somewhat surprised I have not yet seen this recommendation by the pundits that insist on statement beginninators. 😀

I actually call this practice out during my "Anatomy of Select" presentation.

I hope someday I will get to present my Bare Naked and Anatomy sessions back to back.

That's "Bare Naked Skinny on SQL Server" and "Anatomy of Select".

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

BLOB EATER SSChampion Points: 14609 More actions · Answer 4

SQLRNNR (4/14/2016)
Sean Lange (4/14/2016)
Grant Fritchey (4/14/2016)
Sean Lange (4/14/2016)
Oh that's right. It should be
;select
BURN IT WITH FIRE!!!!
Of course you do realize that all the same people that still start a cte with a semicolon will start doing this with select statements once it it required to terminate every statement. I am somewhat surprised I have not yet seen this recommendation by the pundits that insist on statement beginninators. 😀
I actually call this practice out during my "Anatomy of Select" presentation.
I hope someday I will get to present my Bare Naked and Anatomy sessions back to back.
That's "Bare Naked Skinny on SQL Server" and "Anatomy of Select".

I would be very happy if I could see the "Anatomy of Select" presentation ?! 😛

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

*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

I don't have backup.

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

BLOB EATER SSChampion Points: 14609 More actions · Answer 6

GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.

I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just started to shake my head.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 7

GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.

How does one get incorrect page IDs in the headers?

Seriously. I'm trying to figure out how that one is possible.

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: 173068 More actions · Answer 8

BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just started to shake my head.

I'm trying to figure out where he got that bit of advice so I can avoid that site.

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.

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 9

Brandie Tarvin (4/15/2016)
BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just started to shake my head.
I'm trying to figure out where he got that bit of advice so I can avoid that site.

Paul Randal, perhaps? eg:

http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/[/url]

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/[/url]

Thomas Rushton
blog: https://thelonedba.wordpress.com

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.

I think you're looking for DBCC WRITEPAGE. Please first connect to dev and be careful.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 11

GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.

In 2016, with all of the available training, documentation, and general awareness and people STILL aren't taking backups?

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

Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.

Pages zeroed out by the IO subsystem. Literally portion of the file overwritten by zeros by misbehaving IO subsystem

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 13

jeff.mason (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
In 2016, with all of the available training, documentation, and general awareness and people STILL aren't taking backups?

Or, nuking the offsite backups along with the onsite servers. For get the whole "resume generating event" meme. This is a "lawyer hiring event" hmmm... that doesn't quite work well. Still, the idea is valid.

"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

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

Brandie Tarvin (4/15/2016)
BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just started to shake my head.
I'm trying to figure out where he got that bit of advice so I can avoid that site.

Paul Randal's blog, pluralsight courses, articles and PASS presentations.

It's the last ditch solution for attaching a damaged DB or one where the log file was lost.

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

Grumpy DBA SSChampion Points: 12515 More actions · Answer 15

GilaMonster (4/15/2016)
Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx
I don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.
Pages zeroed out by the IO subsystem. Literally portion of the file overwritten by zeros by misbehaving IO subsystem

If the OP copied the files from the original location to the new location instead of cutting and pasting the files he/she can re-attach the original files and take a backup. But he/she said the files were cut and pasted...