Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 48,976 through 48,990 (of 66,712 total)

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

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

Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because someone changed passwords without considering the impact, I'm going to be very, very, very unimpressed.
SQL authentication?

Yes. Publisher and distributor are in different domains.

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 2

Getting back to the original intention of this thread ... Are the posted questions getting worse? For some posters at least, YES!!!!!

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

jasona.work (6/16/2015)
So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012 then scripting it out and "tweaking" it to work in SQL2008R2. That part was easy.
The fun part was figuring out how to query the XML data for what I want, rather than trying to read the XML directly.
Now to continue to putter around with xQuery / xPath to get it formatted even better...

Lol - working smarter not harder there 😉

As for the xQuery crap - I have a bunch of samples on my blog for various XE sessions if you want to "work smarter" some more.

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 4

GilaMonster (6/22/2015)
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because someone changed passwords without considering the impact, I'm going to be very, very, very unimpressed.
SQL authentication?
Yes. Publisher and distributor are in different domains.

Somebody needs a boot to the head.

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 5

Alvin Ramard (6/22/2015)
Getting back to the original intention of this thread ... Are the posted questions getting worse? For some posters at least, YES!!!!!

From the original intent we are far from, yes.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Lynn Pettis (6/22/2015)
Alvin Ramard (6/22/2015)
Getting back to the original intention of this thread ... Are the posted questions getting worse? For some posters at least, YES!!!!!
From the original intent we are far from, yes.

There is no intent, only do or do not!

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

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

SQLRNNR (6/22/2015)
GilaMonster (6/22/2015)
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because someone changed passwords without considering the impact, I'm going to be very, very, very unimpressed.
SQL authentication?
Yes. Publisher and distributor are in different domains.
Somebody needs a boot to the head.

The person who designed it to have publisher & distributor in different domains (me) or the person who seems to have changed the password?

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

jasona.work SSC Guru Points: 50117 More actions · Answer 8

SQLRNNR (6/22/2015)
jasona.work (6/16/2015)
So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012 then scripting it out and "tweaking" it to work in SQL2008R2. That part was easy.
The fun part was figuring out how to query the XML data for what I want, rather than trying to read the XML directly.
Now to continue to putter around with xQuery / xPath to get it formatted even better...
Lol - working smarter not harder there 😉
As for the xQuery crap - I have a bunch of samples on my blog for various XE sessions if you want to "work smarter" some more.

I love the fact that the very first post to pop up on your blog when I checked, showed me how to pull out a value that I wanted in my results, in a way that I wanted it...

Now I'm playing around with improving the speed of the query itself by puttering around with an XML index...

Of course, I'm also now wondering if I might be better served to put the data from the XE session into my temp table in the format I'm looking for, rather than as the "raw" XML...

/Edit:

And now browsing deeper into your blog, I realized that it's where I started when I began working on my query...

🙂

Ain't life funny?

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

jasona.work (6/23/2015)
Of course, I'm also now wondering if I might be better served to put the data from the XE session into my temp table in the format I'm looking for, rather than as the "raw" XML...

I typically shred the XML in the query that reads it from the file target, however I've run TempDB out of space a couple times doing that with large files (~50GB).

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 10

Wow, you guys were seriously chatty kathy while I was gone.

"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

rodjkidd SSCoach Points: 15916 More actions · Answer 11

Grant Fritchey (6/23/2015)
Wow, you guys were seriously chatty kathy while I was gone.

Welcome back oh mighty one!

Did you have fun, by any chance? hehe

Rodders...

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

So I know it's dirty pool to promote one's own blog on the forums, but in this case, I absolutely MUST show off.

Click it and you'll see why.

Your stress reduction for the day. And you are welcome.

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.

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

Brandie Tarvin (6/23/2015)
So I know it's dirty pool to promote one's own blog on the forums, but in this case, I absolutely MUST show off.
Click it and you'll see why.
Your stress reduction for the day. And you are welcome.

I don't think its a bad thing at the water cooler. 😉 Unfortunately I will have to look at this from home...netnanny won't let me view it.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

rodjkidd (6/23/2015)
Grant Fritchey (6/23/2015)
Wow, you guys were seriously chatty kathy while I was gone.
Welcome back oh mighty one!
Did you have fun, by any chance? hehe
Rodders...

Nope. No fun at all. Especially no fun while hanging out with Jason. He & I don't get along even a little bit.

"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

rodjkidd SSCoach Points: 15916 More actions · Answer 15

Grant Fritchey (6/23/2015)
rodjkidd (6/23/2015)
Grant Fritchey (6/23/2015)
Wow, you guys were seriously chatty kathy while I was gone.
Welcome back oh mighty one!
Did you have fun, by any chance? hehe
Rodders...
Nope. No fun at all. Especially no fun while hanging out with Jason. He & I don't get along even a little bit.

Oh well that's alright then, would hated it if you had fun 😉

Rodders...