|
|
|
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 |
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 How do I improve SQL Perfromance Posted by Arpit at 8/12/2007 11:58:01 PM Hello All,
Greetings,
We have converted our Backend from pervasive to SQL 2005.
We are using clarion as front end, currently we are facing performance
issue. i ran profiler and found that clarion using sp_prepexec extended
stored procedure to fetch data. sp_prepexec itself taking much t...more >>
Planning handware for better performance Posted by Roy Goldhammer at 8/12/2007 6:48:31 PM Hello there
I have server that i need to upgrate it for better performance
the application use the data is for 60% Data change and 40% data pool.
It is very important for the company avilability and performance:
Iim wondering what is the best, here is my platforms i'm thinking:
1. Set t...more >>
Inserts dramatically slower after partitioning Posted by dba at 8/12/2007 6:17:14 PM Hello All,
I've been in the process of partitioning our ODS, we have one
table that is essentiall a junk dimension. It contains user defined
fields. After partitioning by month the inserts on this table have
slowed to a crawl. It does insert a substancial number of records into
this table...more >>
Help with Update command? Posted by Peter at 8/12/2007 5:00:01 PM Hello,
Thanks for reviewing my question. It simple. I would like to update a
column in my table with an increase number. How? I am trying to initialize
each row's SEQ column with 1, 2, 3, ... so I decided to use a row number.
UPDATE temp_TEAMS
SET SEQUENCE = ROW_NUMBER() OVER ( ORDE...more >>
How to get previous row particular column for calculation in sql server 2005 ? Posted by Luqman at 8/12/2007 12:00:00 AM I want to create a moving average, current quantity in stock and current
balance amount of an Inventory Application. In Sql Server 2005, can I do
this without Iterations, using Common Table Expression.
For example:
My Table as following fields.
SNo,Item Code,Qty, Rate, Amount
Sno Item ...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |