|
|
|
March 2003 May 2003 June 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 November 2007 |
Filter by week: 1 2 3 4 5 Updating tables. Posted by John at 3/7/2005 11:15:46 AM Is there any optimized way for updating all the rows in single table if
there are millions of record and I want to update whole data in single table
and this is a transaction table.
Thanks in advance.
John
...more >>
Migration Tool Posted by John at 3/7/2005 10:19:12 AM Can any one let me know the migration tool from Oracle to SQL Server ?
Thanks in advance.
...more >>
SQL_DRIVER_NOPROMPT error from SQL EM Posted by Rick Henry at 3/4/2005 11:31:08 AM I just installed SQL Server 2000 Developer Edition on Windows XP SP1, then
applied SQL Server SP3a. I registered my local database with EM and a
database on another computer. The local registration is via Windows
Authentication, the other via SQL Authentication. When I attempt any of the
Ope...more >>
Defaults Posted by John at 3/3/2005 1:05:30 PM 1) Defaults are applied before transactions.
Defaults incur more overhead than constraints but less than triggers.
Defaults are less functional than constraints or triggers.
2) Defaults are applied after transactions.
Defaults incur more overhead than constraints ...more >>
synchronization of databases Posted by Farhan at 3/2/2005 4:59:02 AM I have task in regards of synchronization of databases.
Scenario is: I have 4 databases and 1 web server.
When ever I lost connection due to any reason from any database, I want to
switch automatically to other databases which are synchronizing each others.
One other thing is, how I can synch...more >>
Users accessing MySQL Posted by CJ at 3/1/2005 9:37:32 PM I have a Samba server set up in an all Windows network and 2003 AD domain.
The server works and I can see the shares...no problem there.
I also have MySQL up and running and know how to populate the databases
manually and do queries and so forth.
But what is the best way for users to acces...more >>
enterprise manager slow to load on shared server with 200 databases Posted by thomasamillergoogle NO[at]SPAM yahoo.com at 3/1/2005 4:44:39 PM My db is on a shared server with two hundred tiny databases. Query
analyzer connects very fast, buty Enterprise Manager stupidly reads the
schema for each of the 200 db's while it is loading the GUI. Sadly, it
freezes up for about ten minutes while loading all that stuff.
I love the way EM mak...more >>
3 questions Posted by John at 3/1/2005 2:59:35 PM 1) Which one of the following is NOT a SQL Server page type?=20
Index, Table, Data, Text /Image, Global Allocation MAP,
2) Which one of the following is a characteristic of a Keyset-Driven =
Cursor?=20
Order is Dynamic. , Values are Dynamic., Membership is Dynamic., =
Keyset is built in...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
different behaviour of SQL Server 2000 errors dependent on windows OS Posted by Ollie Riches at 3/1/2005 2:32:29 PM I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |