Viewing 15 posts - 1 through 15 (of 30 total)
Can you confirm that the databases are not auto-closing. This would have the database close and release all resources when it is not being used. When someone connects to the...
October 5, 2004 at 9:50 am
P.S. As technicians, we often forget Return on Investement (ROI). Most of us work for organizations that must make a profit.
It is often cheaper to throw additional hardware at an...
October 5, 2004 at 8:27 am
I agree with KlK and Dave's suggestions to find out what your current bottleneck is, and if possible how close you are to other performance limits. That said, there are a...
October 5, 2004 at 8:06 am
I would suggest making sure that AUTO_CLOSE is not set for the databases in question. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_6ohf.asp
Regards,
Mike
October 4, 2004 at 9:11 am
ISV - Independent Software Vendor
Microsoft SQL Server Runtime is a special licensing of SQL Server that is bundled with an application. This version of SQL Server is only licensed for...
September 9, 2004 at 7:12 am
I believe you need to get a SQL Server license. I base this belief on "as Runtime licenses may only be used with a given ISV's solution." See http://www.microsoft.com/belux/nl/partner/isv/pip_faq_lic.mspx
It...
September 2, 2004 at 12:35 pm
"OpenQuery needs metadata about the columns at compile time"
http://support.microsoft.com/default.aspx?scid=kb;en-us;297368
If you perform a Google search of Microsoft.com using the search criteria:
"object has no columns" "linked server" site:microsoft.com
You will...
August 18, 2004 at 9:20 am
Hi bj007,
"Is there something i am missing.."
After you click on the fourth button, "View Log File Data" or CTRL-L, you should all all of the instances of all of...
May 18, 2004 at 1:06 pm
FWIW, I would suggest using Perfmon to convert the saved binary file to a comma seperated file.
May 18, 2004 at 8:39 am
... And if the database has been set up for replication, you get additional system tables (e.g., sysarticles, etc.)
Cheers,
Mike
May 14, 2004 at 1:48 pm
I apologize, some extraneous characters were appended to the link.
May 5, 2004 at 2:49 pm
According to the PowerPoint presentation "Limits of the 32-bit Environment" (http://download.microsoft.com/download/9/b/4/9b45acbc-9efc-4075-ad1e-6f05474619d0/SQLServer2000andItanium2-byScalabilityExperts-Rev3.ppt&e=42), the procedure cache is limited to 4 GB, but "Practical limit is less than 3 GB".
(Watch...
May 5, 2004 at 1:04 pm
Hi,
When performing a two computer upgrade from SQL Server 6.5 to SQL Server 2000, the account used for the MSSQLSERVER service on both machines should be domain accounts belonging to...
April 28, 2004 at 12:02 pm
Hi Raj,
First step you will need to define your requirements. I suggest reading "Introducing Replication" and "Planning for Replication" in BOL.
Once you have your requirments an have planned how you...
April 22, 2004 at 10:08 am
If you look closely, when you use EM to change the Network Configuration, the window that opens is "SQL Server Network Utility".
Cheers,
Mike
April 21, 2004 at 11:46 am
Viewing 15 posts - 1 through 15 (of 30 total)