Viewing 15 posts - 37,681 through 37,695 (of 39,757 total)
Haven't used it. Tested, but haven't found a good reason to do it. It's mainly for desktop installs (why it was developed). I tend to try to build things that...
June 14, 2002 at 12:20 pm
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
Viewing 15 posts - 37,681 through 37,695 (of 39,757 total)