Hi Yelena,

There is nothing that you have missed something or you need to do something. I hope the following explanation is good enough for you question.

Current Senario:

When you fisrt send...

Hi Yelena,

The ALTER DATABASE did work on the Northwind database which I restored from SQL Server 2000. My SQL Server 2005 is update with SP1.

Can you provide inputs on the...

True. But for now

Chris, Tinker thanks for valuable inputs, I would have done the same you mentioned, but I'm a sql developer

Btw, I'll also add that there...

Chris, you are right in you assumption, what I have is a master lookup with approx 175 keys and approx 3000 records. The Id, which is an identity field, is being referenced...

In such a case, I always use the 1st approach. You can also use COALESCE(...) which returns the first non-null expression instead of IsNull(...)

It is definitely better than using the...

convert the datatype to text of the column in the select statement.

might be not the best of the solutions

hth...

Makes a lot of sense

I would suggest UNION ALL instead of just UNION

You can also try this one...

DateDiff(Day, cast(cast(NEXT_RUN_DATE as varchar(8)) as datetime), getdate()) as Days

and

DateDiff(hour,getdate(), cast(cast(NEXT_RUN_DATE as varchar(8)) as datetime) + cast(reverse(stuff(stuff(reverse(cast(NEXT_RUN_TIME as varchar(6))), 3, 0, ':'), 6, 0, ':'))...

Check the defragmentation of the table using of DBCC SHOWCONTIG.

In Scan Density [Best Count:Actual Count], Best Count and Actual count should be almost equal...

HTH...

SELECT 

  b.database_name As DBName,

  MAX(CASE b.type WHEN 'D' THEN b.backup_finish_date ELSE NULL END)  D_Backup ,

  MAX(CASE b.type WHEN 'I' THEN b.backup_finish_date ELSE NULL END) I_Backup ,

  MAX(CASE b.type WHEN...

ok...was thinking of a solution to this on my way back to home yesterday...

how abut this...

have 2 fields that will store the total of ASCII values of small alphabetes and...

ALTER TABLE Xtable ADD Xcolumn int NOT NULL DEFAULT (0) WITH VALUES

HTH

Sachin

Hi Frank,

I feel usernames should not be case-sensitive...

Not a solution, just my opinion

Sachin