mrdenny

Start by looking at the execution plan at the output from SET STATISTICS IO ON and see what the outputs are. Odds are the statistics are out of date on the production server and need to be updated, but the execution plan and the output from SET STATISTICS IO ON should tell you what's going on.

Sounds like the source database is corrupt. Has anyone run DBCC CHRCKDB against the source server?

There are so many things that could be causing this problem. Are you using dynamic SQL within the application? Are you ever doing index maintenance? Do you ever update the statistics? What jobs are scheduled in SQL Agent? What does the output from sp_whoisactive show (a screenshot would be nice)?

@RebeccaChernoff thanks for modding the chat.

@Nick oh, we are going that route? "Databases are for little girls. Real men use perl for data access"

Vote for who you think will do a good job on the site. That's the most important thing about these elections.

@JackDouglas it's a scripting language <ducks>

@jcolebrand No I don't. I think there's some guidelines that the other sites have, but I don't think hard and fast rules would help anyone.

@Lazer There's a whole thread on "is PoSH a scripting language" on Twitter, again. SQLVariant is defending his baby again.

@jcolebrand cheater.

@jcolebrand "it depends". If they relate to working with PoSH and the database engine for managing a large enterprise, sure. If it's a PoSH in general question then it should be kicked to SF or possible SO.

@RebeccaChernoff start with a comment, then an email with some consequences. If a helpful users just wants to pick fights there are other sites they can be a PITA on.

@Nick Lack of users and questions being spread over SF and SO that could/should be on DBA.SE.

@Nick The only real kind of question that I've seen recently that I don't like (saw this most recently on SF) is the "opening this question to be the catch all for this type of question" questions. There are always different angels that need to be explored and these catch all questions just don't work. The one that comes to mind was about software licensing. People wanted to close it as duplicate because there was a generic catch all question that didn't answer the specific question asked.

@RebeccaChernoff There's all the normal stuff of talking to the new users getting them to actually provide the information needed to get their question answered, even if it isn't a question that I'm going to be able to answer.

@RebeccaChernoff I'm sure I've got examples from over on ServerFault, but I can't think of any because I don't really remember that stuff. Just sort of do as needed and move on.

@RebeccaChernoff I've got the time to help keep the questions on point, and I like giving back to the community when I can.

@Lazer I'd prefer a more traditional database icon as a logo, but I think that as is it covers all the database platforms including the non-relational platforms. Granted I have no artistic taste what so ever, so you should probably just ignore me on this one.

@random Generally I like to let the community take care of the bulk of the closes. Especially is something is borderline, just because I don't want my will to overly influence. If there's something totally obvious I'll move it / blow it away without anyone else having ever voted on it. This is especially important on a younger site as not very many people had the vote to close right yet.

@Nick I'm ok with the site's name. I think that it keeps the focus on the set and tuning of the various database platforms.

@jcolebrand I'd say that a spammer is someone who is simply using the site to advertise their product or service in every answer they make. The community is usually pretty good and pointing them out pretty quickly (at least from what I see on ServerFault).

Hey everyone, sorry I'm late.