Viewing 15 posts - 1 through 15 (of 23 total)
Yeah, that was the kind of thing that I was looking for.
I understand the comments regarding WHERE IN() being a crutch for beginners. On the other hand I think an...
December 17, 2004 at 1:11 pm
All ... thanks for the replies!
For the most part, the warnings everyone has given are things I am well aware of (Andy's reminder about returning NULL, etc.), and we honestly...
December 16, 2004 at 7:47 am
quote:
NO! They have taught me that the OO and hierarchical DB proponents have one thing in common; a sad lack of...
October 7, 2003 at 1:54 pm
The other performance consideration, in addition to the efficiency of table scans as mentioned, is your cache hit ratio and I/0. More rows to a page, more rows potentially in...
June 25, 2003 at 9:07 am
Finally, to answer my question one last time!
In the MSDN Online library this note is given on the subject of deferred name resolution:
quote:
November 6, 2002 at 1:39 pm
paul: thanks for the link ... but I don't think it's that.
Andy's problem was undoubtedly related to something in the ADO/OLE DB layers he was using.
The problem I described is...
November 6, 2002 at 1:20 pm
Just to followup, the following code works:
CREATE PROC usp_test
AS
select *,'x' as mycolumn
into #test_temp
from authors;
alter table #test_temp alter column mycolumn varchar(50) null;
update #test_temp set mycolumn = 'hello';--line 10
select * from...
November 6, 2002 at 12:03 pm
Interesting article, I recently had a "show-stopping" application bug that traced back to this setting (in combination with other factors). In my research in BOL, I don't think I found...
July 8, 2002 at 9:40 am
Typist ...
Was a required course for two years as a CAD major in Technical School. Hated every minute of it back then, but I'm very glad now that I learned...
May 9, 2002 at 8:10 am
Argyle,
While your method will prevent casual poking around in the database, any Domain Admin could easily get into the MSSQL\ directories, even change the PWD for your emergency account to...
March 26, 2002 at 2:10 pm
VB and VBScript (ASP) with ADO, occasionally Access, MS FoxPro, and some C/C++ (mostly just for processing raw data files prior to BCP.)
Playing with VB.NET and C#.
Not pure MS, since...
March 26, 2002 at 1:54 pm
kstefan:
Here is an article on MSDN that I found extremely helpful.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlsm/html/oracle2sql.asp
It was pretty good at clearing up questions like are SQL DB's Schemas or DBs in Oracle. (The...
March 26, 2002 at 1:45 pm
Ahhhh ... life is good.
Everything is back up, all just fine.
Yikes, did my heart skip a beat though when the systems guy came up to me last night and...
February 19, 2002 at 8:45 am
Thanks guys,
Yeah, I just panicked a little (didn't want to be here all night).
So far it just appears to an NT glitch - someone gave a new workstation the same...
February 19, 2002 at 7:03 am
Hey all -
there is a similar question here :
http://www.sqlsecurity.com/mb/view_message.asp?message_id=70
I'll keep my eye on that too and post any links info that turn up.
JasonL
February 15, 2002 at 9:03 am
Viewing 15 posts - 1 through 15 (of 23 total)