Optimizing Query that uses linked tables and bound form w/joins
I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses, [...]

Answer Question   |  September 28, 2009  3:10 PM
Access, Linked Tables, SQL Server

sql update command to update a date-of-birth
I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

Answer Question   |  September 24, 2009  2:41 PM
Date format, SQL Oracle 9i, Update

SQL Server 32 bit, AWE/3GB/PAE
I have read quite a few articles that recommend turning on /3GB on a server with 32bit SQL server and 32bit Windows 2003 standard where you have between 4GB and 16GB or RAM. Why is /3GB needed? Just so SQL Server can have more VAS, and because VAS is better than AWE mapped memory? This [...]

Answer Question   |  September 26, 2009  8:49 PM
3GB, AWE, PAE, SQL Server

Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards
A quick and important update on our Panasonic flatscreen contest and the nominations process — we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

Answer Question   |  September 23, 2009  3:50 PM
AS/400, CIO, Contests, DataCenter, Development, ITKE, ITKE Contests, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP

Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done [...]

Answer Question   |  September 24, 2009  3:35 PM
AS/400, Embedded SQL, Microsoft SQL Server

Making a WAN
Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ(head quarter)- HP Mail Server (HP ML350) - Win 2003 Server + Exchange [...]

Answer Question   |  September 30, 2009  10:56 AM
Exchange 2003, Network Configuration, SQL Server 2000, WAN, WAN design, WAN hardware, WAN technologies, Windows Server 2003

The most-watched IT questions this week: Sept. 22, 2009
Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

Answer Question   |  September 22, 2009  2:32 PM
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

Nominate a member for our latest Panasonic flatscreen giveaway
In our latest (and biggest!) IT Knowledge Exchange giveaway, we’re giving thanks to the star members of the community who provide quality contributions in their questions, answers and discussions. Did a member answer your question in a particularly great way? Did someone recently contribute to a thoughtful discussion? Has someone asked a question that made [...]

Answer Question   |  November 25, 2009  3:12 PM
AS/400, Contests, Data Center, Exchange, Flatscreen, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Panasonic, Security, SQL Server, Storage, Virtualization, VoIP

Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc
Here’s the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)), LTRIM(RTRIM(T_ASFSTAG0.STRSP1))    FROM T_ASFSTAG0    WHERE   (T_ASFSTAG0.STANS1=@AnneeSelectionnee) AND     ((isdate(T_ASFSTAG0.STCRT1)=1 and convert(datetime,convert(varchar,T_ASFSTAG0.STCRT1,103),103)>=convert(datetime,convert(varchar,@DateDernierImport,103),103)) or     (isdate(T_ASFSTAG0.STMAJ1)=1 and convert(datetime,convert(varchar,T_ASFSTAG0.STMAJ1,103),103)>=convert(datetime,convert(varchar,@DateDernierImport,103),103))) Please note that T_ASFSTAG0 is a view [...]

Answer Question   |  September 18, 2009  8:48 AM
Linked Server, OPNQRY, SQL 2000

Complete System Backup SQL Server
We are running SQL 2008 on Dell Servers with a wholesale Distribution Package Software by Activant Solutions Called P21 (Prophet 21) Our question is this! WE have a SQL Server and a TS Terminal Server running our Distribution Software and off of this equipment was recommended by the Activant Solutions Company, Activant is very difficult [...]

Answer Question   |  September 18, 2009  9:03 PM
Activant Solutions, Backup, Dell servers, Prophet 21, SQL Server 2008, Terminal Server

If running two SQL Server db in two VMs, I should purchase two db servers?
If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

Answer Question   |  September 18, 2009  12:36 PM
Microsoft virtualization, SQL Server databases, Virtual Machines

Passing parameters to report viewer
Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has the [...]

Answer Question   |  April 19, 2013  11:52 AM
C, C# .NET, Parameters, SSRS

dbcc checkdb error; object id 0
Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to [...]

Answer Question   |  September 16, 2009  11:15 AM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore

Trigger Use
I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the Trigger coding? [...]

Answer Question   |  September 16, 2009  6:18 PM
Database Management Systems, SQL Server, SQL Server 2005

Export Oracle data to Excel
Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

Answer Question   |  September 29, 2009  6:16 PM
Oracle, Oracle export, SQL, SSRS

The most-watched IT questions this week: Sept. 15, 2009
As part of a new feature on the IT Knowledge Exchange Community Blog, we’re highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. Consolidation Tracing a computer to an IP address Connect remote Oracle 11g server in VB 6.0 How to utlize multiple static IP’s when ISP limits physical router connectinos [...]

Answer Question   |  September 15, 2009  3:26 PM
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

SQL Database User
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the [...]

Answer Question   |  September 15, 2009  9:22 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security

SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run and it is [...]

Answer Question   |  September 16, 2009  4:15 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS

App-V application license requirements
So if the receiver of the App-V application which has an embedded SQL Server in it already has a liscense to access an SQL Server then ther are no new liscenses required. If that is not the case then the receiver of the App-V application will need to purcahse what? This question is from the [...]

Answer Question   |  September 14, 2009  1:47 PM
App-V, Application virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, SQL Server licensing

Applying snapshot on Subscriber – SQL SERVER 2005
hi, i’ve read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and the Distribution Agent begins processing it, stop the Distribution Agent. Once the SQL Server Agent job has stopped, [...]

Answer Question   |  September 14, 2009  6:21 PM
Snapshot, SQL Server 2005, SQL Server snapshot backup