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
  • 59K Content
  • 7.7K Contributors

Expert Spotlight
Technical Director

Dynamic seasoned IT Professional with over 30 years experience. .Net and SQL Server expert

Troubleshooting Solution

I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.

110
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
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…
Article

Union All Handling in SQL Server

The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.
Article

Transform Text copied from Excel Table into Real Table in SQL

After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.
Article

How to Resolve DBCC CHECKDB Stuck in a Killed/Rollback State

This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
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 …
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. …
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
Troubleshooting Solution

SQL Server - running a stored procedure to run a SELECT statement that's passed as a parameter

30
I'm building a learning tool. A the client app will send a Exec statement to run a stored procedure, …
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

SQL - Select Same WeekDay from a Previous Year

30
Hi,

I would like to select the same WeekDay from a previous year.

For last year (e.g. comparing 2021 …
Troubleshooting Solution

update statistics of column store index

31
right now we are receiving a job failure message from an index statistics job:


and the statistics …
Article

Who filled transaction log of SQL Server database?

This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.
Troubleshooting Solution

Problem with Trigger insert

63
I am trying to get this trigger to insert the correct data. I seem to be losing the scope_identity …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more