Viewing 15 posts - 37,051 through 37,065 (of 39,818 total)
Not sure. We are still researching this with McAfee.
Steve Jones
October 14, 2002 at 2:47 pm
Not sure. It might using the TOP. I avoid the exists because select count(*) tends to go after a single row in sysindexes if there is a clustered index rather...
October 14, 2002 at 2:47 pm
Keep in mind, crdate doesn't change unless there is a create involved. If an alter table is used, then no crdate change is made.
Steve Jones
October 14, 2002 at 10:51 am
I think it can be a reason not to use the identity. What if you were importing 3B rows a day? Or a week, it might be a reason to...
October 14, 2002 at 10:13 am
Probably worth an article to discuss these, and I'd welcome feedback on what people think, but here's our issue.
We backup nearly 1TB a day of changed information. So our backups...
October 13, 2002 at 9:09 pm
That is what I thought. I was reviewing a setup for a client on SQL 7 and wanted to be sure.
My recomendation is to use scripts I've developed, but I...
October 11, 2002 at 10:32 am
Mine will delete everything less than tomorrow, which includes today's records.
I did misread. You'd want to delete everything less than today, so you can take
cast( month(getdate()) + '/' day(getdate())...
October 11, 2002 at 10:30 am
You'd need to develop a script that will write out the necessary parameters and build the mail from scratch. Or use an ActiveX type object. Persits software has a free...
October 11, 2002 at 9:57 am
You'd have to include in the where clause
where cola is not null
and colb is not null
...
Steve Jones
October 11, 2002 at 9:34 am
use coldate < dateadd('d', 1, getdate())
Steve Jones
October 11, 2002 at 9:30 am
I agree that a password should be created. We delete sa? Doesn't make sense.
Steve Jones
October 11, 2002 at 9:20 am
Antares has the best solution.
Steve Jones
October 10, 2002 at 6:31 pm
Of every word? If the first word, use substring and upper() and lower()
select upper(substring(col,1,1)) + substring( col,2)
Steve Jones
October 10, 2002 at 6:29 pm
I think it will be enough. Nice to know the others, but not necessily needed. Last I saw, Yukon wasn't completely set, so not sure how much .NET will be...
October 10, 2002 at 6:28 pm
DTS can do this. Bulk Copy can, but you'd probably want to do a DOS find and get the lines you need into a separate table.
Or load hte whole thing...
October 10, 2002 at 12:36 pm
Viewing 15 posts - 37,051 through 37,065 (of 39,818 total)