This may seem easy, but is rife with potential problems. My last name is two words...

If all your data is indeed three strings delimited by single spaces, you could...

I didn't see anything wrong with your methodology (other than your model database apparently not being set to the Full recovery model), so I ran your script and it worked...

That sounds very normal for a DB server that is bottlenecked on its processor(s), which is not a bad place to bottleneck. If you want to bottleneck somewhere else,...

INSERT INTO tblProduct (productId, productCatId)

SELECT @productId, prodCatId

FROM tblProductCategory

WHERE columNameValue = @columNameValue

--Jonathan

INSERT #List

EXEC('RESTORE FILELISTONLY FROM DISK = ''c:\temp\FlexKIDS''')

I suggest using the bigint data type for the size columns.

--Jonathan

quote:

---

I perfer to break the huge update into small batches as Guarddata recommedned.

---

Last time I...

quote:

---

In the process of upgrading to a bigger machine, we are takening the RAID 5 (4 x 36GB) and RAID 1 (2...

quote:

---

It's actually a business process that is mandating this, I'm aggregating the 25 million down to 1.8 or so million, and the...

Where did you get the size from? If you're not using sp_spaceused, try that. The number you wrote is actually close to a terabyte; do you have that...

sp_helpdb

Or

SELECT name, sid, SUSER_SNAME(sid)

FROM master..sysdatabases

--Jonathan

OBJECT_NAME(@@PROCID)

--Jonathan

quote:

---

Your answer I knew, but BOL say we can separate clustered index and table to different filegroup, how's base table how separate,...

How about just something like this?

CREATE PROC DelimitedList

(@Table sysname, @Col sysname, @Del char, @Ord sysname = NULL) AS

SET NOCOUNT ON

SET CONCAT_NULL_YIELDS_NULL ON

DECLARE @sql nvarchar(500), @List varchar(8000)

SELECT...

No need for cursors if I understand the problem.

SELECT Currency, Value, Start_Date,

(SELECT MIN(Start_Date) - 1

 FROM Csv

 WHERE Currency = c.Currency

  AND Start_Date > c.Start_Date)...

quote:

---

Hi!

I have information about table location in theses variables:

@server_name, @db_name & @table_name,

that I fetch from this cursor.

I need to execute sp_helprotect and...