Explore SQL on Experts Exchange

Expert Solutions for Your Tech Problems

SQLSQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....

Read more
  • 60K Content
  • 7.7K Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Adding different values from a table to find a specific sum value

251
There are times when I need to find a certain value out of a number of records. For example, assume …
Article

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Post

This is a cool tool to help visualize explain plans in …

This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Post

So excited for SQL Server 2017. …

So excited for SQL Server 2017.
Post

Sequential or Random Rows in Microsoft Access  Study my …

1
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Troubleshooting Solution

Know which batch is in stock on a selected date

byrp
31

Hi,

I have a problem with this query that I just realized, with the test data everything seemed fine,

Troubleshooting Solution

Display the name of the user according to his chosen time

39

Hello,

I'm asking for your help with filling out a table.
I am unable to display the name of the user

Troubleshooting Solution

Search specific field name

25

Is it possible to search a specific field name in multiple tables using query or from menu options

Troubleshooting Solution

T-SQL script to generate a calculation based on some numbers

48

Hello Experts,

I have a table with column containing these values. I need to create a SQL Script for

Post

It's interesting to see where the SQL co-creator sees …

It's interesting to see where the SQL co-creator sees similarities between SQL and NoSQL. …
Troubleshooting Solution

Optimize the SQL

22

Optimzing this SQL which is taking huge time, 




My   acl table is having 30679616 rows and ACCT  

Article

A SQL Tidbit: Conditional Aggregates

17
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't
Article

SSMS MSSql Change the column length of a table with a primary key and retain the IDs

I was surprised on searching desperately not to find a clear answer for what would appear outwardly to be a fairly simple operation in a Microsoft SQL database server. Alter the column width of a text field from 48 to 60 and retain the primary key. So here's one for anyone facing similar issue.
Post

I haven't worked with SQL Server since 2001. Now I'm trying …

9
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Article

Beware of Between

12
'Between' is such a common word we rarely think about it but in SQL it has a very specific …
Troubleshooting Solution

Dynamic changing of dblink in Oracle sql

byRads R
137
How to concatenate dblink which will change dynamically in a Oracle SQL Statement at the end of the …
Research Solution

List of Customers who did not make A Purchase Within a Period

byfb1990
33

Hello Experts,

Slightwv provided me a solution to the question raised in the URL below:  

Troubleshooting Solution

DB2 SQL - find uptime values in a table

163
Hi all,

I have hundreds of identical tables - one for every hour:
        I_YEAR INTEGER NOT …
Article
Configure SQL Server Log Shipping

Some Useful Tips to Configure SQL Server Log Shipping

With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary database server.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more