Viewing 15 posts - 37,381 through 37,395 (of 39,456 total)
Yes, when the SELECT is finished, the shared lock should drop.
IS this not happening? Can you provide more details about what is happening?
Steve Jones
June 14, 2002 at 12:18 pm
Don't have the setup, but there should be no issue as long as your PC has the horsepower. I run (and have run) both 7 and 2000 personal editions and...
June 14, 2002 at 12:17 pm
When you SELECT (without a hint), as Antares mentioned, a shared lock is placed on the data. The lock could be row, page, or table (or others), but basically prvents...
June 14, 2002 at 12:10 pm
Logins are stored in master with a SID. Users are stored in teh db and map back to a login. If you restore the db, the logins are not created...
June 13, 2002 at 4:21 pm
The order is:
1. write the changes to the log
2. Write the changes to the data
if the server shuts down between 1 and 2, then
a. commited transactions (as marked in the...
June 13, 2002 at 4:18 pm
I tend to use drop/create so I can track when a procedure is changed. I do include the security statements in the drop/create script.
If you use alter, you will not...
June 13, 2002 at 4:17 pm
June 13, 2002 at 2:20 pm
You could use the Dynamic Properties task to read in the values and alter the SQL statement. Would get ugly. I'd probably use an Active X Task instead.
Steve Jones
June 13, 2002 at 2:16 pm
creating a clustered index or changing the schema will also lock the table.
Steve Jones
June 13, 2002 at 2:15 pm
I think you may want to use a cursor here where you get the data and then grab a couple items only. Downside is there could be a large result...
June 13, 2002 at 2:02 pm
There are articles here on this subject that you can read. Also, there is a pretty good book on Tuning SQL Server databases.
Be sure to check out the MS White...
June 13, 2002 at 12:33 pm
Thanks for the tip. I will check this out.
Would you want to submit this as an FAQ?
Steve Jones
June 13, 2002 at 12:32 pm
Not that I know of. My guess is that SQL maintains a "needed" amount and then keeps anything allocated above that until another process asks for it.
Can you try...
June 13, 2002 at 12:30 pm
A great idea. I like it and would be interested to see what others have learned. I have a couple MS contacts, but usually get no answers because of NDA.
Steve...
June 13, 2002 at 12:29 pm
You could write an Active X task to do this. Using the FileSystemObject, you can read a line and write a line. If one is blank, then don't write it.
Steve...
June 12, 2002 at 9:07 am
Viewing 15 posts - 37,381 through 37,395 (of 39,456 total)