I would say that the fastest way to grow would be to work on many different projects as either a dba or developer. Nothing surpasses experience. You also have to understand failure. Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-11-25
Hi Steve, I just spoke to the systems administrator and he failed to install SP3. Thanks for your help, Pete
2003-11-24
This is the message i got...Does this mean i need to install service pack 4.0? Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 5)
2003-11-24
2 reads
Sysdepends ends up not being very reliable. Plus, it has no concept of cross db dependencies, so you end up keeping track manually anyway. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-21
Your query will result in null because you have not initialized @mail, use set @mail = '' or simply do this set @mail = '' select @mail = @mail + email + ';' from reps where dateterminated is null and (datediff(dd,eoexpirationdate, getdate()) > 90) Edited by - davidburrows on 11/14/2003 07:07:55 AM
2003-11-14
This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample? quote: Table data type can't be used as a parameter in stored procedures! you will have to create a loop to cyle through the table to either send an […]
2003-11-13
In SQL7 DTS, if you use a test file with the maximum number of columns and define the properties of the file, then when you use real data file, sql will import the data irrespective of the number of columns specified (as long as each line is terminated correctly) and will insert null where no […]
2003-11-13
Thanks F... I wonder why the different syntax between LIKE and CONTAINS. I guess LIKE is older and may eventually be replaced by CONTAINS in all searches - Full Text or not ? Regardless - thanks - answered my question to a T! - B
2003-11-12
1 reads
himan0110, I'm not quite with you ... Let's try it with an example. say: 1 row = 1000 bytes insert into ADStable select * from ODStable1 a where exists (select PK from ODStable2 b where a.PK = b.PK and b.a_key_field='SOMETHING') (b.a_key_field='SOMETHING' is less then 5% of the rows, so no table scan) both ODStables have […]
2003-08-25
1 reads
Find out from your system or mail administrators the name (or IP address) of your SMTP server. If you're going to use SQLMail, read through this Knowledge Base article, as it presents a reasonable coverage of how to setup SQLMail: http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556 If you're going to use SMTP without using SQLMail and you want to mail […]
2003-08-24
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers