|
|
|
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 queries Vs Stored Procs Posted by Nickl at 12/31/2004 9:43:02 PM I often use a chain of queries to produce a final output. Eg to prepare
aggregate data, or to set up generic queries which are then used in many
other queries to simplify things.
My question is this; how much advantage performance wise will I get if I
make those sub-queries stored procedures...more >>
Loading a set of Records Posted by Gopinath R at 12/31/2004 6:10:35 PM Hello All,
I have a Table named DVDVideo in the Stage database (StageDB) as well as in
the Production DB (VideoMediaDB).
On a weekly basis, the data have to be moved from StageDB..DVDVideo to
VideoMediaDB..DVDVideo. In StageDB..DVDVideo,
one can find the following types of records :
[1]...more >>
Cursor operations Posted by Andrew Clark at 12/31/2004 5:23:58 PM Hello,
Suppose the following:
DECLARE test CURSOR FOR SELECT nameID, firstName FROM testing
DECLARE @array TABLE ( nameID INT NOT NULL,
firstName VARCHAR(32) NOT NULL )
DECLARE arrayCursor CURSOR SCROLL FOR SELECT nameID, firstName from
@array
DECLARE @index INT, @count I...more >>
Can Indexes effect Bulk Insert/Update Operations Posted by Siz at 12/31/2004 5:22:58 PM Hi,
I have a suspicion about using Bulk Insert/update on indexes tables whether
they bogged down performance or not. Or dropping indexes and/or constraints
at start of bulk operation and then creating them again at the end will help
or not ???
Can Indexes effect bulk insert and update opera...more >>
True or False question. Posted by Miguel Dias Moura at 12/31/2004 3:13:57 PM Hello,
On a users table I have a field which indicates if the user is
authorized or not. Is there a Boolean type in SQL database 2000 or
should I use integer type?
What is usually used?
Thanks,
Miguel
...more >>
How to edit a Microsoft SQL database online? Posted by Miguel Dias Moura at 12/31/2004 3:04:36 PM Hello,
On a web site I manage I have a Microsoft SQL database.
As administrator I would like to easily edit, access, delete, add any
record in the database tables while the database is on the server where
I host my web site.
Is there any software to do this?
Something like Enterprise...more >>
Happy New Year to All Posted by Pike at 12/31/2004 2:52:20 PM In case you haven't noticed:)
...more >>
where would be ideal location for tempdb and translog? Posted by === Steve L === at 12/31/2004 2:32:30 PM sql2k.
i've read it some where that transaction logs and the TempDb should be
place on a RAID 1 (mirror) drive.
I have two questions about the statement:
1. is it only limited to transaction logs? can log files (ldf) benefits
from the same idea?
2.how can I move a tempdb out of its defau...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Summarizing data, grouping by time period. Posted by Nevyn Twyll at 12/31/2004 1:44:01 PM I have a table of student incidents, including absences from school, listing
the student ID, the date of an incident, and whether it was an absence.
I want to get a result set from this table showing me ON ONE ROW, the
studentID, and the absences split up by term.
Table: [Incidents]
Perti...more >>
error in executing SELECT statement Posted by Dzemo at 12/31/2004 11:55:09 AM I get this message when executing SELECT statement in SQL 2000:
Location: recbase.cpp:1374
Expression: m_nVars>0
S PID: 51
Process ID: 2480
Why? Any help?
...more >>
SQL 2000 slowness Posted by yung.robert NO[at]SPAM northropgrumman.ca at 12/31/2004 11:12:32 AM Hi,
I have a very strange problem. I have one sql 7.0 box, and one sql
2000 sp3 box. An ASP app that we've been running off of the 7.0 is
now running about 10x slower on the 2000 box. The 2000 has more ram,
faster processor, and both are running on WinNTsp6a. I have checked
all the possib...more >>
How to rethrow errors from catch block? Posted by Alexander Jerusalem at 12/31/2004 4:45:06 AM I was hoping for a more streamlined error handling now that we get try-catch
but I seem to be running into a few problems. One very important idiom with
try-catch is to first rollback the transaction and then rethrow the original
exception in the catch block. How can I do that for system error...more >>
DATEADD Command Posted by Robert at 12/31/2004 4:33:01 AM Hi,
I Have the following bit of SQL in a stored procedure:
SELECT DISTINCT ref
FROM U_NFADHOC
WHERE CONVERT(DATETIME,DATE) BETWEEN DATEADD(MONTH,
-12,CONVERT(DATETIME,@enddate)) AND CONVERT(DATETIME, @enddate)
AND RESPTYPE='NF Cash Donation'
Currently (as I hope you can see) it is ...more >>
stored procedure error Posted by Robert at 12/31/2004 2:01:02 AM Hi
Would it be possible for someone to check my code for the stored procedure
shown below. I'm passing a date parameter into it, and then checking that the
donor has made at least one payment every year from the parameter date. It
did work when I first ran the query, but now it's coming up ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |