September 14, 2016 at 6:19 am
jasona.work (9/14/2016)
GilaMonster (9/14/2016)
ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
π
The questions are certainly very odd. A manager who knows FA about SQL Server wants some information, and has asked someone else who also knows FA (but slightly more than the manager) to collect it.
My bet's on 'performance problem and flailing around'
Almost smells like a "let's find the stuff that doesn't seem to be used and drop / delete it" sort of question...
Or is that my cynicism showing through again?
I'd put five bucks on both. That's why I asked the feller the question. If he tells us what he's planning to do with the information then folks can maybe nudge him towards better-focussed questions.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 14, 2016 at 6:32 am
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.
Heh - it sounds like you have a fun conversation scheduled for today. π
September 14, 2016 at 6:36 am
Hugo Kornelis (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
π
After reviewing all other contributions of the poster to the forum, I tried my hand at a reply.
99% chance that I will either (a) not get any response or, (b) get a polite and meanningless "thank you", or (c) get a reply that roughly translates into an insult. Only 1% chance that they'll actually act on my recommendation and than, after a few days, get back to me with a follow up question that actually shows that effort has been put in.
Hugo, I thought you gave it a legitimate shot. I hope your predictions are wrong, but I fear they're right. π
Like others, I'm curious what prompted the question.
September 14, 2016 at 6:46 am
ChrisM@Work (9/14/2016)
--
That's why I asked the feller the question
--
I think you meant 'fella', rather than 'lumberjack'. Then again ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 14, 2016 at 6:55 am
Phil Parkin (9/14/2016)
ChrisM@Work (9/14/2016)
--
That's why I asked the feller the question
--
I think you meant 'fella', rather than 'lumberjack'. Then again ...
Most people in the office are in a meeting. Just as well as I just laughed out loud at that :w00t:
Rodders...
September 14, 2016 at 6:56 am
Phil Parkin (9/14/2016)
ChrisM@Work (9/14/2016)
--
That's why I asked the feller the question
--
I think you meant 'fella', rather than 'lumberjack'. Then again ...
For the OP, there's this: "non-standard spelling of fellow, used in representing speech in various dialects."
For your dear readers Phil, there's the entry in Urban Dictionary π
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 14, 2016 at 6:57 am
Ed Wagner (9/14/2016)
Hugo Kornelis (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
π
After reviewing all other contributions of the poster to the forum, I tried my hand at a reply.
99% chance that I will either (a) not get any response or, (b) get a polite and meanningless "thank you", or (c) get a reply that roughly translates into an insult. Only 1% chance that they'll actually act on my recommendation and than, after a few days, get back to me with a follow up question that actually shows that effort has been put in.
Hugo, I thought you gave it a legitimate shot. I hope your predictions are wrong, but I fear they're right. π
Like others, I'm curious what prompted the question.
Additionally, I think he would have posted this question in multiple forums and he is probably looking for a quick solution from somewhere.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 14, 2016 at 7:08 am
Ed Wagner (9/14/2016)
Hugo Kornelis (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
π
After reviewing all other contributions of the poster to the forum, I tried my hand at a reply.
99% chance that I will either (a) not get any response or, (b) get a polite and meanningless "thank you", or (c) get a reply that roughly translates into an insult. Only 1% chance that they'll actually act on my recommendation and than, after a few days, get back to me with a follow up question that actually shows that effort has been put in.
Hugo, I thought you gave it a legitimate shot. I hope your predictions are wrong, but I fear they're right. π
Like others, I'm curious what prompted the question.
Okay, so he is neither in the 99% nor in the 1% category.
He did get back with what appears to be an effort and a starting query ... but it's not really. It's just a quick google search + copy/paste.
I've responded but it'll probably be my last contrribution to that thread. Life is too short to waste energy on freeloaders.
September 14, 2016 at 7:13 am
Can someone familiar with SQL to SQL linked servers help out please
http://www.sqlservercentral.com/Forums/Topic1817509-2799-1.aspx
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
September 14, 2016 at 8:33 am
Sean Lange (9/6/2016)
Ed Wagner (9/6/2016)
Sean Lange (9/6/2016)
ChrisM@Work (9/6/2016)
Sean Lange (9/6/2016)
Luis Cazares (9/6/2016)
Sean Lange (9/6/2016)
I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday. I was able to slice it up and try it for the first time on Sunday. Overall a pretty good first attempt. There are some things I will tweak in my process to see if I can improve the quality. Here is a picture so you can see the fruits of my effort over the last week.I hate when you guys post these pictures without sending some food to actually taste it. π
The idea is to convince some of you to come to KC. Then we can sample all you like. π
Visiting friends in Miami next summer - how far is KC? - I know...that's a little like an American tourist in London asking for a cab to Edinburgh π
LOL it is probably more like a tourist in London trying to catch a cab to Sicily. It is right around 1,500 miles to KC from Miami. London to Edinburgh isn't even as far as the state of Florida. :w00t::w00t::w00t:
Yeah, there's a bit of a difference in distances. I've driven from Michigan to Florida several times and it is a bit of a haul.
Florida gets crazy-hot in the summer. Then again, that's coming from someone who lives in Michigan. π
For you I would guess the definition of "hot" is when the temperature at 3pm in August is consistently more than 50C. π It does get hot in Florida but far worse than the heat is the humidity. It makes it hard to breath sometimes because it is so overwhelming.
Preach it, my friend!
September 14, 2016 at 8:46 am
Lynn Pettis (9/13/2016)
drew.allen (9/13/2016)
I think someone is in way over their head. Maybe we should just tell him to find another line of work.Drew
Who?
This is his most recent question: http://www.sqlservercentral.com/Forums/Topic1817408-3077-1.aspx, but he seemed to be having problems with the concepts in this earlier thread, which make me believe that he certainly doesn't have the background for the solving the newest question. http://www.sqlservercentral.com/Forums/Topic1812194-3077-2.aspx#bm1812554
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 14, 2016 at 10:20 am
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. π
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
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
September 14, 2016 at 10:44 am
SQLRNNR (9/14/2016)
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. π
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
And this is the point where I would put a scrubbed copy of a production db down in a dev environment, restore on a daily or weekly basis (depending on the frequency of schema changes) and say "Here you go. Have fun on this sandbox server. Don't call me when you break it."
He'd get his sysadmin, but no prod, and I'd get to test my db backups. @=)
September 14, 2016 at 11:16 am
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. π
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
And this is the point where I would put a scrubbed copy of a production db down in a dev environment, restore on a daily or weekly basis (depending on the frequency of schema changes) and say "Here you go. Have fun on this sandbox server. Don't call me when you break it."
He'd get his sysadmin, but no prod, and I'd get to test my db backups. @=)
Oh it gets prettier - he created the prod box and is trying to box everybody else out. He deployed it without anybody knowing and is transitioning services to it.
Yup - that bad.
The awakening is coming.
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
September 14, 2016 at 11:26 am
SQLRNNR (9/14/2016)
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. π
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
And this is the point where I would put a scrubbed copy of a production db down in a dev environment, restore on a daily or weekly basis (depending on the frequency of schema changes) and say "Here you go. Have fun on this sandbox server. Don't call me when you break it."
He'd get his sysadmin, but no prod, and I'd get to test my db backups. @=)
Oh it gets prettier - he created the prod box and is trying to box everybody else out. He deployed it without anybody knowing and is transitioning services to it.
Yup - that bad.
The awakening is coming.
Can his box be blocked via AD from network?
Viewing 15 posts - 55,801 through 55,815 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply