|
|
|
January 2003 March 2003 April 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 clustered index Posted by simon at 3/18/2006 10:25:29 PM I have question about clustered index.
If you look at share point portal server database you will see, that primary
key clustered index is composed of one unique identifier column and 2
columns of nvarchar(255) data type.
Isn't that too long clustered index?
I thought that clustered in...more >>
Backup and Restore with STOPAT Posted by George Homorozeanu at 3/18/2006 6:26:45 PM Hi
I want to implement the following simple scenario as a test prior the real
implementation to see if these scenario is plausible. I want to test the
STOPAT option of the RESTORE LOG command.
1. First I want to full backup the database (the "Recovery model"
option is set to...more >>
Change Field Name Posted by Agnes at 3/18/2006 6:14:45 PM I got 30 tables and I want to change one field name ,
Can I use SQL script to do that ?
Thanks a lot .
...more >>
UNABLE TO SEE SYSTEM TABLE IM NY ENTERPRIsE MANAGER Posted by Savas Ates at 3/18/2006 1:43:19 PM When i choose my database in enterprise manager i cant see my system table ?
What is the setting to see them ?
...more >>
can this be done? Posted by Howard at 3/18/2006 1:13:44 PM
Table1
ID|CATID|NAME
1 3 A
2 3 B
3 3 C
4 4 D
5 4 E
I want to write a query that pull all the record from the same CATID but
with only ID given.
If ID = 4 it would return ID 4 and 5 because they are in the...more >>
Query question Posted by joel at 3/18/2006 12:44:00 PM Hi All,
I have a problem with my query. I want to get the 2nd occurences of space
after the comma(,) sign. I have a query but only works if the city/area is
one word.
example: correct
SELECT CHARINDEX(' ', 'Atlanta, GA 1234', CHARINDEX(' ', 'Atlanta, GA
1234')+1)
example: wrong shou...more >>
Delete and insert data in same transaction! Posted by Hans at 3/18/2006 11:24:35 AM Hi!
I try to add records in one table from a VB6 com+ component using ADO
(provider=SQLOLEDB, SQL-server2000).
Basically what I try to do is to
1. Start a transaction
2. Delete old records in one table
3. Add new values in the same table
4. commit transaction
The problem is that I get ...more >>
**fetch the related tables of a particular table** Posted by R-M at 3/18/2006 11:23:17 AM Hi
I'm working with SQL server 2000, and I want to know how can I find the
list of tables which have relation to a particular table. in another word,
would it be possible to fetch the name of those tables by a simple Sql
statement?
Any help would be greatly appreciated....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
conditional update within value Posted by JR at 3/18/2006 10:28:09 AM I have a column of data in SQL Server 2000 that I need to replace
values within it with new values. I know how to use CASE statements to
do conditional updates but not how to do this. Here is an example, not
the real example as the values relevant to my company would mean little
to anyone.
...more >>
Log Shipping Question Posted by Ed at 3/18/2006 9:16:27 AM Hi,
I would like to implement Log Shipping to my company and I have everything
set up and work fine. However, I am not sure how to ship the database backup
file to the destination server after the first time. Since the log shipping
function only ships the log file, if I want to also ship ...more >>
optimized indexing Posted by Sinclair at 3/18/2006 7:56:29 AM Hi,
I would like to consider optimized indexing on the table which really does
not exist in my database, but will serve as an example for creating indexes.
Suppose that there is a table with following fields:
- family name,
- first name,
- dateofbirth,
- street,
- home number,
- ...more >>
Hebrew Sql 2000 to 2005 Collation Problem ? Posted by D.R at 3/18/2006 6:01:20 AM Dear Gurus :
i have a database on sql 2000 server with default Collation set to ( British
English ) and the databse have hebrew character inside and everything works
great now that microsoft comes with the new sql we deatach the database from
2000 and attached it to 2005 version , now the pro...more >>
MOVING FROM ACCESS TO SQL Posted by alami_marieme NO[at]SPAM hotmail.com at 3/18/2006 2:06:32 AM Hi
could anyone help please...I've problems moving my database from Access
to SQL specially with tables relationships...Here is the probl:I have a
form having the Order number, order date, client code...this
information is taken from table BLA.on the same form,I've a subform
having quantity bou...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |