|
|
|
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 Index defragmentation Posted by joe at 9/13/2003 9:43:07 PM Are there any other ways to defrag indexes and does DBCC
IndexDefrag do as good of job as DBCC DBReindex or
Dropping and Recreating the index?
Ways to defrag an index:
1) DBCC IndexDefrag
2) DBCC DBReindex
3) Drop/Create Index
Thanks...more >>
Trying to get last ten weeks sum of a table. Posted by jack at 9/13/2003 9:13:25 PM Hello,
I want to get the Date of the sunday for the last ten weeks.
Example:
09-07-03
08-31-03
08-24-03
08-17-03
08-10-03
08-03-03
07-27-03
07-20-03
07-13-03
07-06-03
Then I need to get the sum of a table for each week. I am new to sql. I
have tried a few things, but no luck....more >>
Query Wont Accept WHERE Clause Posted by Wayne Wengert at 9/13/2003 6:47:30 PM I am trying to get a list of rows where certain fields are duplicated. The
following query works fine:
SELECT Names.NameID, Names.Addr1, Names.ZIP, Names.FirstName,
Names.LastName,
Names.City, Names.StateProv FROM Names JOIN (SELECT Addr1, ZIP FROM Names
GROUP BY Addr1, ZIP HAVING count(*) > ...more >>
Newbie JOIN questions Posted by William B. at 9/13/2003 10:41:32 AM I've been working with Oracle for years, so bear with me....
1) Can you just use standard SQL for inner joins, rather than using SQL
Server's "INNER JOIN" syntax?
example:
select t1.col, t2.col
from table1 t1, table2 t2
where t1.key = t2.key;
Is there any disadvantage to doing the abo...more >>
Trace flags Posted by Abraham at 9/13/2003 10:05:29 AM Hi
I issued command DBCC TRACEON (1200,1204,1205,1206)
When I checked DBCC TRACESTATUS(-1) the status is 1 for all these flags.
But surprisingly nothing is loging .Is there anything else to do ?
I used to do this earlier and it worked .The only difference here in SERVER
is this is a named insta...more >>
Temporal History Table Posted by dave.google NO[at]SPAM aquariusinternet.com at 9/13/2003 9:45:18 AM I'm running into the challenge of storing temporal history data for
all tables in my system, and am trying to formulate a strategy for
this. My requirements are 1) schema simplicity and flexibility; 2)
programmability. I am not overly concerned with performance since I'm
working with a small-ish...more >>
How To Posted by Wayne Wengert at 9/13/2003 9:44:29 AM We have a moderate sized table (25,000 rows) of contacts. We want to
eliminate duplicated entries in this table but we want the office staff to
be able to decide when the entries are really redundant. In some cases,
there could be two different people at the same address (e.g. school dorm)
so we...more >>
Getting a default from another table Posted by Roger Sipson at 9/13/2003 8:41:31 AM I have a table with some default values, one of which is a current YearTerm
indicator. I would like to be able to have another table use the default
table current YearTerm as the default value for the student's admit date.
YearTerm is not a small date, it is actually a char(5) of the form '20031...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |