Online Tech Community

Where Your Tech Issues Are Solved

Connect with 10M+ tech pros who can solve problems, complete projects, and help you learn more—faster.

Please enter a first name

Please enter a last name

Must be at least 4 characters long.

By clicking you are agreeing to Experts Exchange's Terms of Use

Member Login

Don't have a membership? Join now

Contact us if you have any questions.

Filter your feed by interest or job role:
Recent activity in Database Administration

Conditional Logic In SQL Server View

I am relatively new to SQL Server, using Developer 14. I have payment records stored in a table …
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Writing a heredoc to a file

I'm having an issue with trying to get a heredoc in a ksh script to write to a file.  I have used …

repeating query multiple times

what's the best way to do it? create a function or view?

SQL 2008 Bulk Insert Not Working

Book1.txt is a Text (Tab delimited) (*txt) file. Not sure why I am getting errors. I assume …

win server 2016

Hello Experts this customer has installed himself a win server 2016 in a HP Proliant ML10 GEN9   …

how to use SQL Server Import/Export Wizard to generate dtsx jobs.

Greetings, I have a remote SQL Server engine that I have to query and send the results to local …

Crystal Report - sum field from subreport

Hello, I'm trying to sum up a field from a sub-report and am not sure how.  This report is a list…

Virtual Disk not on Preferred Path

We have a Dell server running ESXi 6.5 connected to an iSCSI SAN using four paths on Round Robin, …

SQL Database Copy

Hello, We have a few clients who use some custom apps on SQL at their locations. Now, we want to …

Statistics information on SQL Server DB

When i check DB options : Auto Create Statistics: True Auto Update Statistics: True
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Microsoft Access 2016 Long-Text - how to retain BOLD/ITALICS when export into MS Word

In my MS Access 2016 database, one of the fields is LONG-TEXT type.  I use this field for several …

Exchange 2013 CU17 Moving database from partition to other partition

Hello Experts , I Want to move a database from partition G:database to Partition E:databases but …

MS SQL DB backup

We having 1 standalone DB. WE scheduled full backup for every Friday @ 10 Pm and log backup for …

Best way to join the last row

Hi, I am curious what is the most efficient way to join the last entry (row) of a dataset that …

SQL Server named instance will not allow remote connection via RemoteApp

I had this question after viewing cannot consistently connect to SQL Server named instance

bulk check and disable user accounts in AD.

Hello, We have a list of user first and last names in separate columns in a CSV file. Would …

set-log Microsoft-Windows-PrintService/Operational /e:true

i'm trying to enable this "set-log Microsoft-Windows-PrintService/Operational /e:true" logging for …

Error in update statement

I am trying to perform a very simple update on a table. But I get an oracle error in sql developer …

Probably simple LEFT JOIN question but I cant seem to get it to work

I have two tables (table1 and table2) in a single DB that backend some web pages. One of my pages …
Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Help with identifying dependencies

So I have my table that is attached in the image, and as you can see I have my Primary key …

3 hard drives dying in a desktop within a couple months... power supply issue?

We have a dell optiplex 390, shipped in June 2012. So 5 1/2 years old. In June 2017 the OEM hard …

SAN Network routing

Hi, I have a SAN Network isolated from the reset of the network and I have a Single Windows 2012 …

entering $0 when value is Null

SELECT cme.cmeID, cme.provID, providers.fullname, provtype.provtype, cme.FY, cme.totalfycme AS …

Add suffix to duplicates in MySQL

I have the following mysql query which find duplicate urls in Magento 1. I would like to run an …

Free backup programs that are useable !

Im needing to find a backup program that lets you select folders to backup from a hard drive on a …
Who is Experts Exchange

We’re an online community of sysadmins, developers, and tech users who enjoy learning and helping each other.

You can use Experts Exchange to solve your technology challenges, receive live 1:1 help, seek mentors, and educate yourself on technology that matters to you.

Join Now

Train Online

Develop new skills through online courses in topics like security, system administration, virtualization, and design.

Course of the Month12 days, 9 hours left to enroll
Microsoft SQL Server and Database Concepts
Free withPremium
23 lessons

Solve Urgent Issues

Submit your toughest questions for the community to solve, or receive 1:1 help in real time when you need the fastest resolution.

Ask my Question Get 1:1 help

Connect with Mentors

Collaborate with subject-matter experts in real time for instant help through live chat.

View Mentors

Build Your Reputation

Share your knowledge, help others in the community, and move up the ranks to become an expert.

Join Now

Need a membership for work?

Team accounts available.

Create my Team Account