all groups > sql server clustering > june 2005 > threads for june 15 - 21, 2005
Filter by week: 1 2 3 4 5
index
Posted by Travis at 6/21/2005 9:41:01 PM
Hi ,
If I create a database , it will have a *.mdx and *.log files cater for
that database. If I create a index (clustered or non clustered) is it store
on the mdx files as well or index pages are store on different files ?
--
Travis Tan... more >>
Using BULK utily to load data on SQL Server failover luster
Posted by oliver at 6/21/2005 5:16:01 PM
Hi. We need to load data using bulk utility, and We wolud like to use Remote
Administration to do this. Then I would like to know if there are some
problem to load data using bluk and remote administration.
We have Windows 2003 Enterprise Edition and Active/Pasice schema.
Than you for you... more >>
Memory settings for Virtual SQL Server
Posted by JT at 6/20/2005 10:50:02 PM
Hi all,
I am planning to put one instance of SQL Server 2000 sp3 on a two node
Windows 2003 EE MSCS. Each node has two channels, with each channel running
RAID 1. The page file is in one channel, and the OS in the other. Each node
has 4GB of RAM, and PAE enabled. The pagefiles are locked ... more >>
SQL2000 Standard + Windows2003 cluster
Posted by Ayad at 6/17/2005 5:07:21 PM
Can SQL 2000 Standard edition be installed on Windows 2003 Cluster Server?
Thanks
Ayad
... more >>
SQL2K with w2003 EE cluster active/passive step by step guide
Posted by oliver at 6/16/2005 2:28:04 PM
Hi.
Someone has a step by step guide to install and configure the w2003 EE
cluster and to use SQL2k failover cluster active /passive solution?
Thank you... more >>
install sp1 on W2K3 cluster w/ SQL 2000 - any know issues?
Posted by mb at 6/16/2005 2:02:04 PM
Got a pair of HP DL380s clustered and am getting ready to install SP1.
Anyone have problems with the SP in a SQL cluster? Put SP1 on a Dell 1750
print cluster and it erased the RAID drivers on one of the nodes - something
I definitely want to avoid on my SQL box. Thanks.... more >>
Guide to install Windows 2003 Cluster with SQL Server 2000 cluster
Posted by OBD at 6/16/2005 12:36:04 PM
Hi. I need to install 2 windows 2003 servers on cluster and after configure
the SQL Server failover cluster. Do you have some guide to do this? Because I
have been material about windows 2000 and sql server, but not about windows
2003 with sql server.
Thank you very much... more >>
Migrate DTC
Posted by Hidayat via SQLMonster.com at 6/15/2005 9:05:30 AM
Hi guys,
I have an existing sql 2k enterprise server and we're going to configure it
for server clustering. We have custom made DTC package and most of the
application use it very often.
My concern is how do we migrate this custom made DTC package to the new
environment(sql cluster)?
App... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Creating a unique index on a table
Posted by Robert at 6/15/2005 1:04:03 AM
Hi,
I'm trying to create an index on a newly created table. I want the index to
be on the field ref. I tried running:
CREATE INDEX ref ON U_segment (ref)
but it's just sitting there! The ref is unique anyway, and there are about
700,000 records.
Any help, or advice would be apprea... more >>
|