Viewing 15 posts - 37,276 through 37,290 (of 39,461 total)
It could be. The instances will be competing for the memory on the server. Can you set both servers to use the same amount of memory and see what happens?
Steve...
June 26, 2002 at 9:22 am
I agree. you should have some primary key. You can make it non-clustered (recommended).
Steve Jones
June 25, 2002 at 5:42 pm
no cursors needed.
Use an UPDATE to update data.
update realtable
set cola = b.cola
, colb = b.colb
...
from temptable b
where...
June 25, 2002 at 5:36 pm
Curious, why does it help with Vendors? I can understand separateing the security environments, and it might be useful for applications like Great Plains which have hardcoded database names.
Steve Jones
June 25, 2002 at 5:28 pm
Totally agree on the SQL Logins. What about locking the account after 3 failed attempts!!!
Feel free to submit these to sqlwish@microsoft.com. It goes to the dev team.
Steve Jones
June 25, 2002 at 3:20 pm
It sounds like a security issue. Is the server running as local system? Or a lcoal account? Is it a local administrator.
Is this truly local or a virtual drive for...
June 25, 2002 at 3:18 pm
That will do it. In 7 you have this option, in 2000, this is "simple" mode.
Steve Jones
June 25, 2002 at 3:16 pm
You are welcome and looking forward to seeing you back here. Pls tell your friends and coworkers who use SQL Server
Steve Jones
June 25, 2002 at 3:14 pm
Haven't used them mainly because I haven't had any transactions that I use that fit.
If I did a specific update and was concerned about rolling back to that point, I...
June 25, 2002 at 3:12 pm
You could union these if you did not need the sums on the same row. If you do, then I would use each of these as a sub-select. that's the...
June 25, 2002 at 3:10 pm
Check the settings for the database. Is it in simple mode? Are non-logged operations being performed?
Steve Jones
June 25, 2002 at 2:37 pm
why use local variables? I do the same thing often, but it's something like:
UPDATE SSnumpin
SET PIN = b.PIN,
FirstTimeFlag = b.FirstTimeFlag,
CallCounter = b.CallCounter,
Lastname = b.LastName,
FirstName_MiddleInitial = b.FirstName_MiddleInitial,
EmpNum = b.EmpNum,
PINChangeFlag = b.PINChangeFlag
...
June 25, 2002 at 2:35 pm
Can you post some DDL to be sure we get this right?
I think you want a single result set, correct?
select sum(a.strCost)
sum( b.strAmount)
from tblItems a
inner join...
June 25, 2002 at 2:33 pm
You can use osql, just PRINT or SELECT your variable whenever you need output.
Steve Jones
June 25, 2002 at 2:30 pm
Dan has good suggestions. Another option is to enhance your app to lock the account after 3 tries. Can be painful, but most password systems (outside of SQL) do this...
June 25, 2002 at 2:28 pm
Viewing 15 posts - 37,276 through 37,290 (of 39,461 total)