|
|
|
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 sql query with paging Posted by Howard at 9/4/2005 9:49:04 PM I need help writing an inline sql query that supports paging. I cannot
use stored procedures.
my table consists of and id (index) column, and other columns such as
NAME
TABLE1
ID | NAME |...
-----------------
1 A
2 B
4 F
9 DF
10 DFS
All examples I found on the internet use stored p...more >>
Reduce Disk I/O when writing to MS-SQL Server database Posted by vanisathish NO[at]SPAM gmail.com at 9/4/2005 7:54:02 PM Hi All,
An application is writing to the SQL Server database for every few
millisec. The disk I/O LED is continuously glowing when writing to the
database. Is there a problem with the configuration of the database ?.
How do i reduce the disk i/o when writing to the database. the
application is ...more >>
Trigger Question Posted by Oded Dror at 9/4/2005 7:20:18 PM Hi there,
I'm using SQL Server 2000 Dev. on Win XP SP2,
In Northwind database I add to the Orders table another table called
OrdersArchive.
How do I create a trigger on insert that will insert a new record from
Orders table into
OrdersArchive every time that I'm creating a new order I want...more >>
Trigger question Posted by Oded Dror at 9/4/2005 4:04:27 PM Hi there,
I'm using SQL Server 2000 Dev. on Win XP SP2,
In Northwind database I add to the Orders table another table called
OrdersArchive.
How do I create a trigger on insert that will insert a new record from
Orders table into
OrdersArchive every time that I'm creating a new order I wa...more >>
T-SQL to read INI file Posted by walterd at 9/4/2005 12:34:41 PM Hi
Anyone has a script to read an INI file?
TIA
...more >>
Execute sp_start job on many clients Posted by AG at 9/4/2005 8:55:09 AM I have about 200 msde instances running on several machines.I want to
execute sp_start_job on several clients and manage the jobs such that
the job schedules specified by the clients do not clash and can be
changed remotely if requred by us without dropping and recreating the
jobs.
All this n...more >>
Design Discussion - How would YOU do this? Posted by Chris at 9/4/2005 1:42:01 AM I'm working with data collection software and our current SQL solution is
simply not performing... well. I'm not a DB Admin, but I'm hoping to inject
useful suggestions into our next design meeting - hopefully improving things
across the board.
The situation is this:
I need to collect da...more >>
disable log file Posted by Jozza at 9/4/2005 12:00:00 AM Hi all,
I want to distribute the mdf file with my program, but i always have
problems with the transaction log file when i try to attach
the database on some other server.
Is it possible to disable the log for the database, so the attach manager
wouldn't complain about a missing log file?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Backup Database with code Posted by Roy Goldhammer at 9/4/2005 12:00:00 AM Hello there
On beggining of any month i:
1. Backup the database,
2. Restore it as diffrent name
3. Run some actions that change the database
So far i have store procedure for the the changes only
Is there a way to build code/script that do the backup action and the
restore as diffrent n...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |