Viewing 15 posts - 16 through 30 (of 78 total)
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...
May 10, 2006 at 1:51 am
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...
May 9, 2006 at 4:37 am
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...
May 27, 2005 at 7:44 am
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...
May 24, 2005 at 5:08 am
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...
September 22, 2004 at 5:17 am
convert the datatype to text of the column in the select statement.
might be not the best of the solutions
hth...
September 22, 2004 at 5:07 am
I would suggest UNION ALL instead of just UNION
June 4, 2004 at 12:03 am
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, ':'))...
May 24, 2004 at 5:59 am
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...
May 20, 2004 at 6:57 am
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...
May 13, 2004 at 3:46 am
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...
January 20, 2004 at 1:37 am
ALTER TABLE Xtable ADD Xcolumn int NOT NULL DEFAULT (0) WITH VALUES
HTH
Sachin
January 19, 2004 at 6:05 am
Hi Frank,
I feel usernames should not be case-sensitive...
Not a solution, just my opinion
Sachin
January 19, 2004 at 5:57 am
Viewing 15 posts - 16 through 30 (of 78 total)