Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
Can someone help me with this question: RAID Levels, Hardware issues,choice of RAID level and improvement in performance via parallelism
Why would an undefine report attached itself to the bottom of a report that is defined?
I installed Ubuntu onto a WinXPP machine so that they are duo boot. The system should have automatically mounted my windows directory and created an icon on the desktop. It did not. I followed the directions and opened a bash shell and typed sudo vol_id -u /dev/sda1 Ubuntu returns the error command...
I run a system comprised of 36 IBM Blade servers, a Hitachi 64TB SAN, a Data Domain backup suite and connection devices. I run Windows 2003 R2 (32bit) and Red Hat 4 (64bit). I have just come across a problem in that all the windows blades in one (of three) chassis are displaying my drive E: (which...
I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...
I have a table that captures about 100,000 records per day. As you can imagine, the size and performance of such a table would degrade as it quickly went well over 50 million records. I want to try something different, and that is the creation of a new table every day, so that the number of records...
I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...
Looking for a way to "Bulk delete" in SQL Server 2008. Since I want to use WHERE for limiting the rows in action, I know I can't use TRUNCATE. Should I use something like "batch deletes" or "bulk copy"?
Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions? I’m referring to committed commands – I know you can rollback if query is inside transaction. We have full, differential and transaction log backups in place but we’d...
For the past few weeks, my Windows 7 64-bit ultimate machine has been extremely slow to restore from hibernation. It spends several minutes on a blank screen with a blinking cursor. After it starts, it takes forever to get any of my programs to load. I've tried to the following things to speed it...
Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...
What should I bring up to someone when I am trying to get them to migrate from an AS/400? What are the pros and cons of migrating from the AS/400?
Hi all, We have a common source physical file QRPGLESRC in lib Qbbb for our Project. In this, almost all RPG Members are having comments for understanding the program. Well, when I have a copy to my own Source file Qxxx in another Library Qyyy to change the program according to new requirement,...
Please help me find a new secure mechanism against cache based side channel attacks in the cloud. I found that ieee published a method for security against AES, RSA, BTB attacks to retrieve the secret key. It is architect based method. Can I do any modification to this work after implementing this...
Does anyone have some examples of advancement in secondary storage for the future?
Now, I've recently added SQL Server Express 2012 to my home server. I'm trying to connect to it from Visual Studio 2012 from my machine but I keep getting this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...
I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...
When we created a new object in source system and included in Data group for replication. It didn't automatically replicate? We have to end journaling for the new file (obj) and start Journaling again.It works now. Reason?
Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...
explain the working of railway track fault detection system component by component.