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
Microsoft Developer

Developer ´& Designer of Business Solutions based on SQL Server, Excel and Access

Article
If Function

Understanding and Using PowerFX IF Function Effectively

In this post, I'll use examples to illustrate how the "If" function operates.
Article

New SQL features on Oracle 21c Database

In this article we will see what new features are been release by Oracle for making SQL much efficient .
Article

Ways To Load Large Tables In Oracle

In this article, we will see the options and faster ways to load large tables in Oracle database.
Article

What to use? ORM vs Stored Procedures

1
Today we will look at a very common debate while developing the data access layer. This is to decide if we want to use stored procedures and keep our logic in the database or do we want to use an ORM like Entity Framework and keep all logic in our middle tier C# code and use the database as a store.
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.
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.
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.
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.
Article

How to Fix SQL Server Login Failed Error 18456 State 38

One of the most common issues faced while connecting to a SQL Server instance is "Login failed for …
Article

SQL Server Database Health Checks

An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
Article
Estimate Execution time of DBCC CHECKDB

Estimate Execution time of DBCC CHECKDB

A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.
Article
Python & SharePoint - Getting Data, Creating Lists and Uploading Files

Python & SharePoint - Getting Data, Creating Lists and Uploading Files

For most Python developers, Microsoft business software is either a great unknown or a necessary evil. Microsoft SharePoint is no exception. Yet, knowing how to integrate Microsoft SharePoint from Python can make all the difference. Plus, it is not that complicated!
Article
SA

Deny SA account for Developers in Microsoft SQL Server

This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.
Article

Storage savings with Microsoft SQL Server

This article shows how to use different types of data compression in SQL Server and they drawbacks.
Article
Converting BYTES to CHAR on Oracle Database

Converting BYTES to CHAR on Oracle database

In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
Article

Ranking rows in Microsoft Access

To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.
Article

Join (concat) values from one field from a table or query

3
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.
Article

Find and Replace String for SSIS for mass amount of packages

7
Using Powershell to Extract .dtsx files, search them and then replace the required string.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more