Viewing 15 posts - 2,686 through 2,700 (of 6,216 total)
Havent considered solid state. We've been using a Dell 650 for..a year maybe, good performance, no issues. We're conservative about hardware, better to have too much than too little! I've...
January 15, 2003 at 6:29 am
January 14, 2003 at 7:20 pm
It's how you implement optimistic locking. ADO lets you control is via the something criteria property. One way is to just do update based on pkey, another is to include...
January 14, 2003 at 7:18 pm
Lee, go for it anyway. You've got some good info to distribute! Lots of places where the tools dont work so good. In my case its 250 db's, things like...
January 14, 2003 at 7:17 pm
Nope, English is my first and only language. Well, I speak geek a little. We're pretty informal here, though we do try to get the spelling correct. We (Steve, Brian,...
January 14, 2003 at 7:01 am
Expert-sex-change? Sorry, couldnt help it!
Good comments.
Andy
January 14, 2003 at 5:04 am
January 13, 2003 at 9:14 pm
Thanks. We actually sat down today with our vendor to figure out what clustering will cost..another OUCH! I'll probably write up some info on that as well, amazing how quickly...
January 13, 2003 at 4:25 pm
Pretty interesting. Lee, any chance of you writing that up as an article and showing us the code too? Probably not many with that many tables, but for those who...
January 13, 2003 at 3:54 pm
I'd guess merge is more expensive because it adds trigggers everywhere. For transactional you just have the log reader running, 1-2m of memory, not a lot. Doesnt use much CPU....
January 13, 2003 at 2:23 pm
You can do ADO in a proc (I guess) using sp_oacreate, but its a lot of work, more than its worth if you ask me. I dont have a password...
January 12, 2003 at 8:27 pm
Sounds like G is not accessible from the server and/or with those permissions. If you've got xp_cmdshell access you can try doing a 'dir' to see. If that turns out...
January 12, 2003 at 5:22 pm
Scope_identity was created to fix that, the behavior of @@identity you're seeing is correct. Relying on the idents to stay the same is doomed, I'd look for another way!
Other than...
January 12, 2003 at 1:47 pm
The best way is use a stored proc, something like this:
create proc usp_InsertData @Somedata varchar(20), @ID int output as
set nocount on
insert into dbo.SomeTable (DataCol) values (@SomeData)
select @ID = Scope_Identity (or...
January 12, 2003 at 6:13 am
I dont know why they dont do it on system tables. I guess because they enforce it internally and dont want to risk having someone 'tune' it and break something...
January 11, 2003 at 8:03 pm
Viewing 15 posts - 2,686 through 2,700 (of 6,216 total)