SQL Server memory usage
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

Answer Question   |  March 15, 2010  6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance

Moving Distribution database from an instance to antother does increase performance ?
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]

Answer Question   |  March 15, 2010  10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication

Encrypting passwords on SQL server 2000
I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt which is [...]

Answer Question   |  March 19, 2010  7:00 PM
Encryption, Password, Password field, SQL Server 2000

Running SQL Server 2000 and 2005 simultaneously
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

Answer Question   |  March 12, 2010  6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005

Problems with SQL Server 2000
In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit”. What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do [...]

Answer Question   |  March 12, 2010  6:45 PM
.NET, SQL, SQL Server 2000

Adding files to TempDB
Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

Answer Question   |  March 11, 2010  6:41 PM
SQL, SQL Server 2005, TempDBs

ASP.NET
i have four textboxes abd a database whicjh is already created. what i want to do is if i enter the value in the four textboxes and press button it should automatically gets updated or saved in the database.

Answer Question   |  March 10, 2010  4:52 PM
ASP.NET, SQL Server 2005, Visual Studio

ASP.NET
i want to insert the data into the existing database

Answer Question   |  March 10, 2010  4:13 PM
ASP.NET, SQL Server 2005, Visual Studio

The most-watched IT questions this week: March 9, 2010
1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor log files in [...]

Answer Question   |  March 10, 2010  3:27 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Multiple rows locked in sqlserver when updating one row
In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).

Answer Question   |  March 9, 2010  9:03 AM
SQL Server, SQL Server 2005, SQL Server 2008

How should I make the SQL in iBatis having Parameter of ListMap?
How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new ArrayList<Map>(); Map<String, Object> map1 = [...]

Answer Question   |  March 8, 2010  5:17 AM
iBATIS, SQL, SQL Parameters

Sudden SQL errors keep Business Contact Manager from loadingHELP – Sudden SQL errors keep Business Contact Manager from loading


Answer Question   |  March 29, 2010  5:18 AM
SQL Server 2005 connectivity, SQL Server connectivity, SQL Server error messages

retrieving run time records in SQL
how to retrieve multiple rows at run time in sql

Answer Question   |  March 4, 2010  4:56 PM
Runtime records, SQL, SQL Runtime

SQL index on dds file
Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

Answer Question   |  March 5, 2010  2:43 PM
DDS, SQL, sql indexes

Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS
Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS, and Virtual Server / Hyper-V? We need to know that SharePoint is performing badly, but we need to know which underlying technology or hardware component is actually causing the fault. This [...]

Answer Question   |  March 4, 2010  2:23 PM
Hyper-V, IIS, SharePoint, SQL Server, Virtual Server

Forum data transfer – SQL
Hi, my question is: we’re developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give [...]

Answer Question   |  March 5, 2010  7:40 AM
SQL Database, SQL Database Transfer

Reading flat file defined as DBCS
Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF       0600O      upon copying the xml into the flat file using the command CPYFRMIMPF the chinese characters turned into garbage like this one <COMPANY_NAME>ÚÚ¢XÚÚÚÚÚÚÚÚÚÚ[strong]<[/strong]¬Yñ¡ÚÚéX¢aÚÚñ²ßjÚÚ%W|¾</COMPANY_NAME> There is an XML parser [...]

Answer Question   |  February 21, 2011  3:13 AM
AS/400 flat file, Data Types, DBCS, RPGLE

MS DNS query logging to sql server?
Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

Answer Question   |  March 3, 2010  10:19 PM
DNS queries, SQL Server database, Windows Server 2003, Windows Server 2003 R2

Encrytpion on SQL Server 2008
I want to encrypt a stored procedure in SQL Server 2008. I tried software such as SQL shield, it’s great but the problem is SQL Profiler can still record/log the content of my original SP. Is there any way to avoid SQL Profiler from recording/logging my original content? If not, do you suggest any different [...]

Answer Question   |  March 3, 2010  4:55 PM
SQL Profiler, SQL Server 2008, SQL Server encryption, SQL Server Service Packs

How can Systems Center help with uptime, availability and performance of SQL Server instances and Exchange mailbox servers?
We are particularly concerned with the uptime, availability, and performance of SQL Server instances and our Exchange Mailbox Servers. How can Systems Center help me with this? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

Answer Question   |  March 2, 2010  4:18 PM
Exchange Mailboxes, Exchange Server, Microsoft System Center, SQL Server, System Center