Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Cisco, Database, DataCenter, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, 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
We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?
What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?
I have problem with exporting a table to a dbf format file in sql server 2005 Has anyone done it before? Thanks!
Hi everybody, Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server. In Oracle I tried as "create table table1 as select * from table2" My requirement is to create dynamic tables in stored procedure based on existing tables. I'm so desperate, I...
How to get SQL server's login and password? Please: I know query for get it.
My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can't make sense of MS's pricing for SQL Server upgrades any longer (i.e., it seems they've gone away from the notion of a SQL Server 'upgrade' license). Does anyone know a...
How can I get the AdventureWorks database for SQL Server 2005 SP1?
Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...
When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?
How can i merge the MDF and NDF files of SQL Server databases?
Hello people, the situation is this: we have 2 computers, one is for local store (let's call it backend) and the other is a web server (let's call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS...
Does the SAP KVBI report work when the sales order is cost object?
Hello, I need to create a SAP port (ECC6.0) with Connect:Direct. Anyone can help me with that or let me know any information about it? thanks in advance.
We have two divisions 10 and 20 in our system and I was hoping that using transaction vor1 and vor2 I could assign these so that master data is setup in one go referencing division 10. However if I create a customer using division 10 or 20, SAP doesn't create the reference division at the same...
Dear Sir, I have been working as Siebel Data Management Consultant for the last 9 years. I have worked mostly on Data Migration projects, i.e moving data from legacy systems to Siebel CRM application. Now that Siebel is dying product I am considering the move from Siebel to SAP. Could you please...
when we can use "order expediting" and "order de expediting"
I work for a Chinese company utilizing SAP and was told not to use the text field in FBL5N. They also don't utilize the workflow or attachments. I tried attachments but it was gone in a few days. Is there any reason for this directive? I have no understanding or reason from management.
Hi, I try to validate the date field but the Indicator sets on for both valid and invalid. Please advice. D datevalid S 8A inz('20131225') D dateINVAlid S 8A inz('99999999') * /free test(DE) *ymd0 datevalid; if %error() ; dsply 'Error!' ; endif ; /end-free * C *YMD TEST(D) datevalid 44 C N44'valid'...
Hello, Within SharePoint Calendar, I can setup case deaflines/events (similar to NOTES Calendar). However, I am unable to setup an alert/ticklers to notify as the deadlines are approaching near. This is a critical requirement and I need some ideas to set this up. We are not using Exchange. We use...
My colleagues upload a large number of files, Yet, as you know, they are still invisible to others since they are not checked in. It is not a easy job to do that. So do you guys have any solution? Thanks in advance!