Viewing 15 posts - 28,066 through 28,080 (of 39,769 total)
Check out xp_smtp from Gert Drapers. This might do what you need.
June 22, 2008 at 9:36 am
I thought I had read in a blog about changing this with newer servers that have multiple cores. There was some ratio of worker threads to cores that you could...
June 22, 2008 at 9:34 am
Hey, that's me. Missing the obvious, pointing out the obscure. 😉
June 22, 2008 at 9:19 am
The nice thing is that deprecated features last for a couple versions. DTS was announced as deprecation in 2005, it's stil there in 2008.
I'm not sure why features get deprecated....
June 22, 2008 at 9:18 am
You're welcome and glad you liked it.
Some great comments in here.
June 21, 2008 at 5:18 pm
Can you give an example, or a few? It's not clear what you mean.
You also might want to check out datepart, which can get you different parts of a date,...
June 21, 2008 at 5:18 pm
Also, dividing the database among servers might not work. It depends on your application.
You probably should hire a consultant to evaluate performance and help you improve the speed at which...
June 21, 2008 at 2:22 pm
Keep in mind if you did move to database snapshots that the snapshots are point in time and don't keep up with changes to the primary.
June 21, 2008 at 2:21 pm
It's possible that they are. the reason is that read aheads, scans of indexes or heaps, etc., don't take place in contiguous order, at least not outside 10MB. Any extents...
June 21, 2008 at 2:20 pm
Did you follow instructions here? http://support.microsoft.com/kb/224071
June 21, 2008 at 2:16 pm
Or you can store as varchar. Are these part numbers or something? If you don't do addition, or even if you do, I might store as character data.
June 21, 2008 at 2:15 pm
Is the user's login mapped correctly as well?
June 21, 2008 at 10:15 am
Read baarf and think about your environment. If you have lots of reads, I'd go with R1 or R10 for data, get the speed up there. You definitely want separate...
June 21, 2008 at 10:14 am
You can change it manually, it would take time, but it's probably the best way to do this. If it's not every table, and a common pattern, a script could...
June 21, 2008 at 10:11 am
Viewing 15 posts - 28,066 through 28,080 (of 39,769 total)