Viewing 15 posts - 166 through 180 (of 429 total)
Grant Fritchey (12/11/2007)
December 11, 2007 at 9:22 am
this:
FROM ml where ((ml.conta not like '243%' or ml.conta not like '22%') and (ml.conta between '21101' and '26901'))
should be this:
FROM ml where ((ml.conta not like '243%' and ml.conta not like...
December 10, 2007 at 10:00 pm
"business rules dictating triggers firing off emails"
isn't firing off an email for every transaction a core part of being ACID?
🙂
December 10, 2007 at 9:55 pm
I wrote a console app to do exactly this. it's open source also.
December 10, 2007 at 9:40 pm
you can just use 3 part naming if the db is on the same server:
exec OtherDB.dbo.ProcName @myparam=1234
December 8, 2007 at 10:15 pm
Gift Peddie (10/18/2007)
jezemine (10/17/2007)
Derek Karpinski (10/17/2007)
You can't have memory leaks in pure managed code. But you can if you involve components that have unmanaged components.
you can certainly have resource...
October 18, 2007 at 4:37 pm
Derek Karpinski (10/18/2007)
I'd respectivally submit that nocount be set to on, and that all selects have nolock hinting...
uh, no. using NOLOCK by default is not a good habit to...
October 18, 2007 at 9:50 am
Derek Karpinski (10/17/2007)
OK, fair one..In the real world though it's too much to ask that Idisosable is called every time....
I understand it's a pain to have to call Dispose,...
October 17, 2007 at 10:23 am
Derek Karpinski (10/17/2007)
You can't have memory leaks in pure managed code. But you can if you involve components that have unmanaged components.
you can certainly have resource leaks in managed...
October 17, 2007 at 8:15 am
Jeff Moden (10/14/2007)
Not quite true... Much like an extended stored procedure, a CLR is precompiled and not changeable from SQL. Since it is precompiled, it can be set to...
October 14, 2007 at 11:46 am
Jeff Moden (10/13/2007)
October 13, 2007 at 10:19 pm
rudy komacsar (10/11/2007)
October 12, 2007 at 2:23 pm
I wrote a documenter that will do this for you also - see link in my sig.
October 5, 2007 at 7:48 am
it's extremely annoying to not be able to see the post you are replying to - in fact I think there ought to be a "quick reply" textarea on each...
September 22, 2007 at 5:20 pm
Gift: not sure why you posted those links, none of them really show you how to use sqlcmd or osql...
anyway, the best reference in all things related to SQL Server...
July 26, 2007 at 10:43 pm
Viewing 15 posts - 166 through 180 (of 429 total)