quote:Originally posted by MohammedU What was the sample did you use when you update the stats.... If you use default sample try with FULL SCAN...
Satya- Both databases are on the same server. Travis
quote:Originally posted by satya Are you using MAXDOP hint in the queries? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor &...
quote:Originally posted by Luis Martin I presume you have set only 1 processor for parallelism, did you? Luis Martin Moderator...
I am experiencing this issue on a clients server. I run the procedure on their production database and it can take from 4 to 7 minutes to complete....
quote:Originally posted by joechang 4 cores (2 x dual or 1 x quad) of the new Core 2 line (Xeon 51xx and 53xx) will be far more powerful than 2 of...
We are looking at upgrading our production database to either 2 Dual Core Intel® Xeon® 5160 or a single Quad Core Intel® Xeon® X5355. We are...
quote:Originally posted by Traveiso10 Nope, this is all the jobs do: CREATE UNIQUE CLUSTERED INDEX [PK_<index>] ON [dbo].[<table>] ([<column>])...
Nope, this is all the jobs do: CREATE UNIQUE CLUSTERED INDEX [PK_<index>] ON [dbo].[<table>] ([<column>]) WITH PAD_INDEX ,FILLFACTOR = 80...
quote:Originally posted by Adriaan Is there another job that drops the indexes, which runs before this one? There could be a job that loads lots of...
Okay, I'm not doing this but another DBA did this before me. He created about 18 separate sql jobs for 18 different indexes and in each job he is...
Has any one used this type of configuration or am I the only one? The Microsoft forum is telling me that I can't use more than 2GB of memory for SQL...
Okay, I added the switch in the boot.ini. But, it seems that SQL still isn't using the memory that I have set for it to use. I moved the slider for...
quote:Originally posted by joechang yes, because s2k is a 32-bit app and will benefit from the extra 1GB of virtual address space, & memory Thanks...
I just wanted to verify that I can use the /3GB switch on our Windows 2003 Server R2 64-bit. We are running SQL 2000 Standard Edition. We have 4GB...
Separate names with a comma.
