all groups > sql server (microsoft) > june 2005 > threads for june 1 - 7, 2005
Filter by week: 1 2 3 4 5
Efficient record storage 10+ Million records
Posted by Ben at 6/7/2005 9:22:09 AM
I have a database that stores survey information. I've been asked to add
information to it to test scalability. Well, its' hurting.
What I have is a 'sample' table or the people that took the survey and then
several related tables.
Lets' say the sample table looks something like
tblData... more >>
Strange stored procedure results
Posted by bruce.parrott NO[at]SPAM infinity.co.nz at 6/6/2005 9:38:58 PM
I have a customer website that I host. The site uses a MSSQL 7 database
(Win2K) that has a particular stored procedure which exhibits the
following behaviour:
1. Running the stored procedure in SQL Query analyzer takes ~1.5
minutes
to return 890 rows.
2. When we backup and restore the databa... more >>
Windows XP Pro Repaired - SQL Server Enterprise Manager Not Working
Posted by Jerry at 6/6/2005 10:53:26 AM
Hi all,
I had to repair Windows XP Pro due to some corruption. After doing so
everything seems the same on the node that had Enterprise Manager on
it, however, I am unable to register or discover the database node.
Network is the same and still working properly. Not sure why I am
unable t... more >>
Stop replication of deletes
Posted by stephen atkins at 6/2/2005 8:18:49 PM
Hello all. We are just getting started with replication and I'm
wondering if there is a way to not have deletes replicated. I know I
could manually remove the delete trigger from every table but I'm
intrested in have this a bit more automatic (like when its creating the
subscription).
T... more >>
Moving 7.0 -> 2K Chinese
Posted by Larry Richardson at 6/2/2005 12:00:00 AM
Here is the setup. I have a SQL Server 7 DB in China that I need to move to
a SQL 2000 machine in US.
I have tried several different methods, but the Chinese characters are
always messed up.
I have created the Server/Database with the CHinese_PRC_CI_AS collation,
which matches the SQL7 ... more >>
express 2005 license
Posted by Candor Feg at 6/1/2005 11:33:48 AM
what's the deal?
Free for non comercial use?
I can include it in my apps, but not commercial apps?
What "non commercial" apps coult there really be?
thanks
... more >>
|