Viewing 15 posts - 5,041 through 5,055 (of 6,679 total)
Is AWE enabled - with the /PAE switch in the boot.ini also?
June 3, 2009 at 1:24 pm
mathieu_cupryk (6/3/2009)
I get an error of ticketID 0?
Sorry - no idea what that means.
June 3, 2009 at 1:22 pm
Because the transaction log needs 140MB at some point in time to handle the transactions that occur between your transaction log backups.
June 3, 2009 at 1:21 pm
I have no idea what you are missing - or, what kind of error you are getting, or what problem you are trying to solve.
It would probably help if you...
June 3, 2009 at 1:16 pm
You are welcome - glad I could help.
June 3, 2009 at 9:22 am
Dave Ballantyne (6/3/2009)
Can you post a full XML query plan of one of your queries that Seek ?.
If you could try to make the query as simple as...
June 3, 2009 at 9:20 am
Nope - SQL Server 2005 SP3 and had the same experience on 2005 SP2 CU7.
June 2, 2009 at 5:35 pm
TheSQLGuru (6/2/2009)Perhaps because they found that their poorly written code (IS NULL OR constructs) required it to perform acceptably?!? :hehe:
Still not sure about that being the issue though. ...
June 2, 2009 at 3:54 pm
Once SQL Server has the memory, it won't necessarily give it back just because you changed the setting. You may need to restart the service before it releases the...
June 2, 2009 at 2:44 pm
samir momani (6/2/2009)
Do you mean to set the Max memory in the properities of the SQL server to lets say 1047483647 ? or let say...
June 2, 2009 at 2:18 pm
TheSQLGuru (6/2/2009)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/068282b7-c419-4e2c-990a-1f8b7c12762f.htm
I do have a client...
June 2, 2009 at 2:16 pm
samir momani (6/2/2009)
It is MS SQL Server 2008 Standard edition, and the memory setting is as defult i.e :Minimum server memory (in MB) = 0 and Maximum server memory2147483647
On x64...
June 2, 2009 at 1:24 pm
TheSQLGuru (6/2/2009)Maybe with that many rows the optimizer is simply hoping it "gets lucky" and the seek/lookup plan is less costly that the massive cost of a table scan! ...
June 2, 2009 at 1:22 pm
The Itaniums are also 64-bit and have the same issues as the x64 models. If you have set the max memory, have you cycled SQL Server? If yes,...
June 2, 2009 at 12:57 pm
Gail, I really don't want to argue this point - but I am having a small problem here. I have a query where I use this construct and include...
June 2, 2009 at 10:58 am
Viewing 15 posts - 5,041 through 5,055 (of 6,679 total)