I would recommend checking out "The Data Warehouse Toolkit" by Ralph Kimball, (published by Wiley). This is an excellent resource for best practices in data warehousing.

Also, dropping the keys may have been part of your speed problem. Depending on how the update query was written, it is likely that it would need at least the...

If you want to convert the varbinary data to a hexadecimal string (like how it gets displayed in Query Analyzer by default), you can use the built-in function master.dbo.fn_varbintohexstr(). I...

Quote:

quote:

---

---------------------------------------

DECLARE @State varchar(225)

SELECT @State = isnull(@State + ',', '') + State

FROM (SELECT DISTINCT State FROM authors) s

SELECT @State

-----------------------------------

Wow...this is really cool...no need...

Here's another solution using the CHECKSUM function.

--

-- Create a temp table variable for demonstration purposes.

--

declare @temp table

(

pk int identity primary key, --...

Here's an example of Access IIF translated to T-SQL CASE:

IIF(MyColumn = 'test val', 'return this', 'otherwise') 





CASE

WHEN MyColumn = 'test val' THEN 'return this'

WHEN MyColumn =...