Viewing 15 posts - 691 through 705 (of 1,132 total)
There are quite a few fixes for indicies on columns with a datatype of bit.
Do you have Service Pack 4 installed ?
February 14, 2007 at 9:48 am
As all select statements return a relation and anywhere that a table, which is a relation that has physical existance,...
February 13, 2007 at 6:01 pm
"So it took 354 seconds for the user 'webuser' to log out of the SQL Server? That doesn't sound right, does it?"
No, the duration column indicates that time length of...
February 13, 2007 at 2:18 pm
SQLServerCentral is only for Microsoft SQL Server but you are connecting to an Oracle database!
You are also using the function "to_date", which is proprietary to Oracle and has a different...
February 12, 2007 at 7:08 pm
There are conflicting KBs for the non-buffer pool memory which results in confusion for DBAs and PSS.
In my case, as the SQL Server was hanging every few...
February 12, 2007 at 6:59 pm
Yes, with SQL Server 2000 where a single instance has over 4,000 user databases.
Solution was to add "-g392" to the startup parameters and then restart SQL Server.
See http://support.microsoft.com/kb/316749
"There may not...
February 12, 2007 at 5:57 pm
Here is another solution that might use less resources:
select new.PartTypeNum
, new.PartNum
from new
union all
select old.PartTypeNum
, old.PartNum
from old
where not exists
(select 1
from new
where...
February 11, 2007 at 6:49 pm
create table Merged ( PartTypeNum, PartNum)
go
insert into Merged ( PartTypeNum, PartNum)
select coalesce (new.PartTypeNum, old.PartTypeNum)
, colalesce (new.PartNum, old.PartNum)
from new
FULL OUTER JOIN old
on old.PartNum = new.PartNum
From SQL Server Books On Line
A...
February 11, 2007 at 10:49 am
This message may have an underlying cause of logical memory corruption but not neccesarily any physical corruption. Hence, checkb will show no error as it checks the physical storage.
If...
February 8, 2007 at 6:40 am
"I believe it is best to have frequently searched fields of a static size early in the table therefore I want to move these fields to closer to the start...
February 8, 2007 at 6:22 am
Error trapping in SQL Server 2000 works on a hit and miss basis and what works with one Service Pack does not work with another. See Erland Sommarskog's home page...
February 6, 2007 at 5:40 pm
Frequent Question - see "How do I concatenate strings from a column into a single row?"
February 4, 2007 at 1:03 pm
With 10,000 RPM RAID 5 drives, yes, this will run for a very long time. Do not be suprised if the run time exceeds 40 hours.
Recommend:
15K RPM...
February 4, 2007 at 6:25 am
A word of caution regarding clusters as they can create more problems than they solve.
Some cases in point:
a) I am on call this week and between Saturday at 9...
February 4, 2007 at 6:12 am
If you are using Enterprise Manger to generate the SQL script, there are some options on the Format tab that may need to be enabled. Try the "Include extended...
February 3, 2007 at 9:13 am
Viewing 15 posts - 691 through 705 (of 1,132 total)