also, if you can, upgrade to at least SP1 ( current is SP1 CU4 )

both should work.

What's the version number of your SQLServer instance ?

select @@VERSION as SQLinstanceVersion

--or

Select Serverproperty('Edition') as Edition

, Serverproperty('ProductVersion') as ProductVersion

...

- is this a "one sproc serves all" kind of situation ? If so, Gail also posted suggestions on how to handle such cases.

My personal preference goes to a...

just to add to Toby's great summarized reply :

For more information on the Included columns topic ...

Have a look at "Create index "Create Index http://msdn.microsoft.com/en-us/library/ms188783%28v=sql.100%29.aspx%5DCreate Index

and Index with Included Columns...

btw Did you perform full maintenance after you upgraded this database to sql2008 ?

-- checkdb with content-re-eveluation

DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY; --http://support.microsoft.com/kb/923247 !!! and repair

+ including statistics update,...

You'll have to check the query qualifies with your original one ( check it with selecting the data of both sets and use the except operator to check for non-matching...

can you post SQL2008 version information (sp/cu/@@version + "max server memory" setting for that instance) ?

Gianluca Sartori (3/6/2012)

---

In my experience, DB2 on z/OS is often used without indexes and has "logical views" to...

Welsh Corgi (3/5/2012)

---

Thanks for the information.

I did not mention that this data is from a legacy DB2 Database that is hosted outside of the company and soon to go away.

None...

based on information_schema.columns you could get started using ...

WITH cteRecurse

AS (

...

strange way to sample column combinations like that to determine a primary key candidate.

IMO you could guess for a unique key column composition, to make it primary key (...

use datetime or date datatype whenever working with date information.

Then you can use a simple between (for date datatype) or <= and => (for datetime)

Here's another list of tips 40 QUICK TIPS FOR SPEAKERS[/url] which do make sense too.

-

This is what I use to get my inventory:

Declare @DbName sysname

Select @DbName = db_name()

--'DDBAStatistics'

declare @DbId int

Select @DbId = db_id(@DbName)

select @DbName as Requested_DbName

...