Archived Months
March 2003
April 2003
May 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
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 >>



DevelopmentNow Blog