|
|
|
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 |
Universal Data Model Posted by palibotlibot NO[at]SPAM gmail.com at 11/29/2004 10:57:12 PM A client has asked us to develop a web appplication using SQL Server
2k as the back-end DB. The client's project consultant wants us to use
the schemas in the The Data Model Resource Book by Len Silverston
(ISBN: 0471380237)
Amazon link:
http://www.amazon.com/exec/obidos/tg/detail/-/0471380237/...more >>
Ramifications of switching off statistics... Posted by almurph NO[at]SPAM altavista.com at 11/25/2004 4:03:21 AM Folks,
Do you know of any negative ramifiactions/issues that can result
from switching off statistics gathering on a SQL Server 2000 box?
My understanding of statistics gathering is that is is collected by
the system to make the system more intelligent and then it can run
faster apparen...more >>
SQL Server 2000 Performance Suddenly Drops Off Posted by Greg at 11/24/2004 1:31:14 PM Greetings,
We have an interesting issue with a Win2k server running SQL Server 2000
SP3. This server is behind a couple of web servers that run an ASP
application. After a period of time that can range from a couple weeks to
several months, query performance will instantaneously degrade by a...more >>
Access .adp :How to INSERT all but KEY violations Posted by JimJimJimJim at 11/17/2004 5:16:29 PM I am trying to append records from one table to another in a db running on
MSDE, knowing fullwell that some of the data in the source will be
duplicates of that in the destination table's pk.
What I would like to happen is to have the stored procedure plunk in all
records that don't violate the ...more >>
Moving database from MSDE to SQL Posted by kgg NO[at]SPAM ssastructural.com at 11/17/2004 12:26:44 PM I have an end-use that created a database on MSDE and is housing it on
his local computer. We want to move/copy it to our SQL server so it
can be backed up etc. What are the appropriate steps in doing so?
Thanks in advance,
Ken...more >>
sql novice is confused (again) Posted by spam dump at 11/16/2004 7:33:12 PM Okay_ sql(2000) wizards_ here's a question for you...
I have two tables. One is used to update the other. I'm looking for
null or changed values in the existing route number field to replace
from table a to table b.
(actually the real query is looking at changed values for a bunch of other
f...more >>
Problem:MS-Access.adp with MSDE link to csv file Posted by JimJimJimJim at 11/13/2004 3:42:31 PM Hi. I'm coming from a background of developing mdbs and am trying to migrate
our databases to adps running atop MSDE 2000. However, I've encountered a
problem while trying to do analogous things to what I've done before with
mdbs...for example:
-Linking to a csv file on another machine: I am ...more >>
Table Variable Memory Allocation Posted by morann NO[at]SPAM gmail.com at 11/2/2004 4:58:33 AM I am working with a system that uses quite a lot of stored procedures
that make use of table variables extensively. The ram used by the
database server quickly rises to close to 2 Gb. The amount of memory
used by sql server is limted but as soon as the memory reaches the
limit, the performance o...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to convert to regular text, data stored in Image data type field ???? Posted by SD at 11/1/2004 11:49:55 AM Hi,
This is driving me nuts, I have a table that stores notes regarding an
operation in an IMAGE data type field in MS SQL Server 2000.
I can read and write no problem using Access using the StrConv function and
I can Update the field correctly in T-SQL using:
DECLARE @ptrval varbinary(16...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |