Link SQL Server 2008 to AS400
How to set up a ODBC for SQL 2008 to the AS400

Answer Question   |  August 10, 2011  11:49 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008

Problem with Visual Studio 2010 and SQL Server 2008.
Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to [...]

Answer Question   |  May 3, 2011  11:54 AM
ASP.NET, SQL Server 2008, SQL Server configuration, SQL Server connectivity, Visual Studio 2010

SQL statement needed to remove characters
I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

Answer Question   |  May 2, 2011  2:34 AM
SQL Server, SQL Server 2008, SQL statement, SQL tables

How can I create reference key of non-unique column in SQL server 2008
how i create refrence key of non-unique column in sql server 2008?

Answer Question   |  May 2, 2011  11:39 AM
SQL Column Headings, SQL Server, SQL Server 2008, SQL Server administration

SQL server native webservices and PHP
Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure [...]

Answer Question   |  May 10, 2013  12:34 PM
Apache, PHP, SQL Server, SQL Server 2008, WebServices

SQL Server Fails to Start When Moved to Different Node
Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the [...]

Answer Question   |  April 11, 2011  5:24 PM
Failover Clustering, Failover Clustering nodes, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server clustering, Windows Server 2008 R2

Slow response with SQL server over a network.
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]

Answer Question   |  April 5, 2011  5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance

How to move sql server clustered instance to a separate stand alone server
We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a seperate server [...]

Answer Question   |  April 2, 2011  1:12 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server clustering

SQL Server 2008 Insert Into vs Insert Statement Recompile
I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using “INSERT INTO” but when I use “INSERT” only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from mytable Not Recompile: insert #test [...]

Answer Question   |  March 24, 2011  7:34 PM
SQL, SQL Server, SQL Server 2008, T-SQL

What is Broker EventHandler Wait Event?
I keep seeing this wait stat “Broker_EventHandler” in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?

Answer Question   |  March 23, 2011  7:13 PM
Event handlers, Service Broker, SQL, SQL Server, SQL Server 2008

Should I enable service broker on SQL Server 2008?
I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

Answer Question   |  March 23, 2011  7:05 PM
Service Broker, SQL, SQL Server, SQL Server 2008, SQL Server Enterprise Edition

How to determine proper max memory setting
How do I determine the proper max memory setting for our system? We have Windows server 2003 R2 entreprise ed, sp2. It is 32 bit. There is 8.00 Gb of ram. We have just upgraded to SQL Server 2008 sp1, enterprise ed. Now we’re having some memory problems. Thanks very much for any help with [...]

Answer Question   |  March 16, 2011  7:05 PM
SQL Server 2008, Windows Server 2003, Windows Server 2003 Enterprise Edition, Windows Server 2003 R2

Combining 2 queries in SQL 2008
I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it’s possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN ’1/1/2010′ AND ’12/31/2010′) GROUP BY Eff_Date, CoNum, Brandname, DateApplied Query 2: SELECT Eff_Date, CoNum, SUM(CountOfBrandName) AS SUMofBrandNames FROM [...]

Answer Question   |  March 4, 2011  3:34 PM
SQL 2008, SQL Server 2008, SQL Server administration, SQL Server Query, T-SQL 2008

SQL SERVER Data Files and Threads
I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says “SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and [...]

Answer Question   |  March 4, 2011  4:54 PM
Exam 70-432, Open IT Forum, SQL Database, SQL Server, SQL Server 2008

SQL Server Data File Storage
We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data files belonging [...]

Answer Question   |  March 7, 2011  3:28 AM
SAN, SQL 2008, SQL Server, SQL Server 2008, SQL Server database

How I can automated process load xml file to SQL server 2008?
Hello!

Answer Question   |  March 3, 2011  8:28 PM
Automation, SQL Server, SQL Server 2008, XML File Creation

Web development course and Microsoft qualifications
I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web Development project management. I have [...]

Answer Question   |  March 1, 2011  12:04 PM
Apache, Flash CS5, HTML, java script, Linux, MySQL, PHP, Project Management Methodology, SQL Server 2008, Visual Studio 2010, Web development

SQL server 2008 provide access to SSIS
Client needs access to SSIS sql server 2008   Thanks, Evgenia

Answer Question   |  February 23, 2011  2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database

International SQL Server Replication
I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for billers to [...]

Answer Question   |  February 22, 2011  8:28 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication

SQL Server 2008 r2 won’t install
I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can’t get past the failure. The following error has occured: An error occurred during the installation of assembly ‘policy.8.0.microsoft.vc80.crt, version=’8.0.50727.4027′, publickeytoken=’1fc8b3b9a1e18e3b’, Processorarchitecture=’x86′,type=’win-32-policy’. HRESULT:0x800736fd I have uninstalled, installed . I am out of [...]

Answer Question   |  March 4, 2011  11:00 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server installation, Windows Server 2008, Windows Server 2008 R2