Vista - Vista Home Premium And SQL Server 2005 Standared Edition...

Colleagues: Would appreciate any advice / perspective re the
following issues with SQL Svr 2005
Standard Edition (with SP2 applied) and Vista Home Premium:

1. All system "dbcc" maintainence queries (reindex, checktable,
checkdatabase, etc) stop running after about 4 minutes, I lose the
mouse, the box totally freezes up, must restart the computer

2. Cannot use CREATE INDEX to create a non clustered index on an
integer data field - after running for about 10 minutes, the box locks
up

3. Cannot import or export data (in any larger amounts - ie over 10
million rows) The box just locks up.

4. Cannot run INSERT queires that insert more rthan a few hundreed
thousand rows without the box freezing up

5. Printing any documents takes several minutes

I've enabled lots of growth in the database log. Other (older,
slower) boxes on my network continue to work fine. Am suspecting that
a permissions / security issue is in play.

Thanks for any suggestions,

Michael

<michael.dataSense@sympatico.ca> wrote in message
news:1184524010.000907.304500@57g2000hsv.googlegroups.com...
> Colleagues: Would appreciate any advice / perspective re the
> following issues with SQL Svr 2005
> Standard Edition (with SP2 applied) and Vista Home Premium:
>
> 1. All system "dbcc" maintainence queries (reindex, checktable,
> checkdatabase, etc) stop running after about 4 minutes, I lose the
> mouse, the box totally freezes up, must restart the computer
>
> 2. Cannot use CREATE INDEX to create a non clustered index on an
> integer data field - after running for about 10 minutes, the box locks
> up
>
> 3. Cannot import or export data (in any larger amounts - ie over 10
> million rows) The box just locks up.
>
> 4. Cannot run INSERT queires that insert more rthan a few hundreed
> thousand rows without the box freezing up
>
> 5. Printing any documents takes several minutes
>
> I've enabled lots of growth in the database log. Other (older,
> slower) boxes on my network continue to work fine. Am suspecting that
> a permissions / security issue is in play.
>
> Thanks for any suggestions,

If you have Vista pre installed or if you have upgraded Vista over the top
of XP, then you might want to flatten the HD and install Vista fresh.

You might also want to consider Vista Ultimate, Business or Enterprise as
those are business class O/S(s).

As an example, IIS7 on Home Premium is not a full version of IIS7 and
doesn't have FrontPage Extensions, although I hear there is some kind of
patch for that, while the ones above do. So you can only do Mickey Mouse Web
Development with HP,

I use SQL Server 2005 Express on Vista Ultimate, IIS7 and .Net 2005. I don't
have a problem on this laptop in running those solutions.

I would like to get SQL Sever 2005 SE and install it. I wouldn't install it
on XP Home, and I wouldn't install on Vista HP.

On Jul 15, 4:33 pm, "Mr. Arnold" <MR. Arn...@Arnold.com> wrote:
> <michael.dataSe...@sympatico.ca> wrote in message
>
> news:1184524010.000907.304500@57g2000hsv.googlegroups.com...
>
>
>
>
>
> > Colleagues: Would appreciate any advice / perspective re the
> > following issues with SQL Svr 2005
> > Standard Edition (with SP2 applied) and Vista Home Premium:
>
> > 1. All system "dbcc" maintainence queries (reindex, checktable,
> > checkdatabase, etc) stop running after about 4 minutes, I lose the
> > mouse, the box totally freezes up, must restart the computer
>
> > 2. Cannot use CREATE INDEX to create a non clustered index on an
> > integer data field - after running for about 10 minutes, the box locks
> > up
>
> > 3. Cannot import or export data (in any larger amounts - ie over 10
> > million rows) The box just locks up.
>
> > 4. Cannot run INSERT queires that insert more rthan a few hundreed
> > thousand rows without the box freezing up
>
> > 5. Printing any documents takes several minutes
>
> > I've enabled lots of growth in the database log. Other (older,
> > slower) boxes on my network continue to work fine. Am suspecting that
> > a permissions / security issue is in play.
>
> > Thanks for any suggestions,
>
> If you have Vista pre installed or if you have upgraded Vista over the top
> of XP, then you might want to flatten the HD and install Vista fresh.
>
> You might also want to consider Vista Ultimate, Business or Enterprise as
> those are business class O/S(s).
>
> As an example, IIS7 on Home Premium is not a full version of IIS7 and
> doesn't have FrontPage Extensions, although I hear there is some kind of
> patch for that, while the ones above do. So you can only do Mickey Mouse Web
> Development with HP,
>
> I use SQL Server 2005 Express on Vista Ultimate, IIS7 and .Net 2005. I don't
> have a problem on this laptop in running those solutions.
>
> I would like to get SQL Sever 2005 SE and install it. I wouldn't install it
> on XP Home, and I wouldn't install on Vista HP.- Hide quoted text -
>
> - Show quoted text -

Hi - thanks for writing - the box came with Vista pre-installed.
Microsoft says that SQL Server should run with Home Premium as long as
SP2 of Sql Svr is installed. Am seriously considering putting Windows
Server 2003 (w SP2) on the box as I have other boxes with Server 2003
and none of the problems above occur.

Best wishes,

Michael