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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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. 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 9:54 am
Only when you run the query that references the view.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 9:24 am
You have noticed that you're answering a 3 year old thread?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 7:43 am
Grant Fritchey (12/9/2009)
Bru Medishetty (12/8/2009)
Lynn Pettis (12/8/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 6:43 am
Anyone's telepathy working well at the moment? http://www.sqlservercentral.com/Forums/Topic830993-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 6:31 am
steveb. (12/9/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 6:06 am
Why do you want to avoid having it? Your questions are very vague. What is the problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2009 at 6:04 am
Viewing 15 posts - 35,386 through 35,400 (of 49,552 total)