Forgot your password?
DrUltimaAccepted Solution on 2011-03-14 at 07:13:38ID: 35128708
Join now to access this answer plus 4 million more
Get Access Now
Article by Matt Minor
Captain Jack Sparrow (https://en.wikipedia.org/wiki/Jack_Sparrow)'s infinite wisdom never ceases to amaze. His famous quote illustrated in the image above has really impacted the way I interpret "problem situations". In this field, we often find ourselves in reactive situations -- with staff, managers, team-leads (I could go on...) breathing down your neck while you are trying to figure out what happened and get it corrected STAT. It's stressful. We are fighting the panic feeling, we are struggling with whether or not to fight or flight -- we've ha…
Article by Yashwant Vishwakarma
Piecemeal Restore/Partial Restore:
Note: All screenshots are applied to SQL Server 2012 Enterprise Evaluation Edition.
In my previous article SQL Server Storage Basics: Database Filegroups (http://www.experts-exchange.com/articles/23159/SQL-Server-Storage-Basics-Database-Filegroups.html), I discussed about database filegroups, why filegroups are important and how it helps in database administration. There I mentioned that we can bring some parts of the database online quickly (piecemeal restore/partial). This article…
Video by TechMommy
Video by Joe Winograd
Answer by HITCENTER
i am not sure if this question is okay - but I try. Delete, if its not OK.
We are looking for a expert that can upgrade / migrate our free OTRS 3.0.10. to newest free version.
Its a big job, as far as i know, but we will pay about 2700 euro for this job.
I have contacted OTRS directly, and they want to sell me OTRS Business Solu…
Answer: Ah - I see Gigs is up running ! - Mayby i should try to fill in there.
Answer by it_saige
Can you please tell me if you do not need to go into Install Mode anymore on Windows Server 2012 and upwards?
Is it only on versions of Windows Server 2008 and below?
Answer: Since Server 2003, Terminal Services (currently known as Remote Desktop Services) attempts to automatically put the server into install mode based upon the following criteria:
A. The Add/Remove programs applet or Programs and Features applet is used to install the …
Answer by Dale Fye (Access MVP)
Question: i have a column called DESCRIPTION that contains more information than just a description. I want to extract the data before the first space.
ABC blah blah and more 123 blah
BCDEF blah blah and more
CDEFGH blah blah 1234
The result should be:
Answer: SELECT LEFT([Description], instr([Description], " ") - 1)
WHERE Instr([Description], " ") > 0
Answer by Paul Maxwell
Question: This table structure was created using MySQL 5.6.27 (CODE)When I try to use that code to create a similar table on a server running MySQL 5.1.30 I get an error:(CODE)Please help! Thanks.
Answer: Try removing the "(6)" from the end of datetime
`Status` char(20) COLLATE utf8_unicode_ci DEFAULT 'newlead',
`SampleDate` datetime NOT NULL,
`FollowupDate` datetime DEFAULT NULL,
— trusted by —
Join Experts Exchange
About Experts Exchange