August 1, 2017 at 9:41 am
GilaMonster - Tuesday, August 1, 2017 6:41 AMI think a small black hole might improve the system that Grant's ranting about.
I'd say a large magnet might help them (move on)
August 1, 2017 at 9:51 am
Brandie Tarvin - Tuesday, August 1, 2017 9:33 AMSo you've been in my office this morning, have you?Everyone's mad that I started kicking people out of the reporting databases this morning because stuff hadn't finished. Now they want to know when it'll finish and they don't seem to understand that it'll be done faster if they stop querying against the database that's trying to update itself while it's doing the updates... Sigh.
I do wonder if on days like that it'll just be easier to blanket DENY everyone access to objects on the database (or disable the users) apart from the user that is building the data. At least then they can't slow it down (as much) by running queries that will more than likely be wrong anyway.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 10:02 am
You know, I didn't think about disabling the users... I should consider that for the next time.
August 1, 2017 at 10:08 am
So, the end of this month the wife and I are going to a Science Fiction / Fantasy / Comic Book / Anime convention. One of the guests is going to be Famke Jannsen (she played Jean Grey in the first 3 X-Men movies, Xenia Onatopp in GoldenEye, and a few others.) I'm thinking of taking along a movie she was in for an autograph, but I'm thinking not one of her better known roles...
No, I'm thinking instead of taking along Deep Rising...
http://www.imdb.com/title/tt0118956
Mostly because I'm weird like that, and partly because frankly, it's a fun movie. And, partly because I'm hoping to get a reaction along the lines of "oh god, someone remembered I was in that!"
August 1, 2017 at 10:14 am
jasona.work - Tuesday, August 1, 2017 10:08 AMSo, the end of this month the wife and I are going to a Science Fiction / Fantasy / Comic Book / Anime convention. One of the guests is going to be Famke Jannsen (she played Jean Grey in the first 3 X-Men movies, Xenia Onatopp in GoldenEye, and a few others.) I'm thinking of taking along a movie she was in for an autograph, but I'm thinking not one of her better known roles...No, I'm thinking instead of taking along Deep Rising...
http://www.imdb.com/title/tt0118956
Mostly because I'm weird like that, and partly because frankly, it's a fun movie. And, partly because I'm hoping to get a reaction along the lines of "oh god, someone remembered I was in that!"
Hope the queue isn't too long! I remember some friends queuing for 4 or 5 hours for Vic Mignogna's autograph an a convention. >_<
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 10:20 am
Thom A - Tuesday, August 1, 2017 10:14 AMjasona.work - Tuesday, August 1, 2017 10:08 AMSo, the end of this month the wife and I are going to a Science Fiction / Fantasy / Comic Book / Anime convention. One of the guests is going to be Famke Jannsen (she played Jean Grey in the first 3 X-Men movies, Xenia Onatopp in GoldenEye, and a few others.) I'm thinking of taking along a movie she was in for an autograph, but I'm thinking not one of her better known roles...No, I'm thinking instead of taking along Deep Rising...
http://www.imdb.com/title/tt0118956
Mostly because I'm weird like that, and partly because frankly, it's a fun movie. And, partly because I'm hoping to get a reaction along the lines of "oh god, someone remembered I was in that!"Hope the queue isn't too long! I remember some friends queuing for 4 or 5 hours for Vic Mignogna's autograph an a convention. >_<
When we went last year, I think we spent maybe an hour in line for John Barrowman. That includes the time it took for him to serenade a woman dressed up as the Queen of England and get everyone in line to form up behind them for a selfie.
August 1, 2017 at 11:02 am
Brandie Tarvin - Tuesday, August 1, 2017 10:02 AMYou know, I didn't think about disabling the users... I should consider that for the next time.
I lean towards disabling items when I'm unsure of impact or need. I'd pre-write the "enable" scripts so I could get them going quickly if needed.
August 1, 2017 at 11:27 am
Steve Jones - SSC Editor - Tuesday, August 1, 2017 11:02 AMBrandie Tarvin - Tuesday, August 1, 2017 10:02 AMYou know, I didn't think about disabling the users... I should consider that for the next time.I lean towards disabling items when I'm unsure of impact or need. I'd pre-write the "enable" scripts so I could get them going quickly if needed.
I talked to the manager of the team in question. He's going to draw up a list of SLAs and expectations so we can have a more constructive discussion after month end.
I love this guy. He's great at understanding that our problems are his problems because he knows we treat his problems as our problems. Cooperation, yay!
August 1, 2017 at 12:38 pm
Grant Fritchey - Tuesday, August 1, 2017 7:09 AMI expanded this into a full blog post. Comes out a little after 10. Yes, DBCC TIMEWARP is mentioned, but no, it's not the "Run Really Fast" button.
I suspect that "run really fast button" is the short form of the name. It's really the "maybe run really fast and probably deliver incorrect results and corrupt your database" button.
Tom
August 1, 2017 at 12:44 pm
TomThomson - Tuesday, August 1, 2017 12:38 PMGrant Fritchey - Tuesday, August 1, 2017 7:09 AMI expanded this into a full blog post. Comes out a little after 10. Yes, DBCC TIMEWARP is mentioned, but no, it's not the "Run Really Fast" button.I suspect that "run really fast button" is the short form of the name. It's really the "maybe run really fast and probably deliver incorrect results and corrupt your database" button.
So the short, short, short version would be "WITH NOLOCK"?
August 1, 2017 at 1:08 pm
So our person who is the lead person on the help desk is helping with some testing of one of our websites. This person ran into an issue with a page. I asked them for a link and they sent me a screenshot of the address bar. Since this is a CMS the links are user friendly but can get quite lengthy and extremely difficult to type. Shouldn't somebody running the help desk understand what a link is from a website?
_______________________________________________________________
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/
August 1, 2017 at 2:00 pm
Sean Lange - Tuesday, August 1, 2017 1:08 PMSo our person who is the lead person on the help desk is helping with some testing of one of our websites. This person ran into an issue with a page. I asked them for a link and they sent me a screenshot of the address bar. Since this is a CMS the links are user friendly but can get quite lengthy and extremely difficult to type. Shouldn't somebody running the help desk understand what a link is from a website?
I would hope so, but apparently you and I both expect too much. When people at work send me pictures of text instead of the text itself, I kick it back to them and ask for the actual text instead of a picture of it. I then let it go because it isn't worth typing some pile of text and running the risk of fat-fingering something that just isn't necessary.
August 1, 2017 at 2:07 pm
Ed Wagner - Tuesday, August 1, 2017 2:00 PMSean Lange - Tuesday, August 1, 2017 1:08 PMSo our person who is the lead person on the help desk is helping with some testing of one of our websites. This person ran into an issue with a page. I asked them for a link and they sent me a screenshot of the address bar. Since this is a CMS the links are user friendly but can get quite lengthy and extremely difficult to type. Shouldn't somebody running the help desk understand what a link is from a website?I would hope so, but apparently you and I both expect too much. When people at work send me pictures of text instead of the text itself, I kick it back to them and ask for the actual text instead of a picture of it. I then let it go because it isn't worth typing some pile of text and running the risk of fat-fingering something that just isn't necessary.
And when I said "Oh I thought you would send me a link instead of screenshot" the response was "well how would I know what kind of link you wanted". Seriously??? I don't know...a link that is actually a link so I don't have to type it, you don't have to take a screenshot and makes it easy for...well...anybody who needs this information. Frustrating when the help desk can't tell the different between a cd player and a cup holder. I realize I am asking for a lot but perhaps a person in a technical position could have the very basic concepts of working with technology. Topped it off by sending me a picture and then calling to tell me they sent me an email...which of course hadn't made it to my inbox yet because it had a 4MB screenshot attached to it. :crazy:
_______________________________________________________________
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/
August 1, 2017 at 6:57 pm
jasona.work - Tuesday, August 1, 2017 12:44 PMTomThomson - Tuesday, August 1, 2017 12:38 PMGrant Fritchey - Tuesday, August 1, 2017 7:09 AMI expanded this into a full blog post. Comes out a little after 10. Yes, DBCC TIMEWARP is mentioned, but no, it's not the "Run Really Fast" button.I suspect that "run really fast button" is the short form of the name. It's really the "maybe run really fast and probably deliver incorrect results and corrupt your database" button.
So the short, short, short version would be "WITH NOLOCK"?
Exactly.
Tom
August 2, 2017 at 2:51 am
GilaMonster - Monday, July 31, 2017 5:33 AMCrystal ball to aisle 7 please. Crystal ball to aisle 7.
https://www.sqlservercentral.com/Forums/1889451/Should-I-Redesign-table
Got to give you kudos, your dedication to try and help that user is commendable; I certainly wouldn't have had the patience after the amount of pictures they've supplied. 😎
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 59,506 through 59,520 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply