Viewing 15 posts - 34,651 through 34,665 (of 39,793 total)
As far as that setting, you'd need to do some testing to see what works better with your system. I'd test the performance of some procs with the settings at...
September 3, 2004 at 12:02 pm
create view myview as select field1 from tableA
September 3, 2004 at 12:00 pm
I assume you're using Text for the notes and some type of character field for the chapter.
If this is in Word, either write some parsing routine in VBScript/Vb.NET, C#, etc....
September 1, 2004 at 2:25 pm
I think it's a wash as well, but you could argue that they do go in two different fields because you want to require them. The time wouldn't be required...
September 1, 2004 at 2:24 pm
I tend to work as Patrick above, but if there is a shared server, usually developers don't have rights. Not to be a pain, but keep track of what's changed...
September 1, 2004 at 12:43 pm
I do not believe that info messages are sent with this command. I tend to issue the shrink in small chunks in case I need to cancel it.
September 1, 2004 at 10:52 am
This could be the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;271223
Do you now have the ldf? Did you detach the db?
You can also try this: http://eai.ittoolbox.com/groups/groups.asp?v=SQL-SERVER-L&i=424438
August 31, 2004 at 9:58 am
I'd do a backup and restore to test. Then when you have it down, logins moved (search sp_help_revlogin), then do a full backup on source and move to produciton. Then...
August 31, 2004 at 9:53 am
As SQL needs memory, it will request more memory from the OS. You can use Enterprise Manager | Server | Properties | Memory tab and you can limit the maximum...
August 31, 2004 at 9:29 am
Been backing up for 10 years and never stopped a database for a backup yet. Restores work without a flaw.
August 31, 2004 at 9:24 am
The memory is released, but the caching might be affected. This will balance out as other queries are called. Right now I do not believe there is anyway to affect...
August 31, 2004 at 7:55 am
Yeah, I got one ![]()
The close wording is intentional. A view having 2 tables does not necessarily impact the ability to update. It could...
August 31, 2004 at 7:45 am
I completely agree with the business problem, which was why I provided a couple examples. If I have an OLTP system taking orders and one transaction, not one row, one...
August 30, 2004 at 12:36 pm
Good suggestion. The question has been edited to reflect SQL 2000.
August 30, 2004 at 12:05 pm
I'd start by listing the objects that you think you need to store. You need a customer, you need some type of rental agreement, some inventory, some cost structure.
If the...
August 28, 2004 at 3:25 pm
Viewing 15 posts - 34,651 through 34,665 (of 39,793 total)