I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!
Answer Question | July 14, 2008 6:22 PM
Database, Memory, Server management, SQL Server 2005, Windows Server 2003
I’ve been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone. [...]
Answer Question | July 16, 2008 3:08 PM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
I have one rpg pgm in which I am creating a cursor on select to slect some records.After then I am opening cursor and fetching its data to an external data structure.Now my question is whether the external data structure takes only one record(first record) or it will have all records selected through select ststament. [...]
Answer Question | May 4, 2010 12:50 PM
C+, Data structures, RPG, RPG/400
Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.
Answer Question | July 11, 2008 7:22 AM
.NET applications, Database connectivity, SQL Server 2005
I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the “text 255 cha” values. I need specifically to keep the same properties. I used to be able to do it and is not working now.
Answer Question | July 10, 2008 4:49 PM
CSV, Export, Microsoft Access
Is is possible to run reports similar to how you run reports in Access in Excel 2007?? If so, How?
Answer Question | November 8, 2010 4:04 PM
Excel 2007, Microsoft Access, Reports
How to send a report in MS Access to the body of an email in MS Outlook.
Answer Question | July 10, 2008 1:58 PM
Access reports, Microsoft Access, Outlook, Outlook 2003
How do you make the text boxes required to type in for an MS Access form in design view?
Answer Question | July 19, 2008 1:54 PM
I’m relatively new to Crystal Reports, and most of the reports I’ve written are in Ver 7.0, I do have Ver 11, I have not done much with it yet. I have a Crystal Report that is used to generate a shipping label from a packing list in SQLBase. Most of the packing lists have [...]
Answer Question | July 10, 2008 12:09 PM
Crystal Reports, Macros, Printing, Programming, SQLBase
Hi. I am an IT professional having CISA, CISSP certification. i have recently started working in the Information security field, can anybody suggest how to get started here.?One suggestion i received was that i should get my networking concepts very correct as they will be applied regardless of the domains of Information security field.
Answer Question | August 7, 2008 8:36 AM
Information security, Information security careers, IT careers
does jasper server allow you to use sql server as your database server..if yes can you guys help me out…im stuck with this for almost a week. thanks in advance…
Answer Question | August 11, 2009 7:51 AM
JasperServer, JDBC, SQL Server
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there any diference in performance between internal vs external stored [...]
Answer Question | May 4, 2010 2:18 AM
C#, Database performance and tuning, DB2/400, SQL stored procedures, Stored Procedures
When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?
Answer Question | July 14, 2008 5:56 PM
Functions, SQL Server 2000, tables
I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file
Answer Question | July 9, 2008 5:05 PM
Database programming, DropDownList, Microsoft Access
Hello…I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn’t exist, alert user. More description: My name is Steven, I’m a college student and now I’m running my practical session to complete my study. I’ve been assigned to [...]
Answer Question | July 9, 2008 9:29 AM
Access 2007, Microsoft Access, Visual Basic 9
When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I’ve tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could help it would be greatly appreciated!
Answer Question | July 9, 2008 9:10 PM
Access errors, Microsoft Access, Windows
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]
Answer Question | July 8, 2008 3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times…can anyone help?
Answer Question | July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
can any one help me what is the difference between external described datastructure and program described data structure and what is the use of external data structure and, can i use variables of external data structure in another program
Answer Question | July 8, 2008 8:28 AM
AS/400, Data structures, RPGLE
I currently have a label that displays the current month as an int i.e July = 7. I have a database with a username primary key and field 1 – 12 for each month. Each field either has a 0 or 1. I can use a detailsview to with a datasource to view all of [...]
Answer Question | July 7, 2008 6:32 AM
Database, detailsview.findcontrols(), VB.NET, VB.NET 2005, Visual Basic .NET