|
|
|
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 UPDATE - Lock \ Network Error Posted by MS User at 9/19/2004 11:49:19 PM SQL 2K
I got a update statement (given below).
MyTable - 3 million rows
[commondata].[dbo].racurrencyconversionrates - 84 rows
Update is performing on a server with multiple databases, 'commondata' is a
different db.
The update is like this (@ Server - Myserver, db - Mydb)
update myt...more >>
Running large reports off SQL server (i.e. Crystal Reports) Posted by Lucas Tam at 9/19/2004 11:37:01 PM Hi all,
I need to run large reports off a SQL server using an application like
Crystal Reports. Unfortunately Crystal Reports for VS.NET runs into
memory problems if the result set is >50,000 rows. As such, I need to do
all my calculation, collating, etc on the server side and then send a
...more >>
full join and nulls Posted by Can Ersoz at 9/19/2004 10:52:47 PM Hi there,
Maybe there is a simple solution to my problem, that is bothering me for a
while now but I just don't have it. No matter how hard I searched on
Internet I did not find a helpful tip. I would really appreciate any help.
I am performing a full join on two tables.
Select t1.PID P1,...more >>
split sql stored procedure into logical blocks Posted by gogator NO[at]SPAM gmail.com at 9/19/2004 10:51:30 PM Hi,
Is it possible to logically split a SQL Server 2000 stored procedure
into logical blocks(like we do calls to functions in C/C++ within the
same file).
like(syntax not correct..)
create stored procedure ....
......
call block_1 (not call to another stored procedure)
......
call block...more >>
table var vs. temp table Posted by GUY at 9/19/2004 8:54:22 PM i was just messing around with using temp tables vs. table variables. being
new to this - im not quite sure what is going on here - maybe someone can
shed some light on this as to how these two queries affect the tempdb and
what is better for performance.
note: myTable contains around 120,...more >>
update question Posted by GUY at 9/19/2004 8:16:42 PM i have a varchar field in which i want to replace all 'O' characters with an
'E' character and all 'E' characters with an 'O' character
so that the last name STONE becomes STENO
any help is much appreciated
thanks
...more >>
Querying File Size in SQL Server Posted by Mark at 9/19/2004 8:12:36 PM I need to achieve following task.
I need to monitor the size of a file in OS at a certain
location. If the file exists and the current size is over
5 GB, I need to send an alert email.
1. How would you accomplish this? Should I use XPSMPT to
send email from SQL Server? If so, how do yo...more >>
Very bad performance Posted by sysdba at 9/19/2004 5:14:13 PM Hi All
1. I have a table with this structure:
CREATE TABLE [dbo].[tbl1] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [varchar] (200) COLLATE Hebrew_CI_AS NULL ,
[c] [bigint] NULL ,
[d] [bigint] NOT NULL ,
[e] [varchar] (90) COLLATE Hebrew_CI_AS NULL
)
ALTER TABLE [dbo].[tbl1] WIT...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Exec a SP as a sub-query ?? Posted by Steve Cutting at 9/19/2004 2:09:14 PM Hi all,
Is it possible to include a SP call as a sub-query in a SELECT statement ??
ie somthing like...
SELECT itemID FROM Products
WHERE itemtype = 'cheese'
AND itemID IN (EXEC sp_FindStuff)
assuming sp_FindStuff just contains as SELECT which returns a list
of itemID's
The above do...more >>
Second opinion for a query Posted by Steve Lewis - Website Nation at 9/19/2004 2:08:56 AM I wanted to get a second opinion on this:
I have 2 tables tblMembers and tblImages (One to Many Relationship)
I would like to create a a recordset that includes only the image if
[Approved] = "Yes" and [ImageDisplay] = "Thumbnail". But I also need to
display the records that do not have im...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |