Although the least cost can be determined with the CASE statement, since there are nulls and the least cost algorithm must handle nulls, the case statement would be very complicated....

"but without luck" is a rather general statement. What is the error number and error message which is being returned ?

Do you mean that the other tables look like:

Create table Table2

( pkey1 integer not null

, typeid1 integer not null

, value varchar(255) not null

, constraint Table2_PK...

The sp_cursoropen and sp_cursorfetch are stored procedures are used by the Microsoft OLE DB Provider for SQL Server, the SQL Server ODBC driver, and the DB-Library dynamic-link library (DLL) to...

"When I was reading the database book by Elmasri, I learnt that B+ Tree indexes at their leaf level have a set of key values along with data pointers pointing...

Has anyone had success with alert forwarding to the MSX/TSX server ?

I have set this up 3 times, it works for a while and then the alerts will not forward...

"The entire result set is built in the specified order and the top n rows in the ordered result set are returned.

Does anyone disagree?"

Well possibly but I need to run...

"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)" can mean anything from I/O error, out of disk space, or trying to backup a database that is not available (dropped, offline or suspect)

Using...

By "relationships", do you mean foreign key constraints ?

If so, then not with SQL Server.

SQLAnywhere does do special indexing when a foreign key constraint is defined. The special indexing...

By Pivot, do you mean turning columns into rows such as:

select c1, c2

, MAX(case PivotColumn when 'x' then Value else null end) as X_Value

, MAX(case PivotColumn when 'Y' then Value...

OPINION:

If you are calling a COM object from TSQL, then you have the WRONG solution to the problem.

The only usefull COM object that have I seen is to write to...

There is an undocumented DBCC command but I do not think you will not find the output very usefull.

DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )

PARAMETERS:

Dbid or...

"but now I'm faced with a design question....to either normalize to save null values or to have more fields and cut down on table outer joins"

For flexibility, a view...

The amount of space used for a fixed length datatype, such as integer or char(?), is the same amount of space whether it is null or not null. See...

I have had about 60 Servers managed from a single MSX server. The jobs included database maintenance and application jobs.

As there were 2 sites (Chicago and LA) and the...