hi!

right-click on "my computer", select "properties", select "advanced" tab, click on "performance options". to change size and location of your pagefile(s) click on "Change ...".

be aware that on any changes...

hi!

if this cannot be achieved in another way, use the "old" approach, namely a trigger. for just inserts in your case you'd use something like that:

create trigger trig_name for insert...

hi!

what do you mean by "the data is the same"? are you using a primary key? if not, i'd strongly suggest you think about creating a pk. if the problem...

important: use current db libs for client access, otherwise you won't be able to access other than default instance (seen on crystal reports). more general: check if your client side...

Hi!

The "SELECT *" topic gets interesting when working on the client side. Eg. using ADO and doing a "SELECT *" rather than doing a "SELECT fld, fld, fld, ..." will...

if you want to keep it simple, and take care of cleaning up yourself, you could just define and set a global variable in your stored proc, check the value...

hi!

concerning own scripts, you could maybe use the following as a starting point:

http://www.sqlservercentral.com/scripts/contributions/246.asp

best regards,

chris.

quote:

---

Couldn't I use MD5?

Has anyone of you done this?

I know I can use md5, but can you decrypt

202cb962ac59075b964b07152d234b70 back to...

hi all!

hey steve! may your site is more valuable than you know, because there's been something called xp_msmq.dll up for a couple of months already, it's been working perfectly for...

hi!

sorry, but why *the hell* would you want to do that. i'd understand if the ASP page you'd have to call cannot be maintained by yourself, but if you've access...

hi!

nyulg is absolutely right! i'm from austria (hi neighbor!), we've at least some "special" characters as well, not using unicode anyway. To my experience, as long as you stay with...

hi!

depending on how "clean" your SMB network is set up, we've found TCP/IP more efficient when it comes to network resources, means, whenever possible we use TCP/IP to avoid all...

hi!

as long as you're not afraid from playing around with T-SQL scripts and generating SQL from there, you could use the following as a basis for recreating normal indexes (with...

hi!

oh no - internationalization! don't worry, windows does it for you, and thats not a joke. you can simply test this: switch to eg. germany in your client pc's regional...

hi guys!

concerning: "outer-joins w/is null" vs. "not in" - to my experience if you've got larger tables the performance of the outer-join w/is null soluting significantly degrades compared to the...