Viewing 15 posts - 36,826 through 36,840 (of 49,552 total)
/PAE and /3GB in boot.ini, AWE is a SQL setting, check sp_configure.
In your situation, I would suggest /3GB to be in boot.ini, /PAE not to be there and AWE 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
August 26, 2009 at 1:22 am
Amit Singh (8/25/2009)
JonJon (8/25/2009)
I have about 3.75GB of memory.I dont think PAE and AWE need to be enabled ... or What am i thinking :doze:
If neither of them is...
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
August 25, 2009 at 3:53 pm
JonJon (8/25/2009)
Sql 2000, 32 bit.
Is either /3GB or /PAE set in boot.ini? Is AWE enabled?
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
August 25, 2009 at 3:29 pm
Post the revised query?
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
August 25, 2009 at 8:02 am
In SQL, only one table may follow the UPDATE keyword.
Take a look at Books Online for the UPDATE .. FROM syntax. Access doesn't have that form of the update statement.
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
August 25, 2009 at 8:01 am
villersk (8/25/2009)
I've seen the query optimiser make some seriously bad decisions....I don't think this one is soo bad.
It can, in most cases that's due to badly written queries or...
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
August 25, 2009 at 7:43 am
http://msdn.microsoft.com/en-us/library/ms188929.aspx
BEGIN TRANSACTION
Arguments
transaction_name
Is the name assigned to the transaction. transaction_name must conform to the rules for identifiers, but identifiers longer than 32 characters are not allowed. Use...
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
August 25, 2009 at 7:37 am
What I was talking about above is a loop join. 100000 seeks against the dimension table, then all those lookups to the cluster to get the row.
Generally hints are not...
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
August 25, 2009 at 7:26 am
Try removing the quotes from around UserName, both in the order by and the select statement.
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
August 25, 2009 at 7:05 am
Moved here: http://www.sqlservercentral.com/Forums/Topic776617-338-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
August 25, 2009 at 7:04 am
villersk (8/25/2009)
What I was driving at, though, is that the merge syntax doesn't seem to allow index hints on the target table.
Did you try using the OPTION clause?
perhaps the scan...
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
August 25, 2009 at 7:00 am
Why do you think the seek will be more efficient? If SQL does a seek on the NC index, it will have to do one seek for each matching value...
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
August 25, 2009 at 6:44 am
kumar99ms (8/25/2009)
Is it possible to delete T-log file what happed ?
Sure it's possible, just not while the DB is in use. Doing so is asking for a damaged and...
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
August 25, 2009 at 6:39 am
Read my previous post.
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
August 25, 2009 at 6:37 am
Dave Ballantyne (8/25/2009)
Hope there should of been a question mark after that Gail 🙂
Perhaps, as I cannot state for certain, but that's what it looks like. At attempt to obscure...
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
August 25, 2009 at 6:31 am
Viewing 15 posts - 36,826 through 36,840 (of 49,552 total)