Viewing 15 posts - 37,441 through 37,455 (of 39,511 total)
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
June 12, 2002 at 8:17 am
What do you mean by architecture? The way the server is built and coded itself? Why it makes decisions?
Steve Jones
June 12, 2002 at 8:12 am
June 10, 2002 at 5:19 pm
If all your users have SQL accounts (based on NT accounts), then you should be able to auth them in IIS (be sure this is set) and then their user...
June 10, 2002 at 5:18 pm
June 10, 2002 at 5:04 pm
Viewing 15 posts - 37,441 through 37,455 (of 39,511 total)