|
|
|
January 2003 March 2003 April 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 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 July 2007 August 2007 September 2007 October 2007 |
advice please: uniqueidentifier vs. identity as PK Posted by google NO[at]SPAM sigol.co.uk at 9/27/2003 11:17:30 AM Hi,
Hope you can help:
I am in the design stage of a database that will increase by around
100,000 records per annum. As well as the main three tables (each
containing 100,000 recors) there will be around 12-15 lookup tables,
each with between 10 and 50 lookup items.
I want to use GUIDs ...more >>
Unique Constraint vs. Unique Index Posted by jeff_carver NO[at]SPAM hotmail.com at 9/26/2003 9:38:56 AM I have yet to find a clear explanation of (a) what the difference(s)
is/are between a unique constraint and a unique index, and (b) under
what conditions one would be preferable over the other.
Any takers?...more >>
How do I make this as fast as possible? Posted by Jim Hubbard at 9/25/2003 1:16:17 AM I have a test project that I am trying to code to be as fast as possible.
The project is a lottery speculation project that uses .Net web services to
return an XML recordset.
The goal is to accept any number of 5 possible balls, and return a recordset
of all past draws and possible draws tha...more >>
Date Format Errors Posted by des_crocker NO[at]SPAM harcourt.com at 9/23/2003 7:14:01 AM Dear all,
I have an asp web application that submits SQL commands to our SQL 7
database. When trying to run one of the users queries with a date
selection where the days > 12 I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a
char data type to a da...more >>
How can I change the output format of osql for example? Posted by e9827101 NO[at]SPAM student.tuwien.ac.at at 9/22/2003 5:16:04 AM hello!
can i change the output format of osql queries in the command line?
i don't want to see columns with an unnecessary width. is there a way
to see always the smallest column width?
i hope that someone knows what i mean.
thx for help in advance
sincerely,
lerod...more >>
How to read data from 3 different servers ? Posted by meh at 9/18/2003 2:15:41 PM I have 3 companies, 10 miles apart. Each company has their own static ip
address. All three connected thru VPN.
I am on company number 1 and mapped company 2 and 3 as drive letter N and O
respectively. So now I have company number 2 and three available.
I am in a process of writing a stor...more >>
How to set a column to be an identity column in TSQL. Posted by Jim Mitchell at 9/16/2003 9:25:30 AM Can someone provide the syntax for setting a column to be an identity column
in a stored proceedure. When I export my database, my identity columns are
no longer identity columns.
...more >>
Security Over Internet. Posted by Tony B at 9/14/2003 7:41:59 PM Hi All
I am a newbie with MS SQL. I am curently working on an application which
uses MS Sql as the database. The application will be used by approx 5 users
on the network, and the data will be available on the web via an asp.net
application that allows clients to obtain read only access to t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Nasty ISPish hierarchy Posted by Bennett F. Dill at 9/10/2003 3:00:53 PM Ok here's the deal. I'm doing some work for an ISP / telcom. They
basically provide communication from the customer (banks mostly) to the
terminal (ATM / POS). So if you imagine a typical network, we're looking at
something like...
Cust 1 Cust 2
| ...more >>
Retrieving part of a field Posted by Bruce Wiebe at 9/9/2003 4:06:29 PM hi all
my customer has an sql table that holds the date in the format 08/09/2003 in
a text feld does anyone know how i can perform a select on this so that i
can retrieve all the records that have the month value of 09
thanks in advance
...more >>
SQL-92 Posted by BugHunter at 9/8/2003 9:13:28 PM Hi there,
I'm working on SQL parser at the moment and want to create a set of
tests for select statement. I'm too lazy to type all possible variants of
select statement. Does anybody have or can point to the list of possible
select statements (I mean a reasonable subset) examples?
Thank...more >>
MSSQL vs Disk Defragmenter Posted by KStahl at 9/7/2003 7:22:38 PM Will the default disk defragmenter operate on datbase files when the
instance is active? What about the full version of DiskKeeper?...more >>
Accounts for SQLServer service vs SQLServerAgent service Posted by CJM at 9/1/2003 3:17:34 PM I've just changed the account under which SQL Server starts on my
development server. The new account has admin rights, and a corresponding
Exchange email account - so I can now receive alerts at various points.
I've restarted the server, and the SQL Server service seems to be running
OK.
H...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |