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
What do you understand by loop in flowchart?
I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...
HI ,I'm currently learning Oracle. Is it wise to Take up MCSE :Data platform as well to get a fill for both platforms ?
I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.
I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...
I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...
after a migration from winxp to win7, my encrypted *.enp files cannot be opened. i have sensible data there and cannot open them with any program. i really need some help.many thanksana
I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...
This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...
How to give access to the sign off database for user?
How do I get the weather to show up in the notification center on my iPhone 5?
I have a weird problem. Why in the the following SQL query does print 'equal' when run against SQL Server 2008. The database compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal'And this returns 0: select (LEN(' '))I think its auto trimming in space. Anyone know if...
I have installed, uninstalled and installed Adobe Reader again, and get Acrobat failed to connect to a DDE Server message. Could open PDF files when we had XP on other computer but not able to since we got Windows 7 on new computer. Have not been able to save and open in another window either....
I'm trying to connect to SQL Server 2008 R2 using Windows authentication. However, I can't because I keep getting this error:Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]Now, I can log in...
How to check the status of offline backup in brtools
Hi, I have a requirement where I need to send data/file to server using HTTP from my AS/400 server and then receive a response back from web server. Web server is using Java/PHP to accept data files. Please advise me an approach to do this. Thanks in advance.
While using SQL Server 2008 R2, I was able to execute ASCMD SSAS queries. We recently upgraded to SSAS 2012 servers and I hope to reinstall all my maintenance scripts. I can't find any ASCMD tools in SQL Server 2012, nor any documents on the internet. When I try to execute a query I get the...
Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...
Hi, I installed forms and reports 6i on my system. I could able to connect to data using forms builder and developed form.When trying to open fmx file, its asking for logn credentials and when i give credentials its giving me ora-12222 error.Pls help me out in this.
Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...