Allocated Memory Alert
Our clients newly installed SBS 2003 R2 is sending out Allocated Memory Alerts. My co-worker says this is common for SBS installations, something to do with SQL Server. He figures we should maybe shut down the SQL service, as it is not in use at this company. I have certainly seen this crop up on [...]

Answer Question   |  July 22, 2009  7:28 PM
SBS 2003, SBS 2003 R2, SBS Allocated Memory Alert, SBS Installation, SBS Performance, SQL Server

What is the difference between SQL and T-SQL?
What is the difference between SQL and T-SQL?

Answer Question   |  April 1, 2009  6:30 PM
SQL, T-SQL

How many tempdb’s necessary in our clustered environment?
We have a clustered environment with three nodes and five instances. Each node has eight CPU’s, and we are wondering how many tempdb’s are necessary for each instance. Do you do the calculation on the total number of CPU’s, all 5 instances failed over to one node or some other variation that I should be [...]

Answer Question   |  March 9, 2009  6:18 PM
Clustered servers, SQL Server clustering, TempDBs

Auto filter of distinct values on columns in SQL Server Reporting Services?
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

Answer Question   |  March 25, 2009  6:13 PM
SQL Server Reporting Services, SSRS

SQL 2000 db transactions/sec
What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

Answer Question   |  March 11, 2009  2:25 PM
SQL Server 2000, SQL Server database, SQL Server Database Transactions, SQL Server performance, SQL Server performance tuning, Windows Server 2003

Oracle Forms 6i Database Objects
I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you

Answer Question   |  March 9, 2009  9:31 AM
Dynamic SQL, Oracle Designer, Oracle development, Oracle Forms 6i, Oracle SQL, SQL

Using an indexer for SQL Server 2005
Hi The application I work on is a Java web application with sql server 2005. A user can search for a document stored in a file server. When they search for a document, a stored procedure is invoked from the java code and an open query code is used to go to a catalog created [...]

Answer Question   |  March 9, 2009  7:12 PM
Indexed tables, Java applications, Java Web application, SQL Server 2005, SQL Server Indexes

How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Hey guys!!! I’m quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I’m trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is [...]

Answer Question   |  March 9, 2009  11:01 AM
Data Junction, Extract Transform Load, INSERT statement, SELECT statement, SQL Server 2005, SQL Server connectivity, VB.NET 2005, Visual Basic .NET, Visual Basic 2005

SQL Server 2005 Memory
My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set ‘lock page on memory’, but Task Manager show only 4.50GB only and performance monitor show SQL server manager – total memory on 4GB. Expert: Do I setup memory wrong?

Answer Question   |  March 9, 2009  10:46 PM
SQL Server 2005 administration, SQL Server 2005 memory, SQL Server 2005 performance

Pagination in SSRS 2005 Reports
I have several reports in SSRS 2005 that consist of a “report header” area with various textboxes (note this is in the body of the report, not a page header) and then a table — sometimes a very long table (and then a “report footer” area with some more textboxes, and also a bona fide [...]

Answer Question   |  March 2, 2011  5:09 PM
SSRS 2005, SSRS reports

tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”
I’m trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in (‘MIBNOM1′,’MIBNOM2′) order by add_date asc But I keep getting an error message PLEASE HELP

Answer Question   |  March 7, 2009  3:36 PM
SQL, SQL error messages, SQL Statement Syntax Errors, SQL statements

Finding the average of a data type on a SQL Server
I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8) AS Waktu_Proses_Akhir, CONVERT(varchar, Waktu_Proses_Akhir - Waktu_Proses_Awal, 8) AS Waktu_Proses, Bulan, Tahun FROM dbo.Histori_Produksi This is [...]

Answer Question   |  March 5, 2009  8:25 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors

Deciding on a RAID Level for a 64-bit SQL Server 2005
I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which [...]

Answer Question   |  March 6, 2009  8:22 PM
RAID, RAID Level 1, RAID Level 1 +0, SQL Server 2005, SQL Server 2005 (64-bit)

help on Bulk insert and xp_cmdshell rename
Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows.I dont have a delimiter. csv file: (First row is blank) apple bat cat doll when i used the [...]

Answer Question   |  March 5, 2009  6:49 PM
Bulk Inserts, CSV, SQL INSERT, T-SQL

iSeries to SQL Server via SSIS 2005
We have multiple DB2 Schema’s that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.

Answer Question   |  March 6, 2009  4:56 PM
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005

Join our ITKnowledgeExchange.com LinkedIn group
We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager

Answer Question   |  November 13, 2009  4:19 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows

Linked server problems
I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and [...]

Answer Question   |  March 6, 2009  2:34 PM
Linked Server, Linked SQL Servers, SQL Server 2000, SQL Server 2005

SQL Server 2000 backup problem using batch file
i have written a batch file to backup sql server database and it holds the data of CRE.the batch file is running successfully. but, after running i am unable to login to CRE (cash register express). i doubt if my batch file is corrupting my database please answere me what may be the problem

Answer Question   |  March 6, 2009  9:42 AM
Batch file to backup, Batch files, Cash Register Express, SQL Server 2000 backup, SQL Server development

What are basic differences between SQL Server 2000 and 2005?
What are basic differences between SQL Server 2000 and 2005?

Answer Question   |  January 25, 2012  9:40 AM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

Copying our disaster recovery database on a SQL Server
We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don’t want to stop it and lose consistency between disaster recovery and the production copy. How can we [...]

Answer Question   |  March 6, 2009  4:56 PM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases