June 7, 2017 at 1:02 pm
Eric M Russell - Wednesday, June 7, 2017 12:56 PMSo, it's more like that secret spot under the ball field bleachers where the cool kids hangout?
More like that particular lunch table where you know you can always have a good D&D discussion. Although my preferred RPG in high school was Traveler.
"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
June 7, 2017 at 1:06 pm
Grant Fritchey - Wednesday, June 7, 2017 1:02 PMEric M Russell - Wednesday, June 7, 2017 12:56 PMSo, it's more like that secret spot under the ball field bleachers where the cool kids hangout?More like that particular lunch table where you know you can always have a good D&D discussion. Although my preferred RPG in high school was Traveler.
Or a discussion about great movies, music, food or just about anything else. Not many tech discussions, though.
June 7, 2017 at 1:17 pm
Lynn Pettis - Wednesday, June 7, 2017 12:32 PMGilaMonster - Wednesday, June 7, 2017 11:54 AMGilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tablesheaddesk
Gave an Obi Wan answer.
Everyone should just stop piling up more ideas on how to solve what might or mihgt not be his problem, until he accepts that he needs to get back to the users to find what the actual requirement is. *Than* we can start offering actually useful help.
June 7, 2017 at 1:45 pm
Hugo Kornelis - Wednesday, June 7, 2017 1:17 PMLynn Pettis - Wednesday, June 7, 2017 12:32 PMGilaMonster - Wednesday, June 7, 2017 11:54 AMGilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tablesheaddesk
Gave an Obi Wan answer.
Everyone should just stop piling up more ideas on how to solve what might or mihgt not be his problem, until he accepts that he needs to get back to the users to find what the actual requirement is. *Than* we can start offering actually useful help.
Can I just tell him to establish the answer as 42?
June 7, 2017 at 1:51 pm
Hugo Kornelis - Wednesday, June 7, 2017 1:17 PMLynn Pettis - Wednesday, June 7, 2017 12:32 PMGilaMonster - Wednesday, June 7, 2017 11:54 AMGilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tablesheaddesk
Gave an Obi Wan answer.
Everyone should just stop piling up more ideas on how to solve what might or mihgt not be his problem, until he accepts that he needs to get back to the users to find what the actual requirement is. *Than* we can start offering actually useful help.
Considering his last post essentially admitted that the users are asking for something he knows can't be done, I suspect the real requirement is for him to go back to the users and tell them "Can't be done"
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
June 7, 2017 at 2:04 pm
Lynn Pettis - Wednesday, June 7, 2017 12:32 PMGilaMonster - Wednesday, June 7, 2017 11:54 AMGilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tablesheaddesk
Gave an Obi Wan answer.
I think I preferred Brandie's answer, walk around the office constantly asking which table(s) people are querying.
June 7, 2017 at 2:19 pm
GilaMonster - Wednesday, June 7, 2017 1:51 PMConsidering his last post essentially admitted that the users are asking for something he knows can't be done, I suspect the real requirement is for him to go back to the users and tell them "Can't be done"
Yes. But he's been told that multiple times already and still seeking advice.
My point is that until he starts asking questions that CAN be answers, we should all stop providing answers to what might not even be his actual question.
June 7, 2017 at 2:39 pm
Hugo Kornelis - Wednesday, June 7, 2017 2:19 PMGilaMonster - Wednesday, June 7, 2017 1:51 PMConsidering his last post essentially admitted that the users are asking for something he knows can't be done, I suspect the real requirement is for him to go back to the users and tell them "Can't be done"
Yes. But he's been told that multiple times already and still seeking advice.
My point is that until he starts asking questions that CAN be answers, we should all stop providing answers to what might not even be his actual question.
Indeed, which is why I emphasized that he really needed to work with the client to clarify the the request and its purpose.
At the same time, since it's not all that unusual for people not to know enough about the subject matter to formulate a precise request (or in his case, to communicate to his client what is and isn't available for table-level activity metrics), I figured it was worth just showing an example of something that can be a rough proxy for per-table activity.
I guess it was a combination of his having said enough to indicate that it was some measure of per-table activity that was desired and the impression that he just didn't know enough to formulate the request precisely that led me to think an example was in order. At any rate, he definitely has enough suggestions now that he should be able to get either something meaningful or an "Ah, never mind then." from the client.
Cheers!
June 7, 2017 at 9:40 pm
Grant Fritchey - Wednesday, June 7, 2017 1:02 PMEric M Russell - Wednesday, June 7, 2017 12:56 PMSo, it's more like that secret spot under the ball field bleachers where the cool kids hangout?More like that particular lunch table where you know you can always have a good D&D discussion. Although my preferred RPG in high school was Traveler.
Played both, still have my Traveler Books as well as my D&D books.
June 8, 2017 at 7:24 am
I played some occasional D&D in high school, but mostly I enjoyed drawing grid maps and designing campaigns for other players. The same gene that causes Minecraft addiction today; back in the 1980s it expressed itself as an obsession with D&D.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2017 at 7:32 am
jasona.work - Wednesday, June 7, 2017 2:04 PMLynn Pettis - Wednesday, June 7, 2017 12:32 PMGilaMonster - Wednesday, June 7, 2017 11:54 AMGilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tablesheaddesk
Gave an Obi Wan answer.
I think I preferred Brandie's answer, walk around the office constantly asking which table(s) people are querying.
That was the only thing I could think of that would fit the customer's requirements. And maybe teach them a lesson about "watch what you wish for".
June 8, 2017 at 7:37 am
Luis Cazares - Wednesday, June 7, 2017 12:30 PMBrandie Tarvin - Wednesday, June 7, 2017 12:05 PMYou know what I just realized I want on this forum?A way to tag individual posts. Not a thread, posts within the thread. For instance, there are several "discussions" in this particular thread where I want to tag things like book recommendations or recipes. And because I can't add a post to the briefcase, I have to search and search and search and hope I get close to the right pages to find it.
Of course, if there's a way to do it and I'm just clueless today, I would love for someone to point me in the correct direction of how to do so.
Have you tried saving the post links in bookmarks?
As in browser book marks? Bah. There's a lot of work in that. The way I read through this thread is I rarely read one post at a time. Usually I delete all email notifications except the earliest unread one, then click on that when I'm free and read through the accumulated posts. Adding browser bookmarks would require me to, you know, proactively do work to get the unique post linked in the bookmark instead of the entire page.
I'd rather have a button here in SCS that I can push. Because I am lazy that way.
June 8, 2017 at 9:43 am
Brandie Tarvin - Thursday, June 8, 2017 7:37 AMAs in browser book marks? Bah. There's a lot of work in that. The way I read through this thread is I rarely read one post at a time. Usually I delete all email notifications except the earliest unread one, then click on that when I'm free and read through the accumulated posts. Adding browser bookmarks would require me to, you know, proactively do work to get the unique post linked in the bookmark instead of the entire page.
I'd rather have a button here in SCS that I can push. Because I am lazy that way.
Maybe one day. I'm thinking of trying to take back some development of SSC and get small things like this done. Likely not for months as my schedule is jammed through Oct, but maybe end of year.
June 8, 2017 at 9:59 am
Steve Jones - SSC Editor - Thursday, June 8, 2017 9:43 AMBrandie Tarvin - Thursday, June 8, 2017 7:37 AMAs in browser book marks? Bah. There's a lot of work in that. The way I read through this thread is I rarely read one post at a time. Usually I delete all email notifications except the earliest unread one, then click on that when I'm free and read through the accumulated posts. Adding browser bookmarks would require me to, you know, proactively do work to get the unique post linked in the bookmark instead of the entire page.
I'd rather have a button here in SCS that I can push. Because I am lazy that way.
Maybe one day. I'm thinking of trying to take back some development of SSC and get small things like this done. Likely not for months as my schedule is jammed through Oct, but maybe end of year.
Something to do in those long winter evenings when the horses are hibernating? 😀
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 8, 2017 at 10:11 am
ThomasRushton - Thursday, June 8, 2017 9:59 AMSomething to do in those long winter evenings when the horses are hibernating? 😀
There is no hibernating. Winters suck with lots of snow. The help can't come, so guess who gets to help feed?
Viewing 15 posts - 58,861 through 58,875 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply