Viewing 15 posts - 16,066 through 16,080 (of 22,211 total)
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????The force in this one is not only weak, I think it is nonexistant.
Same guy that wanted to...
December 9, 2009 at 11:42 am
I'd say that moving a gb of data in a single query in 3 minutes is decent, if not great, performance. What is the user doing with 2 million rows...
December 9, 2009 at 11:23 am
I'd want to see execution plans to determine that you're reallly looking at two different sets of behavior. Does the connection calling the store procedure have the same ANSI settings...
December 9, 2009 at 11:17 am
I can't think of a single way of doing this either. Most of the DMV's that I can think of that might relate to this only store aggregate information, so...
December 9, 2009 at 11:15 am
GilaMonster (12/9/2009)
Krasavita (12/9/2009)
Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank you
I'm assuming that you didn't bother to read the two...
December 9, 2009 at 10:33 am
I'm honestly trying to help the guy, but man... could you make it more difficult?
December 9, 2009 at 8:46 am
The first thing that comes to mind from what you just posted is the ability to pin a table. This means that the table is pinned into memory to elminate...
December 9, 2009 at 8:45 am
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
December 9, 2009 at 8:26 am
Krasavita (12/9/2009)
I was told there is a switch on sql server that needs to be turn on to increase perfomance on sql server
Again, a lot more specific information needs to...
December 9, 2009 at 8:24 am
Yeah, it was a guess... I didn't have a clue what they were talking about, but... tried to be helpful. Probably wrong.
December 9, 2009 at 8:05 am
Locking pages is pretty normal for a SQL Server system. It's part of how it maintains data integrity. You really need to drill down on what you think your problem...
December 9, 2009 at 7:34 am
GilaMonster (12/9/2009)
Anyone's telepathy working well at the moment? http://www.sqlservercentral.com/Forums/Topic830993-5-1.aspx
Mine's working great.... here, let me try.... I sense, a question... with little or totally vague input...
How'm I doing?
December 9, 2009 at 7:33 am
Very good one. One that I forgot a little too frequently. For whatever reason, there's an almost automatic assumption that when there's an error in an app, it's the database....
December 9, 2009 at 6:55 am
Jack Corbett (12/8/2009)
Bru Medishetty (12/8/2009)
Alvin Ramard (12/8/2009)
Don't be afraid to ask questions here. I'm only 1 of at least 4 leaders that frequent the thread.
Thanks Alvin and appreciate your...
December 9, 2009 at 6:24 am
Bru Medishetty (12/8/2009)
Lynn Pettis (12/8/2009)
Bru Medishetty (12/8/2009)
RBarryYoung (12/8/2009)
Not the usual, but I could use help with this one: http://www.sqlservercentral.com/Forums/Topic830994-1199-1.aspx
I am 80 miles from Philadelphia, need to know the time in...
December 9, 2009 at 6:21 am
Viewing 15 posts - 16,066 through 16,080 (of 22,211 total)