Flag -T1118, "Concurrency enhancements for the tempdb database", is it required with SQL 2

Hi:
Is the flag -T1118 required to solve the problem described in
http://support.microsoft.com/kb/328551, when you have SQL Server 2000 with
Service Pack 4, or it's unecessary?
I'm not sure if this is unecessary. I didn't see, anywhere, something
like "Hey, man, apply SP4, create multiple files for tempdb, and forget
the -T1118 flag, it's not required anymore...". The documentation says, in a
shy way, that's the problem is solved on SP4, but I've found places that
says to always create multiple files for tempdb.
What's the correct? Should I always have -T1118 applied or it's not
required?
TIA,
--
Ravi Wallau
nospam@.nospam.orgYou might want to do a feedback on that KB asking for clarification. Here's what is going on:
Trace flag 1118 will mean no allocations from mixed extents (except from IAM pages). This can
increase concurrency on your tempdb as it will decrease hit on the SGAM page.
The fix in the KB mean that several files for tempdb will be used in a round-robin fashion,
essentially spreading out SGAM hit over several files.
You can combine one with the other. Since eliminating mixed extents for data will mean increased
storage utilization, I recommend you go for the KB fix to start with. If you still feel you have
resource contention of the tempdb SGAM page, try adding trace flag 1118 as well.
We recently had a discussion in the MVP group on how the article is worded, but I have a feeling
that the discussion didn't trigger a re-wording in the article...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ravi Ambros Wallau" <nospam@.nospam.com> wrote in message
news:OykXgqtRGHA.5900@.tk2msftngp13.phx.gbl...
> Hi:
> Is the flag -T1118 required to solve the problem described in
> http://support.microsoft.com/kb/328551, when you have SQL Server 2000 with Service Pack 4, or it's
> unecessary?
> I'm not sure if this is unecessary. I didn't see, anywhere, something like "Hey, man, apply
> SP4, create multiple files for tempdb, and forget the -T1118 flag, it's not required anymore...".
> The documentation says, in a shy way, that's the problem is solved on SP4, but I've found places
> that says to always create multiple files for tempdb.
> What's the correct? Should I always have -T1118 applied or it's not required?
> TIA,
> --
> Ravi Wallau
> nospam@.nospam.org
>sql

Fixed Headers in RS 2005

I've been playing around with RS 2005 for a few days trying to validate
the new features/enhancements with it vs. RS 2000. I'm looking at the
Fixed Headers enhancement and wondering if I'm doing something wrong.
I set the table property of 'Header should remain visible while
scrolling' and the header does this, but it is constantly being
overlayed with the detail rows so it is not easy at all to read.
Is there something else I should be doing to avoid this?
Thanks,
KelOne work around I did figure out was to fill in the header row with a
solid color therefor stopping the details lines from showing through.
Let me know if anyone has any other solutions.
Thanks,
Kel|||I have encountered a diffrent problem. If my data source returns 45 rows or less, the table fits on one page and the header is locked for scrolling,
If the data source returns 46 rows or more, it ignores the "header should remain visible while scrolling" and "fit table on one page if possible" options.
Has anybody found a solution to the "should" and "if possible" problems?
It seems like rs has commitment issues, so any help would be GREAT!
Elina.
From http://www.developmentnow.com/g/115_2006_5_0_0_753604/Fixed-Headers-in-RS-2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Which version of SQL Server 2005 do you have? I had the same issue and found out that this bug doesn't occur on the RTM version Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86). However it does occur on the SP2 version.
There is a SP2 cumulative update that is supposed to fix this issue, but it didn't work for me, you can try to apply the hotfix, check the following link: http://support.microsoft.com/kb/943656
Let me know if that solves the issue for yo
From http://www.developmentnow.com/g/115_2006_5_0_0_753604/Fixed-Headers-in-RS-2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com