Viewing 15 posts - 11,176 through 11,190 (of 14,953 total)
Planning this kind of thing isn't an easy task.
Rather than worrying about a single database being a single-point-of-failure (where if it goes down, the whole thing is down), you need...
February 2, 2009 at 7:50 am
MSDN has whitepapers and articles on the differences. I'd look there.
Also has advice on how to best use the upgrade wizard.
February 2, 2009 at 7:46 am
If there are multiple rows with the same date-time in the MyDateColumn, the first query will only give you one of them, but the second query will give you all...
February 2, 2009 at 7:36 am
You know, somehow I thought I had tried those and they didn't get me what I wanted. I was wrong. They work. Thanks. 🙂
February 2, 2009 at 6:59 am
I'm not clear on why that one should not show. The prior steps have status 1 and the current step has status null. Per what I'm reading in...
January 30, 2009 at 2:30 pm
There are programs (like Satori Software's MailRoom Toolkit) that can parse out addresses for you, and verify their mailability at the same time.
There are also companies that can do that...
January 30, 2009 at 2:23 pm
My first instinct would be to start out with one table, for simplicity, and then evolve the design from there as you use it.
That way, you'll find how it actually...
January 30, 2009 at 11:09 am
The problem with login triggers is that, if anything gets messed up so that they error out, nobody will be able to log in to the server, including you. ...
January 30, 2009 at 11:04 am
Where the following date is 3 days later and is a Monday. Of course, that doesn't work for three-day weekends, etc., but it at least gets you the basic...
January 30, 2009 at 10:58 am
Why not do it as a five-layer join?
select *
from #tempsick t1
inner join #tempsick t2
on t1.employeeid = t2.employeeid
and t1.fromdate = t2.fromdate - 1
inner join #tempsick t3
...
January 30, 2009 at 9:45 am
DBMail is an asynchronous process. Having it in a trigger is unlikely to interfere with transactional completion. Failure to contact the e-mail server definitely does NOT interfere with...
January 30, 2009 at 9:11 am
From what Microsoft says about it, I'm not sure whether it will work with SQL 2005 or not. Your best bet would be to set up a virtual machine,...
January 30, 2009 at 9:05 am
Have you tried NVarchar(max)?
January 30, 2009 at 9:01 am
You have a permissions issue is all. You need to set up User to have datareader rights, and to have Execute rights on the select procs.
I've gotten good use...
January 30, 2009 at 8:58 am
Oh, and another good one from this year, Changeling (Angelina Jolie, directed by Clint Eastwood). Very good. Not a kid movie.
Wanted (Angelina Jolie, Morgan Freeman) was quite a...
January 30, 2009 at 8:53 am
Viewing 15 posts - 11,176 through 11,190 (of 14,953 total)