cannot install sql 2008 on windows xp
Wed, 20 Aug 2008 13:02:16 -0500
Hi all,
I have a Windows XP SP3 box with VS2008 SP1. I am trying to install all the
sql 2008 client tools on my machine and was able to successfully run the
first part of the install where it installs the windows xp hotfix and then
asks you to reboot.
However, once the machine rebooted and I went back to l ...
|
database file setup
Wed, 20 Aug 2008 09:00:02 -0700
I Have a database that has 100G imported from other database. Now I am
planning to setup this databse. I wonder which is better you use between 1
data file and many data files when the database is bigger? Thanks. ...
|
cpu setup
Wed, 20 Aug 2008 08:56:04 -0700
Hi guys,
I have one server with two instances, and it has 8 cpu and 32 G memory. I
would like to setup 4 cpu to instance 1 and 3 cpu to instance 2 ans 1 for OS.
Is that possible to do that? How to do? I also want to setup 16 G memory to
instance 1 and 12 to instance 2 and other to OS. Do I need to setup min ...
|
AWE & SQL2000 Server memory
Wed, 20 Aug 2008 08:51:06 -0700
We just added the /PAE switch to the boot.ini file last night and I'm not
seeing what I expected.
When I look at the server properties in EM, Memory is set to dynamically
allocate 0 to 9GB and I don't see any option for the AWE flag.
When I look in MS, I see the AWE box unchecked and dynamic allocation of ...
|
Upgrade the SSMS client on the server so Check Database Task will
work??
Wed, 20 Aug 2008 07:17:01 -0700 (PDT)
I recently noticed that our Check Database Maintenance Task is always
failing.
Further research shows that upgrading the SSMS client on our SQL
servers may permit re-creating the maintenance job so that Check
Database will function properly.
SP2 is installed to the two SQL servers.
SQL 2005 DB Engine is ...
|
Scheduled Task to run DBCC Updateusage ?
Wed, 20 Aug 2008 21:08:55 +1000
From the maintenance plan job, we find that there is error in index. There
is an suggestion in the error message to run DBCC UPDATEUSAGE. We search
the web and believe that the reason for that error is the database is
upgraded from SQL Server 2000 to SQL Server 2005 three months before.
We believe that ru ...
|
AWE SQL 2005 / 8Gb RAM / 32bit
Tue, 19 Aug 2008 22:21:36 -0700 (PDT)
I have a Dell 2950 running Windows 2003 Enterprise Edition with a
MD1000 attached to it with RAID10. SQL version is Standard. The
system has 8Gb of RAM and I am wondering how to utilize memory in the
most efficient manner.
Any help would be appreciated. Thanks ...
|
|
|
Stumper SQL statement Date problem
Tue, 19 Aug 2008 22:20:40 -0700 (PDT)
I have been having trouble creating a SQL statement to send to SQL
server express from VB.net that evaluates a date in the DB on SQL
server.
The statement is:
"SELECT * FROM TICKETS WHERE SUBMITTEDBY ='" & Session("Login") & "'"
& " AND SUBMITTEDON>=2008-08-21 00:01:00 AND SUBMITTEDON<2008-08-21
00:01:00 AND ...
|
ON AGGREGATION
Tue, 19 Aug 2008 16:12:32 -0700 (PDT)
I FOUND THIS EXERCISE ONLINE BY MYSELF. WOULD LIKE TO PRACTICE A
LITTLE BIT MYSELF.
Database schema consists of 4 tables:
Company(ID_comp, name)
Trip(trip_no, id_comp, plane, town_from, town_to, time_out, time_in)
Passenger(ID_psg, name)
Pass_in_trip(trip_no, date, ID_psg, place)
Company table has ID an ...
|
SQL 2008 PowerShell and SQL 2000
Tue, 19 Aug 2008 15:14:13 -0700
Hi,
SQL 2008 Books Online says that "SQL Server PowerShell can connect to
instances of SQL Server 2008, SQL Server 2005, or SQL Server 2000...
earliest version of SQL Server 2000 that you can use is SP4."
I have three computers:
1) My workstation: Windows XP SP 3 with SQL 2008 Tools, but no servers
2) A SQ ...
|
