Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?

We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining...

SQL Server Ask the Experts2,585 pointsBadges:

Build 09.00.3239.00 (cumulative update)

I just patched my servers to this build and noticed that the time used to 'Delete files based on the age of the file at task run time' within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed...

Kurthp195 pointsBadges:

Patches for new SQL2005 instance

HI would like to know if we need to apply patches for a newly created instance if the default instance has already been patched to SP2 Thks for any info

fartman50 pointsBadges:

Coding for library in stored procedures

A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren't as familiar with this topic. So, any SQL experts out there with an answer? Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the...

Leah Rosin600 pointsBadges:

SQL 2005 error code = 80004003: Invalid Pointer

After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following...

Pressler29042,190 pointsBadges:

SQL 2005 Active/Active/Passive

We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because...

Kjrichmond15 pointsBadges:

Installation and updates

Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

TheVyrys0 pointsBadges:

How to prevent SQL update trigger from firing on insert?

Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...

Leo W5 pointsBadges:

full-text replication SQL Server 2000

I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

MarkT35 pointsBadges:

What’s a safer upgrade, SQL Server 2005 or the new SQL Server 2008?

Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.

SQL Server Ask the Experts2,585 pointsBadges:

Looking for a stored procedure to monitor size of Transaction Log file

Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

SQL Server Ask the Experts2,585 pointsBadges:

Problem occuring while performing Mirroring

Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak...

Cmrhema5 pointsBadges:

New user permission to SQL server

Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as " login failed to user, check SQL registration properties. Thank you.

Mutallib5 pointsBadges:

SQL Server 2005 – Are There Any Easy Appl. Builders

Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source Apps or low...

Tsmith235 pointsBadges:

Replication

Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

Consultant16535 pointsBadges:

How to pass Parameter of stored procedure Crystal report

How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure

N75 pointsBadges:

fore front – Can FCS be installed on sql express 2005

Can FCS be installed on sql express 2005, and if yes what is the requirements as per the web site it can be done but how !!!!??? eveywhere else they are saying its not supported http://www.microsoft.com/forefront/serversecurity/mgmt/sysreqs.mspx

Rami220 pointsBadges:

about checkbox

Iam just at the very basic level of entering a boolean value(yes/no) for the check box cheked value in to a database with field check...for this Iam using a string variable checkvalue and proceeding like this private sub submitbtn_click(.......) dim checkvalue as string="" if checkbox1.checked=...

Anupamak1515 pointsBadges:

Looking to resolve SQL Server performance problems caused by using many temporary tables

I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. "RamDisk presents a powerful solution to this problem by providing...

SQL Server Ask the Experts2,585 pointsBadges:

Microsoft SQL 2005 Networking

Hi I'm a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications my application is a software will be installed in to client machines as 2 home PC and i want to make the two software's connect throw Ethernet to my database which it located on one of the...

M200015 pointsBadges: