Viewing 15 posts - 691 through 705 (of 1,131 total)
As all select statements return a relation and anywhere that a table, which is a relation that has physical existance,...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
February 6, 2007 at 5:40 pm
Frequent Question - see "How do I concatenate strings from a column into a single row?"
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
February 3, 2007 at 9:13 am
There a many cases where a simple 'sp_spaceused' will not return current space utilization and the information is out of date and this behavior is documented in BOL.
To get absolutely...
SQL = Scarcely Qualifies as a Language
February 3, 2007 at 9:04 am
Viewing 15 posts - 691 through 705 (of 1,131 total)