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
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
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
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
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
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
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
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
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
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 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
Answer Question | March 29, 2010 5:18 AM
SQL Server 2005 connectivity, SQL Server connectivity, SQL Server error messages
how to retrieve multiple rows at run time in sql
Answer Question | March 4, 2010 4:56 PM
Runtime records, SQL, SQL Runtime
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, 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
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
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
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
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
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