Viewing 15 posts - 16,081 through 16,095 (of 22,219 total)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
"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
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...
"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
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.
"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
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...
"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
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?
"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
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....
"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
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...
"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
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...
"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
December 9, 2009 at 6:21 am
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 promise less than nothing, but I'll check my schedule and see what might already be in the...
"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
December 8, 2009 at 2:25 pm
Alvin Ramard (12/7/2009)
Grant Fritchey (12/7/2009)
Grant, don't you know the difference between a chipmunk and a mouse?
I'm up high in the tree anyway. They'd have to catch me first!!!!!
:hehe:
Sorry, all you...
"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
December 7, 2009 at 1:13 pm
Grant, don't you know the difference between a chipmunk and a mouse?
I'm up high in the tree anyway. They'd have to catch me first!!!!!
:hehe:
Sorry, all you rodents look alike to...
"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
December 7, 2009 at 12:54 pm
Number 6 (12/7/2009)
At least he put it in the Hardware section of the Forums....
They're talking about fixing mice, what are you doing here Alvin? Run! Run!
"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
December 7, 2009 at 11:24 am
shannonjk (12/7/2009)
Thanks Grant 🙂I know how to use sp_executesql and pass parameters through that. My only issue is getting around the character limit for my more robust queries 🙂
Assuming 2005/2008,...
"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
December 7, 2009 at 11:13 am
CirquedeSQLeil (12/7/2009)
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
Maybe just a...
"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
December 7, 2009 at 9:25 am
Number 6 (12/7/2009)
I'm not a number, I'm a free man !!!
Ah, good man. You went with McGoohan and not that new guy.
"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
December 7, 2009 at 9:24 am
Viewing 15 posts - 16,081 through 16,095 (of 22,219 total)