The bulk of the RAM used by SQL Server is used for page caching. Queries use very little RAM.

on my main form vb project is able to insert, delete or update everything including file insert into sql as binary, both pcs can do all operation except PC (B) the path use to download file from binary didn't …

Cannot Connect to <Server>. SQL server may not be running on the server. Please verify that SQL Server is running and configured correctly on the server. Contact your network Administrator if the …

I deployed SCCM 2007 on one server and this server has Active Directory and SQL 2008 SP1. (Lab Environment) I deployed in the same server a Distributio Point with account testdomain\sccmsrv …

" The SQL Server Reporting Services (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs. …

Firstly, you can perform an in-place upgrade of Windows Server 2008 R2 to Windows Server 2012 R2 following the instructions in this blog. Before upgrading your Operating System, I would recommend …

I created a linked server in a different SQL instance using the same ODBC connection with Version 17 driver. In SSMS I performed a select ...Openrowset (linkedserver, select * from...) and it returned all …

We are using Windows 20003 SP1 32bit with MS SQL Server 2005 Enterprise Edition RTM.

Thanx. For both accounts, domain account are used. Do you have a reference for the necassary permissions to the Ops database, DW database, and SQL instance so I can make sure they are …

I need to merge both tables together to create a new 3rd table and have everything in a wide format, so name and address for one record plus another new column with Date of Birth, so in the end i would …