Viewing 15 posts - 4,696 through 4,710 (of 7,429 total)
Hey Jonny, please post this as a FAQ for future reference, or if you have time to ellaborate on do an Article. This information will be quite usefull and may...
October 10, 2002 at 4:42 am
Can someone post the points made here, my company blocks that address at out firewall.
I will say though that Oracle and MS SQL both have there respective places in the...
October 10, 2002 at 4:38 am
sp_updatestats can improve performance especially as the database gets larger. This is the same thing as having Auot Update Stats turn on for the database. However, Auto Update Stats does...
October 10, 2002 at 4:29 am
Can you do a print screen on your properties in EM for the linked server? All three tabs and post them somewhere we can look at. Also, when the problem...
October 10, 2002 at 4:23 am
What type of trust is in place one way from domain 1 o domain 2, one way from domain 2 to domain 1, or two way? What error message are...
October 10, 2002 at 4:17 am
Doesn't apply for you situation, that as I said was a shot in the dark. You are headed somewhere else. I will have to think the logic out as I...
October 10, 2002 at 4:15 am
20 MB availble overall is not that bad unless that us totoal for server and not just physical. Keep in mind you also have you swap file which should be...
October 10, 2002 at 4:03 am
To the best of my knowledge the answer is no you cannot customize it.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 10, 2002 at 3:55 am
If the box is under 2GB then you will not see a benefit with using the -g switch but the infomation is what applies.
October 10, 2002 at 3:48 am
Can you walk me thru you application and data model. Not sure what you are looking for.
Shot in the dark here.
You mention a queue which is where you new...
October 9, 2002 at 5:20 pm
Duplicate post, please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7333&FORUM_ID=5&CAT_ID=1&Topic_Title=Buffer+size&Forum_Title=Administration
Will a someone please remove.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 9, 2002 at 5:08 pm
Not sure what you are asking here as buffers are most likely dynamically sized to make best use of memory. Also, many are built by the server not just 1....
October 9, 2002 at 5:07 pm
Take a look here, http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316749
To me it sounds like you have more than 2GB of memory on the server and don't have the server enabled to work with.
"Don't roll...
October 9, 2002 at 4:57 pm
Not sure on this and am trying to find the details but I believe the changes during the query are causing one of the collections objects to update and force...
October 9, 2002 at 4:46 am
Take a look here as may help.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q229875&LN=EN-US
and possibly here
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q195759
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 9, 2002 at 4:24 am
Viewing 15 posts - 4,696 through 4,710 (of 7,429 total)