Databases

53K

Solutions

61

Articles & Videos

33K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Related Topics

  1. Microsoft SQL Server
  2. Query Syntax
  3. Microsoft Access
  4. Microsoft SQL Server 2005
  5. MySQL Server
  6. Oracle Database
  7. Microsoft SQL Server 2008
  8. PHP
  9. Active Directory
  10. Programming
Refine results

Good Day Experts!

I find myself in a bit of a jam here.  Long story short I need help with a query in which I need to join a table in a different database using data on the record from the first …

317 views
Microsoft Certification Exam 74-409
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

SQL 2008 R2 std server.
 I moved few databases from Drive F: to Drive E:
by taking DB off line, dropping and attaching.
I am not able to reattached two DB. see error attached
I am not able to …

28 views

Hello,

we ran out of space on our Exchange 2013 server. After adding extra space to the VM one of our two databases won't mount.

eseutil /mh shows dirty shutdown.


eseutil /ml E01 shows one …

425 views

i want to check if the Windows server has the following software installed on it.

IBM DB2
IBM IMS
Unisys RDMS
Unisys DMS
Sybase
Oracle

I believe we can check this if there are services …

319 views

hi am in oracle 11gR2
when i did  SELECT SUBSTR('6210 - 14 - 242 - 8258', 10, 4) FROM DUAL; am geting -2
 
where emp = substr(emid,1,4))
and empcode= substr(emid,5,2))
and …

833 views

I'm working on a challenge on HackersRank, and brushing up on my SQL skills.  I'm given the following table 'Challenges':


So the challenge_id is unique in the table, and hacker_id is the id of …

419 views

is there any specific best practices on how and when to change page verification in MSSQL from torn page to checksum - and any specific precautions we should take before/after if it causes issues? is …

132 views

Have you ever had situations where a backup of a SQL database would not restore, and if so what kinds of issues can mean a SQL backup cannot restore into a live or test instance. we are reviewing how …

329 views

I am looking at the security of a progress database (now openedge). I wondered what the equivalent tool to SQL Server management studio would be for connecting to a progress/openedge database, to …

251 views

Hi Experts
    Is there any free tool which can automatically build the ERD (Enterprise Relationship diagram) of a Database ? (What I was looking is a diagram which shows the relationships based on …

432 views
Networking for the Cloud Era
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

I have been given a text file which I need to place the data into a MySQL table, Excel or Even Access.

The text file contains:
A | win
B | howdy
C | go home
D | have lunch
A | happy
B | sad

1247 views

I am migrating my 2008 databases to 2012 and only want to migrate Database that are used the most frequent by determining the Last Used / Updated Date. Not the create date or modified date.

My SQL…

1121 views
Data center

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.

052 views

pl see chart.{it includes data+index together} (SQL 2008R2)

after 10 years, db nearing 600GB.. what are best standards to break this for performance (perhaps by years of data, since all records …

829 views

I have read this article online:
https://www.developereconomics.com/five-popular-databases-for-mobile

Is SQLite a good option for Mobile Development to store data?

Is there any good …

426 views

Hi Experts,

I have a function that accepts some parameters and returns a results string.
See attached.

Now I need some help figuring out why the section below only works when the results …

729 views

I'm not highly skilled in SQL, and my query isn't working, and I'd like to know what I'm doing wrong.  I'm trying to write a query in MySQL to calculate a median.  My logic is straightforward:

1) …

434 views

An odd one here.

We originally had Exchange 2013 set up in a 2 mailbox server config, the servers were active active with 50% of the mail databases on each server. Recently we purchased a new SAN …

745 views

Have sql 2008 with about 25 or so Databases, with varying recovery models... backups have been failing so logs have the disk full, I want to set them all to simple and shrink them.  I know how to do …

430 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I'm not sure if I will be asking this correctly but here goes.

We use triggers fairly heavily in in our mariadb apps and have come across a situation where we would like mariadb to connect to a …

1943 views

Hello

I have two data centres - one in New York and one in Los Angeles. I have an application that will be located in both with standard Web/App/DB tiers.

Ideally, I'd like to have both data …

1061 views

Hi Experts,

I have two identical tables both have 4 columns, lets say Column1,  Col2, Col3 and Col4.

Now I need to get all records that exists in table1 and not in table2 by comparing all 4 …

928 views

I am using Navicat and I (finally) have Postgresql running.

I accept defaults as
Record delimiter LF
Text qualifier " (there aren't any - maybe there should be)

(CODE)

So I make both date …

967 views

I am a volunteer librarian at a designated  Historic Site that has a very small specialized library devoted to local history. It includes accessioned historic photographs , a vertical file of …

554 views

I am using Access 2016 to import a CSV file, format the data and then export a new CSV.

(The exported CSV must have data in specific columns and specific formats, so that it can be uploaded to the …

237 views
Show more content
201506-LO-Top-001

Databases

53K

Solutions

61

Articles & Videos

33K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Related Topics

  1. Microsoft SQL Server
  2. Query Syntax
  3. Microsoft Access
  4. Microsoft SQL Server 2005
  5. MySQL Server
  6. Oracle Database