Viewing 15 posts - 36,826 through 36,840 (of 49,563 total)
While inserts and updates can cause fragmentation, deletes cannot. Inserts may, or may not cause fragmentation, depending on what the index key is. Updates may cause fragmentation or may not,...
August 26, 2009 at 7:58 am
Rob Goddard (8/26/2009)
Generally the uncompressed backup size will be equivalent to the size of the used portion of the data and log files.
Used portion of data, yes. Used portion...
August 26, 2009 at 7:56 am
kramaswamy (8/26/2009)
Yeah, the execution plans were all identical. So, you're saying that the read-ahead reads are something that could change even if I were to re-run the exact same query?
Correct....
August 26, 2009 at 7:51 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic777318-146-1.aspx
August 26, 2009 at 7:47 am
August 26, 2009 at 7:44 am
Dave Ballantyne (8/26/2009)
dont attempt to compare relative performance of queries with doing it.
Well....... depends.
Personally, I never use it when comparing queries.
August 26, 2009 at 7:42 am
Need execution plans to say anything useful here.
What's the output of STATISTICS IO and STATISTICS TIME for the query with the unique index and the one without?
August 26, 2009 at 7:40 am
It's the logical IOs that you need to compare to see which does the most work. Read-ahead reads means that some of the required pages were not in memory (maybe...
August 26, 2009 at 7:36 am
The backup is the size of the data in the database, not the size the database was at the time of backup. To restore it, you need free space to...
August 26, 2009 at 7:32 am
Plus correcting the bad advice helps all those numerous people who run across the thread via google but never post. Otherwise they're maybe going to take that bad advice as...
August 26, 2009 at 7:28 am
/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...
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...
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?
August 25, 2009 at 3:29 pm
Viewing 15 posts - 36,826 through 36,840 (of 49,563 total)