Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,861 through 55,875 (of 66,712 total)

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

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

ChrisM@Work (9/19/2016)
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?
😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂

My compliments on the way you handled it. Maybe an alternative identity for SS.

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

David Burrows SSC Guru Points: 65142 More actions · Answer 2

Ed Wagner (9/19/2016)
ChrisM@Work (9/19/2016)
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?
😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂
My compliments on the way you handled it. Maybe an alternative identity for SS.

+1

My solution would involve joining the table to itself but since the OP said it was a huge table I refrained as the performance would be horrendous.

So I will defer to the experts 😀

Far away is close at hand in the images of elsewhere.
Anon.

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

I HAVE THE POWER!!!!

Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix"). I'm not sure if this is a good thing or a bad thing. 😀

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.

rodjkidd SSCoach Points: 15916 More actions · Answer 4

Brandie Tarvin (9/19/2016)
I HAVE THE POWER!!!!
Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix"). I'm not sure if this is a good thing or a bad thing. 😀

In my experience its a bad thing... You have to own tickets and update them! 😉

Rodders...

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

rodjkidd (9/19/2016)
Brandie Tarvin (9/19/2016)
I HAVE THE POWER!!!!
Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix"). I'm not sure if this is a good thing or a bad thing. 😀
In my experience its a bad thing... You have to own tickets and update them! 😉
Rodders...

This. I've managed to avoid the change control processes at this current contract... so far...

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 6

David Burrows (9/19/2016)
Ed Wagner (9/19/2016)
ChrisM@Work (9/19/2016)
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?
😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂
My compliments on the way you handled it. Maybe an alternative identity for SS.
+1
My solution would involve joining the table to itself but since the OP said it was a huge table I refrained as the performance would be horrendous.
So I will defer to the experts 😀

Your solution David sounds like the perfect penalty for the perpetrator 😀

😎

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

Eirikur Eiriksson (9/19/2016)
David Burrows (9/19/2016)
Ed Wagner (9/19/2016)
ChrisM@Work (9/19/2016)
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?
😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂
My compliments on the way you handled it. Maybe an alternative identity for SS.
+1
My solution would involve joining the table to itself but since the OP said it was a huge table I refrained as the performance would be horrendous.
So I will defer to the experts 😀
Your solution David sounds like the perfect penalty for the perpetrator 😀
😎

Actually this system sends the tickets to the next person in the chain automatically. It's an SDLC ticket system. For every software change or data change that needs done, there is an approval process, a requirements process, a testing process, etc. all built into the system. So it doesn't go to me unless I'm the programmer or the tester.

Unfortunately it will mean people asking me to create these tickets if they find out I have this power...

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

And THIS[/url], folks, is why backups are important.

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.

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 9

Brandie Tarvin (9/19/2016)
And THIS[/url], folks, is why backups are important.

http://www.sqlservercentral.com/articles/Editorial/146482/

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

Steve Jones - SSC Editor (9/19/2016)
Brandie Tarvin (9/19/2016)
And THIS[/url], folks, is why backups are important.
http://www.sqlservercentral.com/articles/Editorial/146482/

Whoops. Yeah. I haven't read my newsletter yet today.

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.

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 11

Hi all,

I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has any particularly complex examples or problems to share?

😎

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

Eirikur Eiriksson (9/19/2016)
Hi all,
I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has any particularly complex examples or problems to share?
😎

We use the XML data type to store history for a few critical tables. There are triggers on the tables that fire when an update is done, copying the data over to a logging table that has 3 columns. An id column for the table, the trigger datetime, and the XML data type which contains all the source table's columns for the updated record.

We do this because our users come back to us complaining that data mysteriously got changed and none of them did it, so the system has to be messed up. At which point, we have to query those log tables and find the record in question, the tell the users exactly who did the update (because yes, that gets logged as part of the table information). This has actually stopped the IT Screwed It Up! blame game since we can now point to the exact user who did the dirty deed. Sometimes it's just someone who needs training on proper updates. Mostly it's a user trying to throw us under the bus for a bad decision they don't remember.

Does this help you with your article?

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.

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

Brandie Tarvin (9/19/2016)
Actually this system sends the tickets to the next person in the chain automatically. It's an SDLC ticket system. For every software change or data change that needs done, there is an approval process, a requirements process, a testing process, etc. all built into the system. So it doesn't go to me unless I'm the programmer or the tester.
Unfortunately it will mean people asking me to create these tickets if they find out I have this power...

To: AllEmployees@BrandieT.work

Subject: Brandie T can now create tickets

Body: To all employees: Be aware that Brandie can now create tickets in the system. Please feel free to stop by any time you require a ticket, she will also provide free-of-charge snacks and drinks while you give her the details of your ticket.

If she does not provide snacks of which you approve, please inform management immediately so that she can be instructed to obtain appropriate snacks.

Thank you,

Management

:hehe:

I may be just a duck, but I'm an EEVVIILL little duck!

:hehe:

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

jasona.work (9/19/2016)
I may be just a duck, but I'm an EEVVIILL little duck!
:hehe:

It's DUCK HUNTING SEASON!

EDIT: Added URL

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.

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

Brandie Tarvin (9/19/2016)
jasona.work (9/19/2016)
I may be just a duck, but I'm an EEVVIILL little duck!
:hehe:
It's DUCK HUNTING SEASON!
EDIT: Added URL

WABBIT SEASON!