Viewing 15 posts - 19,501 through 19,515 (of 49,552 total)
patrickmcginnis59 (3/28/2012)
GilaMonster (3/28/2012)
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not to get anything...
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
March 28, 2012 at 10:35 am
Yup, that's far more likely to work.
http://sqlinthewild.co.za/index.php/2008/05/20/common-t-sql-mistakes/
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
March 28, 2012 at 9:35 am
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not to get anything of any...
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
March 28, 2012 at 9:09 am
Chapter 1 and 4
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
March 28, 2012 at 9:03 am
sqlpadawan_1 (3/28/2012)
If I make a change and capture the @@ERROR after every SQL statement in the proc, with something like:
IF (@@ERROR <> 0) AND (@ErrorNumber = 0)
BEGIN
...
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
March 28, 2012 at 8:44 am
It'll try, yes. The algorithm's a complex LRU check.
I generally leave SQL's min memory at 0. Monitor, if you see memory allocations keep dropping very, very low then maybe you...
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
March 28, 2012 at 8:41 am
Also note that just because SQL is using 7GB of memory doesn't mean it absolutely has to have 7GB to work. SQL's a memory hog, it will use whatever 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
March 28, 2012 at 8:20 am
I do like locked pages, especially on a dedicated server. I set the max memory carefully, leave the min at 0.
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
March 28, 2012 at 8:04 am
From Books Online
ERROR_NUMBER ( )
When called in a CATCH block, returns the error number of the error message that caused the CATCH block to be run.
Returns NULL if called outside...
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
March 28, 2012 at 7:54 am
Usman Butt (3/28/2012)
Yuri55 (3/28/2012)
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
March 28, 2012 at 7:43 am
No one suffers meaning that SQL has voluntarily reduced its memory usage and manages with less. Compare that to the case where it thinks it still has 7GB of memory...
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
March 28, 2012 at 7:41 am
Charmer (3/28/2012)
GilaMonster (3/28/2012)
Table redesign?you want me to redesign the table?
It's a suggestion. Afterall, you said "the table structure is so stupid so that we are not able to get any...
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
March 28, 2012 at 7:14 am
Yuri55 (3/28/2012)
GilaMonster (3/28/2012)
If SQL's min server memory is lower than the max, the OS will ask SQL to reduce its memory and SQL will do so,...
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
March 28, 2012 at 7:13 am
Table redesign?
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
March 28, 2012 at 5:44 am
Depends on the memory settings.
If SQL's min server memory is lower than the max, the OS will ask SQL to reduce its memory and SQL will do so, down 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
March 28, 2012 at 5:43 am
Viewing 15 posts - 19,501 through 19,515 (of 49,552 total)