So you've set 'auto create statistics' to on, so the statistics are being created on the fly as needed. You believe the auto-creation is slowing queries down when it...

CREATE FUNCTION dbo.ListB(@Fid int)

RETURNS varchar(8000) BEGIN

DECLARE @List varchar(8000)

SELECT @List = ISNULL(@List + ',','') + Value

FROM B

WHERE FID = @Fid

ORDER BY RowID -- or Value? Can't tell...

--Jonathan

Edited by - Jonathan on 11/21/2003 2:39:50 PM

Backup the log and then use

ALTER DATABASE <dbname> REMOVE FILE <logical file name>

--Jonathan

Why not just run sp_createstats on the database after it's built? Statistics will not change unless the data changes, and this is a data warehouse so the data is...

With the same number of drives in each configuration, direct attached storage with separate controllers will perform better and cost less.

If this is a true read-only data warehouse,...

I now suspect you're writing about the logical file name. It's very confusing to have used logical names like "ABC_Data.mdf", so please forgive me for my assumption.

Use ALTER DATABASE...

Don't see a way to change that setting by default. You could log in as a user with circumscribed permissions in the target database.

--Jonathan

SET Col = STUFF(Col,CHARINDEX('-',Col)+2,CHARINDEX(' ',REVERSE(Col))-1,RIGHT(Col,CHARINDEX(' ',REVERSE(Col)))+1)

WHERE LEFT(Col,1) = 'F' AND ISNUMERIC(RIGHT(Col,1)) = 1

--Jonathan

The error is too severe to allow the batch to continue, so you are erroring out of the process before your error handling statements. Perhaps you could use something...

Get the logical filenames by running

RESTORE FILELISTONLY FROM...

Then restore those logical files to new physical files, e.g.:

RESTORE DATABASE XYZ

FROM DISK = 'e:\mssql\backup\abc.bak'

WITH...

What is in the error log after you get the 3201 error?

--Jonathan

quote:

---

quote:

---

I've never seen an example where a UDF performs better than internal functions. ...

quote:

---

Yes, that does the same thing. Mine has granularity out to the MS, but I haven't needed it. Yours is...

quote:

---

I wanted something to call to set memory variables, instead of retyping the same code every time.

I set it up...