Viewing 15 posts - 31,111 through 31,125 (of 39,754 total)
Implicit conversions are sometimes funny. I'm sure someone knows what rules apply, but I've been caught by this before.
I think it's a design decision that you have to pick one...
October 5, 2007 at 9:06 am
October 5, 2007 at 9:04 am
The VM idea is very cool. That's if you have the space for a VM of this size. If you have 100GB of data, not sure you'd do this.
I'd take...
October 5, 2007 at 9:03 am
You moving all data or selected sets?
For client side, I assume you mean some database at the client's site and not client machines?
October 5, 2007 at 8:57 am
Another alternative is SQL Server Compact Edition, which is just a file and then a .DLL you add to your application. The "server" essentially is just an inprocess thread for...
October 5, 2007 at 8:52 am
I'm curious as to how you're doing the count(). Is it based on this bit column?
The reason I ask is that a select count(*) should complete very quickly, even...
October 5, 2007 at 8:42 am
Not sure I agree 1GB is too little RAM. I've run small servers on it fine. However more is definitely better.
I do think you want to do some comprehensive analysis...
October 5, 2007 at 8:37 am
SS2K8 will "launch" in Feb with Windows 2008 and VS2008. However I'm hearing Q2 for the actual bits to RTM. My guess is we'll see the bits at TechEd, first...
October 5, 2007 at 7:48 am
I'm not a MetaFrame expert, been years since I worked with one. However moving a data store should be no different than with any app.
The thing you'll want to do...
October 5, 2007 at 7:45 am
Nice to see I'm not the only one having issues with estimates. Todd has a nice comment above and I tend to agree with it. With small changes, the overhead...
October 5, 2007 at 7:36 am
Aside from what John said, can you better explain what is inserted into each table and when? (order). Also, what relationships you have?
Typically you insert into the parent tables. Then...
October 4, 2007 at 4:31 pm
Be careful with switching modes. Don't want to mess up your backup chain.
October 4, 2007 at 4:20 pm
Never heard it called an asynchronous trigger, and don't think it should be. We have enough triggers now!
But that is what it does and I agree this is a great...
October 4, 2007 at 4:02 pm
Let's hope so! No one upgrade to 2005 if you don't need it. Wait for 2008!
October 4, 2007 at 8:55 am
You are welcome and please feel free to ask more questions.
October 4, 2007 at 8:48 am
Viewing 15 posts - 31,111 through 31,125 (of 39,754 total)