|
|
|
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 31 can you shrink the database in the middle of a transaction Posted by JJ Wang at 12/20/2003 11:35:07 PM Hi,
I have a huge DTS packege running right now, it's
inserting 400 million rows into a table that have a
clustered index and a non-clustered index on it. It has
been runing for 54 hrs now and the tranlog has grown to
over 160 gig.
I bet there is a lot of inactive tran-log by now. Is...more >>
Using INSERT INTO...SELECT with extra columns for target? Posted by Jack Black at 12/20/2003 11:27:39 PM Hi, all!! Using SQL Server 2000...
Is there any way to do a INSERT INTO... SELECT and add new columns/values to
the target table in the command?? I've got the basic query down fine, but I
need to also insert default values into new columns that only exist on the
target table...
Ideas? I'...more >>
General information on Enterprise Application design? Posted by ViperDK (Daniel K.) at 12/20/2003 2:51:30 PM Could someone give me a hint where to find *good* information, samples,
tutorials, hints, whatever on design of multi/three-tiered applications,
business layers etc (mainly winforms but web application information isn't
bad, too)? ok, that isn't especially on enterprise size application but on
a...more >>
DB Design/Performance Question Posted by ViperDK (Daniel K.) at 12/20/2003 2:27:08 PM We have multiple(about 20) tables in our database where multiple individual
users (programmatically, nothing to do with sql server security) or groups
can get rights on records. every table of us has a uniqueidentifier as
primary key(we need that and a few other fields for replication reasons).
...more >>
how to convert string to integer data type in SQL? Posted by Matt at 12/20/2003 12:32:02 PM I want to know how to convert string data type to integer data type in SQL?
...more >>
proper way to dts 400 million record table? Posted by JJ Wang at 12/20/2003 12:00:59 PM Hi,
we have a table 'tableA' in 'databaseA' that has 400
million rows and 60 gig big, without any index on it.
We need to build a cluster index on tableA, and a non-
clustered index on 2 of its columns.
Hence we created tableB which is identical to tableA only
tableB will with index bu...more >>
newbie: How to use nested stored procedures? Posted by Amit at 12/20/2003 10:47:54 AM Hi,
I need to use a result set returned by a stored procedure in another stored
procedure. Currently the only solution I can think of is to use a temporary
table with Insert Into and Execute. Is there a more elegant way to work with
this?
Thanks
amit
...more >>
problem with running scripts against sql2k Posted by Don Grover at 12/20/2003 9:25:39 AM Help or sugestions needed !
I have a remote dedicated server with sql2k running on it and am having
problems with running vbscrips from taskscheduler and updating tables etc.
Task scheduler shows running (but does not go away) but is not actually
updating tables.
If I run the scripts logged i...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Distinct email addresses in 2 tables with different field names Posted by Maziar Aflatoun at 12/20/2003 7:29:33 AM Hi everyone,
I have 2 tables with table A containing an 'email' field and table B
containing 2 fields 'primaryemail' and 'secondaryemail'. Now is it possible
to issue a query that would return only the unqiue email addresses in these
3 fields? So a long list with no duplicate emails(distinct)...more >>
Trigger Basics Posted by Wayne Wengert at 12/20/2003 7:25:34 AM I have a table named "customers" which includes a field named "lastchanged"
(smalldatetime). Any time a record is added or changed I want to have a
trigger that causes the lastchanged field to be updated to the current
date/time.
In looking through BOL and various references most of the exampl...more >>
Please help with a SELECT query Posted by sqlnewbie1 NO[at]SPAM yahoo.com at 12/20/2003 5:07:12 AM Please help with a SELECT query.
I have a table with one column as datetime datatype. For example
Table T1
(description nvarchar(100),
c1 datetime)
I need to SELECT the rows in which c1 is within last 60 days, AND
between 8pm - 8am, Exclude 12/1, 12/3 from midnight - 8am.
What is...more >>
Please help. Warning: The optimizer cannot use the index because the select list of the view contains a non-aggregate expression. Posted by david at 12/20/2003 1:16:53 AM I tried to create a indexed view, in the select list, I reference a
function, which accept a field of the base table, and return a string, like
select ...,dbo.uxmlfield(xml,'area'),... from basetable
it seems it is doable, but I am not sure why SQL warns the view contains a
non-aggregate exp...more >>
Query Posted by ip at 12/20/2003 1:11:05 AM i have table with one column , and the result is of 'Select name from tab1'
name
---------
Steve
Mozal
David
....
but i want the output like
name
----------
Steve,Mozal,David,.....
All in one row.....
...more >>
Passing parameters - time consuming! Posted by Raffe at 12/20/2003 1:09:57 AM My problem is related to using SQLXML (and I posted it to the sql xml group)
but I have managed to isolate this behaviour to a SQL perfomance problem.
The problem is that a query passed with sp_executesql into sql server where
I use parameters takes over 10 times longer than the same query wher...more >>
Error: 4413, Could not use view or function 'vwDocuments' because of binding errors. Posted by Do at 12/20/2003 12:17:36 AM Hi:
I searched all over the web for this. What does it mean?
What happened was that I scripted a working database that I have.
I the used that script to create another db. Then now I'm getting these
errors.
Thanks,
Server: Msg 208, Level 16, State 1, Procedure vwDocuments, Line 5
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |