Viewing 15 posts - 35,386 through 35,400 (of 49,552 total)
Alvin Ramard (12/9/2009)
Lynn Pettis (12/9/2009)
Anyone see the spoon? 😛Someone needs feeding? 😀
Our friend of the vague questions.
December 9, 2009 at 10:30 am
CirquedeSQLeil (12/9/2009)
My favorite is the
exec sp_configure 'You come do it for me',1Reconfigure
Potentially a very expensive setting. In terms of money, not server performance. 🙂
December 9, 2009 at 9:56 am
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 links...
December 9, 2009 at 9:54 am
Only when you run the query that references the view.
December 9, 2009 at 9:40 am
I'd watch out for the AI mode personally. It's pretty experimental and who knows what will happen if you give your server autonomy.
December 9, 2009 at 9:31 am
Page verify checksum.
Pro: If the IO subsystem messes up and corrupts a SQL page, any read of that page will pick it up immediately. Since the checksum is the...
December 9, 2009 at 9:24 am
You have noticed that you're answering a 3 year old thread?
December 9, 2009 at 9:11 am
Views don't store results. They're simply saved select statements that SQL unrolls into the query when they are referenced.
TempDB is used for Temp tables, table variables, internal work tables (resulting...
December 9, 2009 at 9:04 am
Krasavita (12/9/2009)
It is a lock page setting in memory,
If you mean the "Lock pages in memory" local security policy setting, then these may be of use
http://msdn.microsoft.com/en-us/library/ms187499.aspx
http://msdn.microsoft.com/en-us/library/aa198229%28SQL.80%29.aspx
If I turn on, it...
December 9, 2009 at 9:01 am
Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
exec sp_configure 'Run SQL Faster',1
I've actually given that to...
December 9, 2009 at 9:00 am
Grant Fritchey (12/9/2009)
Locking pages is pretty normal for a SQL Server system. It's part of how it maintains data integrity.
Hmm, I interpreted this as the security setting 'Lock pages...
December 9, 2009 at 7:43 am
Grant Fritchey (12/9/2009)
Bru Medishetty (12/8/2009)
Lynn Pettis (12/8/2009)
December 9, 2009 at 6:43 am
Anyone's telepathy working well at the moment? http://www.sqlservercentral.com/Forums/Topic830993-5-1.aspx
December 9, 2009 at 6:31 am
steveb. (12/9/2009)
December 9, 2009 at 6:06 am
Why do you want to avoid having it? Your questions are very vague. What is the problem?
December 9, 2009 at 6:04 am
Viewing 15 posts - 35,386 through 35,400 (of 49,552 total)