All these messages are perfectly normal, and just reflect the fact that the database is being recovered and brought online.

A 'catalog'...

RBarryYoung (4/6/2010)

---

Tom.Thomson (4/6/2010)

---

I think I'll let Barry answer that...

Well it took me all of 15 seconds to Google it :doze:

He is being a...

Peter Brinkhaus (4/6/2010)

---

Unless I am missing something completely, it looks like the 'deterministic' function is just an identity function. Looks like 'SELECT @i = a FROM dbo.t ...' is a...

talktome_nani (4/6/2010)

---

Hi All

I want to load data from database(Adventureworks) to Datawarehouse(AdventureworksDw) and i should also build some reports on it

Can anyone tell me the procedure how to do that. I...

talktome_nani (4/6/2010)

---

yes sir. Actually i have to take a table from adventureworks and create staging tables for it and then load into adventureworksdw and also i should identify facts and...

USE tempdb;

GO

CREATE TABLE dbo.t (a INT NOT NULL) ;

GO

CREATE FUNCTION dbo.f (@i INT) RETURNS INT WITH SCHEMABINDING AS

BEGIN

...

If you mean the database log files (usually *.ldf) for the...

Worth doing, but the reason it is important here is that the sorting and comparison rules are very complex for...

Thank you, Carl.

As far as the actual requirement is concerned, concatenating RTF fragements (I'm not even going to ask why they are like that to start with) might be best...

lmu92 (4/6/2010)

---

@ Paul:

Interesting!

What do I misread/misunderstand when reading BOL?

I thought what you just demonstrated wouldn't be possible...

It looks like query optimizer is using ISNULL to override the columns NULL definition.

VERY...

Carl,

Two suggestions:

1. Define @SomeText AS VARCHAR(8000) instead of VARCHAR(MAX)

2. Use the LATIN1_GENERAL_BIN collation - and only on @SomeText, not the replace chars.

VARCHAR(MAX) variables require a tempdb worktable,...

lmu92 (4/6/2010)

---

I'd like to agree but it seems like that's not going to work here, since the OP used the ISNULL function to get a non-NULL result:

SET @Score = ISNULL(@Score,0)...

Yes. Log files are different from data files - there is no proportional-fill algorithm.

From Transaction...